Loading...
Create professional email templates for your mail merge campaigns. Learn how to design templates with merge fields, format text, add images, and save templates for reuse in MassyMail.
To manage your email templates in MassyMail, open the add-on by clicking Extensions > MassyMail > Open in Google Sheets. Once the sidebar opens, click the Templates tab in the top navigation. This will show you a list of all your saved templates, including the name, subject line, and last updated date for each one.
If this is your first time using MassyMail, a starter template called "Massy Mail Starter Template" will already be here to give you a working example to build from.

Click the New Template button (or the + icon) in the templates list. This will open the rich template editor where you can write and format your email. Give your template a descriptive Template Name — this is only visible to you and helps you identify it in the dropdown when composing a campaign.
The Subject field is at the top of the editor. Your subject line is one of the most important parts of your email — it determines whether recipients open it. You can personalize the subject line using merge fields just like the body. For example:
"Hi {{First Name}}, your order #{{Order Number}} has shipped!"
A personalized subject line can significantly improve open rates compared to a generic one.
The body editor in MassyMail is a full rich-text editor powered by Lexical. You can:
Write your email as you want it to read for a single recipient. You'll use merge fields in the next step to personalize it for each person on your list.

Merge fields are placeholders that get replaced with real data from your Google Sheet when the email is sent. Click the Merge Fields button in the editor toolbar and select a field from your sheet headers. MassyMail supports two placeholder formats:
{{First Name}} — double curly braces{First Name} — single curly bracesBoth formats work identically. The field name must match your sheet's column header exactly (trimmed, case-sensitive). You can place merge fields anywhere in the subject or body.
When you're done writing, click Save. MassyMail will validate that the template name, subject, and body are all filled in before saving. Once saved, the template will appear in your templates list and in the campaign workspace dropdown, ready to use in your next campaign.
You can edit or delete any template at any time from the templates list. Deleting a template requires confirmation to prevent accidental removal.

{{Company}} literally). Double-check spelling and spacing.For a complete walkthrough of Gmail mail merge — including templates, scheduling, and tracking — see our Gmail Mail Merge: The Complete Guide. New to MassyMail? Install it free from the Google Workspace Marketplace.
Send personalized bulk email campaigns directly from Gmail using your Google Sheets data. Schedule campaigns, track opens and clicks, and manage templates without leaving Google Workspace.