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 without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 26 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 838 once and liked it 6 people.