Google Sheets/Gmail: Email Merge
Learn how to use a Google Apps Script to do email merge with information in a Google Sheet and a Gmail draft.
Instructions: https://developers.google.com/apps-sc...
Slides: https://doittraining.page.link/merges...
0:00 Intro
0:30 Copy Sheet
0:47 Adjust Spreadsheet Settings
1:13 Fill in Spreadsheet, Add/adjust columns
2:04: TIP, start with test data
2:16 Create Gmail template/draft
2:23 Add info from the sheet with curly brackets {{ }}
3:48 Add subject and copy it
4:09 Authorize and run Script
5:30 Adjust format of Email Sent date/time
6:00 Check what/how emails sent in Gmail Sent label
6:39 Resent an email
7:04 Add more row and re-run script
7:13 Modifications (e.g., send from another email address, cc/bcc, ReplyTo)
7:39 Access the Script
8:12 Modify optional parameters
To Send emails from a different address or alias: https://support.google.com/mail/answe...
Watch video Google Sheets/Gmail: Email Merge online, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 26 July 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 838 times and liked it 6 visitors.
