Setup

  1. Create Gmail accout

  2. 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>/edit

  3. Visit Apps Script console

  4. Create new project

    Example name “Forward Emails”

  5. 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

  6. Create main script

    • go to the “Editor” section and add a new file

      call the file index.gs

    • populate it’s content from the latest release

  7. Create triggers - cronjobs

    In the top menu choose the setTriggers function from the drop down menu and click the “Run” button