Loading...
Master merge fields to personalize your email campaigns. Learn how to set up sheet headers, insert merge fields in subject lines and email bodies, and preview personalized emails before sending.
Merge fields are placeholders in your email template that get automatically replaced with real data from your Google Sheet when a campaign is sent. Instead of writing "Dear Customer", you write "Dear {{First Name}}" — and every recipient gets a message that addresses them by their actual name.
MassyMail supports two placeholder formats for merge fields:
{{Column Header}} — double curly braces{Column Header} — single curly bracesBoth formats work the same way. The text inside the braces must match the corresponding column header in your Google Sheet exactly (trimmed, but case-sensitive). If no match is found, the placeholder is left unchanged in the email.
Your merge fields are driven entirely by your sheet's column headers. Before writing your template, set up your Google Sheet with descriptive, clean column headers in row 1. For example:
Each header becomes available as a merge field. Avoid special characters in column headers (other than spaces), and don't add leading or trailing spaces as these affect whether the placeholder matches.

A personalized subject line stands out in a crowded inbox. In the MassyMail template editor, click into the Subject field and type or paste your merge field in curly braces wherever you want personalization. For example:
"{{First Name}}, here's your invoice for {{Month}}"
You can also use the Merge Fields insertion button in the editor toolbar to pick a field from a dropdown based on your current sheet's headers, which avoids typos.
Click anywhere in the body editor and insert merge fields the same way. You can reference any column from your sheet. Some effective ways to use merge fields in the body:
There's no limit to how many merge fields you use in a single template. Every placeholder is resolved independently at send time for each recipient.

Before sending your campaign, use MassyMail's preview panel in the campaign workspace to see exactly what your email will look like for each recipient. The right-hand preview panel shows the email with merge fields substituted using your actual sheet data.
Use the next / previous row navigation arrows to scroll through your recipient list and check a sample of rows — paying particular attention to any recipients who may have unusual data (e.g. missing a company name, or a very long first name that might break formatting).
When you're confident the emails look correct, click Send Test Email to receive a real copy in your inbox before committing to the full send.

{{first name}} won't match a column named "First Name". Use the insert toolbar to avoid typos.{{Company}}), it means the placeholder didn't match any column header. Check spelling and look for extra spaces.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.