Can You Mail Merge In Google Sheets? How to and Options

How To Mail Merge In Google Sheets With Apps Script

The first method in Mail Merging with Google Sheets is by using an Apps Script.

I know what you’re thinking….I don’t know how to write an Apps Script!?

Well, you don’t have to! The script is readily accessible online.

Here’s how to use it:

• Click this link and copy the spreadsheet.
• Edit the dummy text and replace it with your own data.
•  Add or remove columns (optional) to include extra placeholder text in your emails.

Note: If you edit the ‘Recipient’ or ‘Email Sent’ columns, you must change the code within the Apps Script by selecting ‘Extension’ then ‘Apps Script.’

Next, you’ll need to create an email template inside your Gmail account.

This is the email that you want to merge your spreadsheet data with. To do this:

•  Craft an email draft within your Gmail account.
• Type any placeholder text within curly brackets that match the column names (e.g., {{First name}}).
• Make sure each placeholder text is formatted exactly the same as the column headers.
• Once you’ve drafted your email, copy the subject line.

Now you’re ready to initiate the script! To do this:

• Navigate to your spreadsheet and click ‘Mail Merge > Send Emails’ (you might need to refresh the page to view this menu).
• Authorize the script when prompted.
• If you see ‘This app isn’t verified’ within the OAuth consent screen, click ‘Advanced > Go to {Project Name} (unsafe).’
• Click ‘Mail Merge > Send Emails’ again.
• Paste the email template subject line, then click ‘OK’.

This will then run the script (mail merge spreadsheet data to your email template).

Once this is done, it will send your emails to all recipients within your spreadsheet.

And that is how you can Mail Merge in Google Sheets using an Apps Script!

If you want an in-depth walk-through of this Gmail Mail Merge process or want to review the code or modify the Mail Merge, check out this article.