Embedded Files
This article describes how to mail merge using HTML email templates in Google Sheets. Third-party HTML editors (such as Mailchimp) are useful for creating email templates for (marketing campaigns, newsletters, notifications, etc.), where greater control of the email layout is desired. The email template's HTML & CSS Code can then be dumped into the email body when merging to emails.
Available from only Google Sheets
Available from only Google Sheets
Step 1: Click New
Step 1: Click New
In Google Sheets, click on New in the Body Template field in the Mail Merge dialog box.
Step 2: Click Code button
Step 2: Click Code button
Click on the Code button to open code view.
Step 3: Insert code
Step 3: Insert code
Insert the code from your chosen third-party HTML editor in the code box.
You can also give your email template a name.
NOTE: Design view does not reflect the HMTL code inputted in code view. To see how your email appears prior to sending, follow the steps below.
Step 4: Insert and format text or *|merge fields|*
Step 4: Insert and format text or *|merge fields|*
Insert *|merge fields|* into your email body template by typing them directly into the code box.
Repeat this step for all required *|merge fields|*.
*|Merge fields|* are the column names found in the first row of data in your Google Sheet. You can further customize your template by adding images, file attachments, and hyperlinks.
NOTE: The Add Merge Field drop-down menu cannot be used in code view.
Step 5: Click Save
Step 5: Click Save
Click on Save to apply the changes.
Step 6: Click Send Test
Step 6: Click Send Test
Adjust the email settings according to your preferences, and then click on Send Test.
This sends a test email to an email address of your choice, so that you can see how your email appears prior to sending.
Step 7: Click Merge Emails
Step 7: Click Merge Emails
Once you are happy with the appearance of your email marketing campaign, click on Merge Emails to send your emails.
Report abuse