Gmail Mail Merge from a Google Docs Template
Turn a Google Docs email template into a personalized Gmail campaign with Google Sheets data: paste it into a Gmail draft, add merge fields, test, track.
Gmail Mail Merge from a Google Docs Template (with Google Sheets)
If you draft polished email copy in Google Docs, you can reuse it as a mail merge template and send personalized Gmail merged with data from a Google Sheet — without rebuilding the message from scratch each time. This guide shows how to turn a Google Doc into a reusable template, connect it to your Sheet, and send personalized emails with Mail Merge for Gmail and Google Sheets.
Turn your Google Doc into a personalized Gmail campaign — start free →
Google, Google Docs, Gmail, and Google Sheets are trademarks of Google LLC, used here descriptively; DocGPT.ai Mail Merge is independent and not affiliated with or endorsed by Google. Details are general and current as of June 2026.
Why use a Google Doc as your email template
A Google Doc is a comfortable place to write and refine email copy: you get rich formatting, comments, version history, and easy sharing with teammates. Reusing that copy as a mail-merge template means your brand voice and layout stay consistent across campaigns, and you can update one source document instead of rewriting the email each time. The Doc becomes your drafting and review surface; the merge fills in the personalized details per recipient.
Set up your template Doc with merge fields
- Write the email body in a Google Doc. Keep paragraphs short and the structure clean.
- Add merge fields where personalization belongs. Use clear placeholders such as
{{First Name}},{{Company}}, or{{Renewal date}}that match the column headers in your Sheet. - Name fields exactly as your Sheet columns. Consistent names prevent blank or mismatched merges.
- Keep formatting simple. Plain links, basic emphasis, and a clear signature travel best into email.
A worked example. Suppose your Doc reads: “Hi {{First Name}}, I noticed {{Company}} is hiring on the {{Team}} team — here’s a quick idea.” Your Google Sheet then has columns Email, First Name, Last Name, Mail Merge, Company, and Team, one recipient per row. Each sent email swaps in that row’s values.
Connect the Doc to your Google Sheet data
Build a Google Sheet with one recipient per row, a column for every merge field, and Email, First Name, Last Name and Mail Merge in columns A–D (the addresses go in Email). Tidy the headers so they match your placeholders exactly — First Name, not firstname in one place and First name in another. Then paste your finished template text into a Gmail draft and run Mail Merge for Gmail and Sheets from that Sheet, so each row supplies the values for that recipient’s personalized copy.
Send personalized Gmail with the merged template (step-by-step)
- Paste your template into a Gmail draft. Copy the text from the Google Doc into a new Gmail message, keep the
{{merge fields}}, add the subject, and close it so it saves as a draft. - Open your recipient Sheet and choose Extensions → Mail Merge for Sheets™ Gmail™ → Launch. It checks that columns A–D are
Email,First Name,Last NameandMail Merge, and can create them. - Skip the mapping: there is none. Each placeholder is filled from the column whose header matches it exactly.
- Check the Sheet for empty cells, because an empty cell becomes empty text in the email.
- Start New Campaign, select the draft, and click Send Test Email (one message to you, filled with row 2’s data). Confirm it renders, then send to the list.
Keeping formatting, links & branding intact
When you move copy from a Google Doc into an email, check that links remain clickable, bullet lists render cleanly, and your signature and any logo display as intended. Open the test email on desktop and on your phone, and forward it to an address on another email client if you want to check there too. If something looks off, simplify the formatting — email clients are less forgiving than a Doc, so cleaner usually renders more reliably.
Adding attachments, tracking & planning follow-ups
If your template references a one-pager or proposal, attach it to the Gmail draft so every recipient gets it (personalized per-recipient files are on paid plans). Open and click tracking is on by default on every plan; click Refresh Email Status to see who engaged. A follow-up to non-openers is a separate send you set up yourself: copy those rows to a new tab, clear their Mail Merge cells, write a new draft, and launch again. Because the recipient list and the template are both reusable, recurring campaigns — monthly updates, renewal notices, onboarding emails — become repeatable rather than rebuilt each time.
Reusing & versioning templates for recurring campaigns
Keep your master copy in the Google Doc and treat it as the canonical version. When the message changes, edit the Doc, then paste the new text into a fresh Gmail draft. For variants — a different audience or season — duplicate the Doc and adjust, so you always know which version you sent. A short naming convention (for example “Q3 onboarding — v2”) keeps recurring sends organized.
Compliance & deliverability cautions
Personalized does not mean unlimited. Send only to permissioned, relevant contacts; keep copy specific and human; include a clear sender identity and an opt-out path where appropriate; and respect Gmail and Google Workspace daily sending limits. Test before each send and monitor bounces and replies so your sender reputation stays healthy.
Build your campaign from a Google Doc template — start free →
Related Mail Merge resources
- Mail Merge for Gmail and Google Sheets
- Mail merge templates (Gmail + Sheets)
- Mail merge HTML email (Gmail + Sheets)
- Gmail mail merge from Google Sheets
Google Docs template mail merge FAQ
Can I use a Google Doc as my mail merge template?
Yes. Draft your email body in a Google Doc with placeholders like {{First Name}}, then paste it into a Gmail draft and choose that draft in Mail Merge for Gmail and Sheets. Each placeholder is filled from the Sheet column with exactly the same header; there is no mapping step. The Doc is your drafting and review source; the merge personalizes each copy.
How do merge fields connect the Doc to my Sheet?
Each placeholder name in the template must match a column header in your Google Sheet exactly. When you send, the tool reads each row and swaps the placeholders for that recipient’s values.
Will my Google Docs formatting carry over to the email?
Basic formatting — links, simple emphasis, and a clean signature — generally carries over, but email clients render differently than Docs. Keep formatting simple and send a test to confirm it looks right before the full campaign.
Can I add attachments and follow-ups?
Attachments, yes: files attached to the Gmail draft go to every recipient, and personalized per-recipient files are on paid plans. Open and click tracking is on by default. Follow-ups are not automatic: to follow up with non-openers, copy those rows to a new tab, clear their Mail Merge cells, write a new draft, and launch again.
How do I keep these sends compliant?
Send only to permissioned, relevant contacts, keep copy non-spammy, include a clear sender identity and opt-out where appropriate, respect Gmail/Workspace sending limits, and test before each send.
Start with your template
If your email copy already lives in a Google Doc, you are most of the way to a repeatable, personalized campaign. Connect it to your Sheet and let Mail Merge for Gmail and Sheets handle the personalized send.
