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

By | 26/06/2022

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 catafest@yahoo.com 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.