Menu Close

Tutorial: Create and Distribute Automated Mailing List with Google Sheets & Google Apps Script

google drive storm

Create Google Sheet

Browse to drive.google.com and create a New Google Sheets -> Blank Spreadsheet.

Example table for mailing-list

You can use or adjust a default table template, or create 4 columns that resembles the screenshot. You can achieve this tables look by selecting a range of cells in the sheet and using the menu go to: format -> convert to table. The column types for name, email and sent are all plain text.

Related Posts