GPT for Google Sheets, Docs AI, Slides, Forms

HTML Email Mail Merge in Gmail with Google Sheets

Send formatted HTML email campaigns with a Gmail mail merge from Google Sheets: safe layout, merge tags, links, images and attachments where supported, preview and test sends, and responsible delivery.

HTML Email Mail Merge in Gmail with Google Sheets

Want your Gmail mail merge to look polished instead of plain text? Mail Merge for Gmail and Google Sheets lets you build personalized campaigns from a spreadsheet and send formatted messages — headings, links, a clear call to action, and a signature — with merge fields pulled from your Sheet columns.

Try Mail Merge for Gmail and Sheets →

Formatting and rich-email support can vary by product version and by how each recipient’s email client renders messages. Verify your exact setup with a test send before launching a large campaign, and avoid assuming a layout will look identical in every inbox.

When to use HTML or rich formatting in a Gmail mail merge

Rich formatting is worth it when presentation affects the response. Use it for branded updates, newsletters, event invitations, partner outreach, and announcements where a clear structure and a visible call to action help.

Plain text is often better for cold, one-to-one-style sales or recruiting notes, where a simple personal message can feel more authentic and may avoid looking like a mass mailing.

What “HTML email” means in a Gmail and Sheets workflow

In a Gmail mail merge, an HTML or rich-formatted email simply means the body carries formatting — bold text, headings, links, lists, and sometimes images — rather than raw plain text. Your merge tags still pull per-recipient values from Sheet columns; formatting just controls how the message looks.

The practical goal is a message that is easy to scan, has one obvious next step, and keeps personalization accurate for every row.

Safe campaign layout

A reliable formatted campaign usually has the same building blocks:

  1. Subject line — specific and honest, personalized with a merge field only where it adds clarity.
  2. Greeting — Hi , with a sensible fallback for blank names.
  3. Body — short paragraphs, one idea each, with the most important point near the top.
  4. Call to action — a single, clearly labeled link or button.
  5. Signature — real name, role, and company.
  6. Footer / unsubscribe — include opt-out language and any required identification for marketing-style sends.

Build a formatted Gmail campaign →

How Sheet columns and merge tags fit inside formatted messages

Merge tags work the same way in a formatted message as in plain text — they reference columns such as first_name, company, or offer. A few rules keep formatted campaigns clean:

  • Keep merge tags out of links and image URLs unless you have verified that per-row values are correct.
  • Provide fallbacks for empty fields so a greeting never reads “Hi ,”.
  • Avoid stacking many merge tags in one sentence, which makes errors harder to spot.
  • Keep one column, such as reviewed, to confirm a row is ready before sending.

Formatted campaigns add a few things that can break if unchecked:

  • Links — confirm every link resolves to the right page and uses HTTPS; test any merge-tagged link on several rows.
  • Images — image and inline-image support depends on the product and the recipient’s client; many inboxes block images by default, so never put essential information only in an image.
  • Attachments — where attachments are supported, confirm the correct file or per-row link before sending.
  • Tracking — where tracking is supported, decide what you actually need (opens, clicks, replies) and avoid over-instrumenting a simple message.

Preview and test-send checklist for formatted campaigns

Before a full send, run a quick QA pass:

  1. Send a test to yourself and one teammate.
  2. Open the test on desktop and mobile.
  3. Check the greeting, merge fields, and any fallbacks on multiple sample rows.
  4. Click every link and the main call to action.
  5. Confirm images load or degrade gracefully when blocked.
  6. Verify the signature, footer, and opt-out language.

See the dedicated preview and test-send guide for a deeper QA workflow.

Common formatting mistakes that hurt replies or deliverability

  • Heavy, image-only emails that look like ads and may be blocked.
  • Too many fonts, colors, or competing buttons that bury the call to action.
  • Broken or mismatched merge tags inside links.
  • Missing plain-text clarity, so blocked images leave the message empty.
  • No opt-out or sender identification on marketing-style sends.

HTML email mail merge FAQ

Can I send formatted HTML email with a Gmail mail merge from Sheets?

Mail Merge for Gmail and Sheets is positioned for personalized campaigns that can include formatting where supported. Confirm the exact formatting features in your product version and run a test send before a large campaign.

Will my formatted email look the same in every inbox?

Not necessarily. Email clients render HTML differently and many block images by default. Keep layouts simple, avoid putting essential information only in images, and test on desktop and mobile.

Do merge tags work inside formatted emails?

Yes. Merge tags pull per-recipient values from Sheet columns regardless of formatting. Add fallbacks for empty fields and avoid placing unverified merge tags inside links.

Should I use HTML formatting for cold outreach?

Often a simple, near-plain message works better for cold sales or recruiting notes, because it reads as personal. Reserve richer formatting for newsletters, invitations, and branded updates.

What should I check before sending a formatted campaign?

Check consent and relevance, merge fields and fallbacks, every link, image behavior when blocked, attachments where used, opt-out language, Gmail/Workspace limits, and a small test batch.

Send a formatted Gmail campaign from your Sheet

Build the list in Google Sheets, draft a clean formatted message, preview several rows, and send personalized messages with confidence.

Try Mail Merge for Gmail and Sheets →