We will export email metadata from Gmail using the Quick Extract mode:

1. Select  “Quick Extract” 

2. Select Gmail from the Email Sources list and select the folder that you want to extract messages from.

If you are using 2 -Step verification read the following article: 

http://docs.maildev.com/article/39-generating-an-application-password-when-2-step-verification-is-enabled-in-gmail

3. Select Extract Data from the Email Targets list, select the fields that you want to export and select Excel as Target format

4. Press Start to execute the extraction job

Unable to display content. Adobe Flash is required.