(Optional) Create a label in your Gmail account that will contain all of the drafts created by this Zap. You can map the email address to the To field to designate the recipient.Īdd your template message and map the fields from your spreadsheet to fill in some personal details.
Select your sheet and be sure to select “Trigger Sheet” as the worksheet:įor the action step, select Create Draft in Gmail. Now that our sheet is set up, let’s build the Zap!Ĭreate a trigger on a New Spreadsheet Row in Google Sheets. Your Zap will fire when a new spreadsheet row is added, so we’ll want the existing data to be close at hand to copy/paste once the Zap is set up.Ĭreate a header row in your Trigger Sheet that matches the order of the data in your Contacts List sheet, and create a second row of test data. Name the second tab “Contacts List” - this worksheet will be the “holding tank” for your data. Name one tab “Trigger Sheet” - this is the sheet you will select in the Zap. Let’s say you have donation records that show your donor’s name, donation amount, and the program they’ve donated to.Ĭreate a Google Sheet spreadsheet with two worksheet tabs. You don’t want to send the same stock message to every donor, but you also don’t want to spend hours creating email drafts manually. Have you ever wanted to do a mail merge for a small batch of emails, but you’d like the option to customize the message before sending?įor example, let’s say you need to send 100 thank you emails to donors. Hi there, this is Erin Oz from the Zapier Support Team with a tip for updating columns in.
0 kommentar(er)
