Google Apps Script – emails to spreadsheet by a given pattern – part 041.

In this tutorial, I will show you how you can add emails from your Gmail account into a spreadsheet by a given pattern.
First, you need to create a spreadsheet and use the Google Apps Script editor from the main menu Extensions – Apps Script.
The script will need to run with the onOpen function and this will create a new Get Emails on the spreadsheet menu entry.
Using this new entry will add all of the emails sent by into the spreadsheet.
You can change this line of source code with any email address:

This screenshot show you the output of the running script:

This is the source code I used:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.