Skip to content

How to Use a Google Doc as an Email Template in Mail Merge

The Google Docs editor sends a Google Doc as your email. You write and format the message in Docs, and Mail Merge turns the document into an email when the campaign runs.

  1. Your team can review it. Share the Doc so others can comment, suggest changes and fix typos before anything goes out.
  2. You already know the editor. Headings, bold, lists, links, tables and images all work the way they do in any other Doc.
  3. Fixes don’t need the add-on. Mail Merge reads the Doc each time the campaign runs, so a correction you make in the Doc goes into every email sent after it.

Say you want to send a year-end thank you letter to your clients and show them what the studio made. Your sheet has First Name and Company columns, and your business partner wants to read the merge letter before it goes out. That’s a good fit for a Google Doc.

Write the letter in a new Google Doc and format it like any other document:

  1. Your logo at the top. Go to Insert > Image and upload your logo.
  2. A heading with a merge field. Type Thanks for a great year, {{First Name}} and set it as Heading 1.
  3. A personal opening. For instance, Working on the {{Company}} brand was one of our highlights this year. Bold the merge field to make the company name stand out.
  4. Your best projects, with links. Add a Heading 2 called What we made in 2026, then a bulleted list of projects. Select each project name and press Ctrl+K (Cmd+K on a Mac) to link it to its case study.
  5. An offer that stands out. Go to Insert > Table and add a small table with the offer, like 10% off any project booked before January 31, and a book a call link to your calendar.
  6. Your sign-off. End with your name and studio. An image of your handwritten signature adds a personal touch.
Year-end client letter in Google Docs with the Willow Lane logo, a heading with the First Name merge field, a bold Company merge field, linked project names, an offer table and a handwritten signature
Format the Doc like any other document. Merge fields go wherever each client's details belong.

Share the Doc with your partner so they can comment or suggest changes. When the letter is final, resolve the comments and move on to Mail Merge.

  1. Go to Extensions > Mail Merge with Attachments > Open Mail Merge and move to the Template step.

  2. Under Editor, open the Other editor… menu and choose Google Docs.

  3. Type the Subject, and optionally the Preview text. Mail Merge doesn’t use the Doc’s title as the subject.

  4. Click Choose next to Google Doc and pick your document from Google Drive.

    Mail Merge Template step with Google Docs chosen as the editor, a First Name merge field in the subject, and the Choose button next to the Google Doc box
    Choose Google Docs under Other editor, then click Choose to pick the Doc.
  5. Click Send Test Email and compare the email with the Doc.

The picker only lists Google Docs. To use a Word file, open it in Google Docs and go to File > Save as Google Docs first.

  1. If you delete the Doc or stop sharing it with your Mail Merge account, the campaign stops with an error.
  2. If you edit the Doc while a campaign is still sending, people on later runs get the new version. Finish your edits before you click Send Emails.
  3. Resolve or delete comments before you send, so they don’t show up in the email.
  4. Fonts other than common ones like Arial, Georgia and Times New Roman may show as the reader’s default font.
  5. Check the test email for extra white space around the text. It comes from the Doc’s page margins, and smaller margins in File > Page setup reduce it.
  6. Gmail cuts off emails larger than 102 KB and hides the rest behind a “View entire message” link. A long Doc with many images can go over that.