How To Use Google Sheets Mail Merge
Step 1 formatting your spreadsheet.
How to use google sheets mail merge. Run your script to send emails. Instead of wasting time creating a google apps script to build a mail merge template you can use gmass to send emails in seconds. Create a sheet called data containing information to personalize the email create a sheet called data that contains the necessary information to populate the placeholders in the email template. A mail merge is an extremely useful tool for personalizing forms or emails for many individuals at once. How to send a mail merge with google sheets in gmass.
Yellowwebmonkey has the solution for you. You can set up a mail merge using google drive and an add on called autocrat. Autocrat makes it easy to merge data from google sheets into google docs or into a pdf. Alternatively you can download the right inbox extension that will allow you to do a mail merge within gmail. Here s a walkthrough guide on how to send a mail merge with google sheets in gmass.
Read the authorization notice and. In the copied spreadsheet click on custom menu item mail merge send emails.