How To Use Google Sheets Mail Merge
A mail merge is an extremely useful tool for personalizing forms or emails for many individuals at once.
How to use google sheets mail merge. Alternatively you can download the right inbox extension that will allow you to do a mail merge within gmail. 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. Here s a walkthrough guide on how to send a mail merge with google sheets in gmass. Create an apps script to read data from your sheet perform a mail merge and send out emails. Autocrat makes it easy to merge data from google sheets into google docs or into a pdf.
Step 1 formatting your spreadsheet. Instead of wasting time creating a google apps script to build a mail merge template you can use gmass to send emails in seconds. Run your script to send emails. You can set up a mail merge using google drive and an add on called autocrat. You ll need to head over here and make a copy of the gmail google sheets mail merge spreadsheet template.
How to send a mail merge with google sheets in gmass. A dialog box will appear and tell you that the script requires authorization.