Extract Email from your Gmail Mailbox
Manual Extract Email Addresses from Gmail Messages This is the premium version of the Google Script that extracts addresses from message headers and the message body.
Step 1 Click the link to create a copy of the Google sheet in your Google Drive.
Digital Inspiration www.labnol.org
Page 1
Extract Email from your Gmail Mailbox
Step 2 Enter the name of the Gmail label from which you wish to extract email addresses. For instance, enter inbox to extract mails from only your inbox, enter sent to process mails in the sent folder, or all if you wish to process your entire mailbox. Remember that Gmail label names are case sensitive.
Digital Inspiration www.labnol.org
Page 2
Extract Email from your Gmail Mailbox
Step 3 From the Gmail Addresses menu, choose Initialize.
Digital Inspiration www.labnol.org
Page 3
Extract Email from your Gmail Mailbox
Step 4 Google will now require you to authorize the script. Click OK.
Digital Inspiration www.labnol.org
Page 4
Extract Email from your Gmail Mailbox
Step 5 Click Accept as the Request for Permissions dialog. The script basically need to connect to your Gmail account to extract address and thus requires permission. You data is only available to the sheet in your own Google Drive and not shared with anyone else.
Digital Inspiration www.labnol.org
Page 5
Extract Email from your Gmail Mailbox
Step 6 Go to the Gmail Addresses menu again and click Start to begin the extraction process. You can close the Google sheet now.
Digital Inspiration www.labnol.org
Page 6
Extract Email from your Gmail Mailbox
Step 7 Once the extraction process is complete, you'll get an email with a link to the Google sheet. Click that link.
Digital Inspiration www.labnol.org
Page 7
Extract Email from your Gmail Mailbox
Step 8 Click the Gmail Addresses Menu and choose Remove duplicate to clean up the list. The final list will now be available in Column B.
Support For help: email: amit@labnol.org twitter: http://twitter.com/labnol web: http://www.labnol.org/
Digital Inspiration www.labnol.org
Page 8