Setup
Create Gmail accout
Create new Spreadsheet
Example name “Newsletter List”
Remember the Spreadsheet ID. Spreadsheet ID is the long string in the URL
https://docs.google.com/spreadsheets/d/<Spreadsheet ID>/editVisit Apps Script console
Create new project
Example name “Forward Emails”
Add required properties
click on “Project Settings”
scroll down to “Script Properties”
click “Add script property” and provide key-vaue pairs
Find required properties here
Create main script
go to the “Editor” section and add a new file
call the file
index.gspopulate it’s content from the latest release
Create triggers - cronjobs
In the top menu choose the
setTriggersfunction from the drop down menu and click the “Run” button