Merge Fields, Links and Images
Any column in your sheet can become part of the email. Here's what you can merge and where.
Last updated
The basics
A merge field is a column header in double curly braces. {{First name}} becomes the value in that row’s First name column.
| You write | Row 2 gets | Row 3 gets |
|---|---|---|
Hi {{First name}}, |
Hi Priya, | Hi Daniel, |
Quick question for {{Company}} |
Quick question for Northwind | Quick question for Acme Co |
- Matching ignores case and extra spaces.
{{first name}},{{First Name}}and{{ First name }}all find the “First name” column. - Everything else must match.
{{Firstname}}won’t find “First name”. The add-on refuses to send while a merge field doesn’t match a header, and names the field. - You don’t have to type them. In the compose window, Insert field lists your headers.
The values come from what the cell shows, not what’s underneath. A date formatted as “Oct 25, 2026” merges as “Oct 25, 2026”.
Where merge fields work
- Subject:
{{Company}} + Makeinfo - Body: anywhere, as often as you like
- CC, BCC and Reply-To:
{{Manager}}sends a copy to the address in that row’s Manager column
Empty cells
If a row has an empty cell for a field you used, that spot is left blank and the email still goes out. Before you send, the dialog warns you how many rows have an empty merge field.
So “Hi {{First name}},” turns into “Hi ,” for a row with no first name. Fill the gaps or filter those rows out before you send.
A different link for every row
To give each person their own link, such as a booking page, a proposal or a personalised demo, use the HYPERLINK formula in the sheet:
=HYPERLINK("https://example.com/proposal/northwind", "your proposal")
Put that in a column called, say, Proposal link, then write Here's {{Proposal link}}. in the email. Each person gets a clickable “your proposal” that goes to their own address. With no label, the URL itself is shown.
Only http:// and https:// links are turned into links. Anything else is merged as plain text.
Images
There are three ways to add an image:
- Image URL in the editor toolbar. The same image goes to everyone.
- Paste an image into the editor. Pasted images are sent inside the email and are limited to 100 KB in total, so use them for a small logo or signature, not a screenshot.
- A different image per row with the
IMAGEformula in the sheet:=IMAGE("https://example.com/badges/priya.png"). A{{Badge}}field for that column then shows each person’s own image.
Simple Mail Merge doesn’t send file attachments. To share a file, put it in Drive or Dropbox and merge in a link.
HTML mode
Switch the compose window from Editor to HTML to edit the raw HTML. Merge fields work the same way, and Insert field is still in the top right.
Every email also goes out with a plain-text version that’s created from your HTML automatically, for mail apps that don’t show HTML.
Get it first
Simple Mail Merge is in Google Workspace Marketplace review. Leave your email and we send the install link the day it goes live.
Request early access →