7 min read
Mail Merge Google Sheets to Google Docs (Step-by-Step)
Mail merge Google Sheets rows into personalized Google Docs and PDFs. Follow a test-first, step-by-step setup and install Sheet2Doc free.
Quick answer: mail merge Google Sheets to Google Docs
To mail merge Google Sheets into Google Docs, use one spreadsheet row per document, add matching placeholders such as {{Name}} to a reusable Google Doc template, then generate a personalized file for each row. Sheet2Doc can create an editable Google Doc, a PDF, or both and write the result back to the sheet.
This workflow is useful for certificates, invoices, letters, reports, approvals, notices, and any repeatable document where the layout stays consistent but the details change for each recipient or record.
Step 1: Prepare the Google Sheet
Use one row per document and one column per value you want to merge. Keep the first row as clear, unique headers because those headers become the fields available to your template.
- Use headers such as Name, Email, Date, Amount, Course, or Address.
- Keep dates and numbers consistently formatted before starting the merge.
- Remove blank rows from the middle of the batch.
- Include a recipient email column only when documents should be delivered automatically.
Step 2: Build the Google Doc template
Create the document exactly as you want the finished files to look. Insert placeholders that match the sheet headers, using the Sheet2Doc format such as {{Name}}, {{Date}}, and {{Amount}}. The surrounding text, tables, images, headers, and formatting remain part of the template.
Keep each placeholder together as one piece of text. A placeholder that is split across different styles can be harder for a merge tool to recognize reliably.
Step 3: Install and open Sheet2Doc in Google Sheets
Install Sheet2Doc from the Google Workspace Marketplace, open the spreadsheet, and choose Extensions, Sheet2Doc, then Open Sheet2Doc. Select the current sheet tab, choose the Google Doc template, and load the merge fields.
Choose whether the output should be an editable Google Doc, a PDF, or both. You can also select the destination folder, set a file-name pattern, and map the optional email column.
Step 4: Test one row before running the batch
Generate one document first and inspect every merged value. Confirm the file name, folder, page layout, date and number formatting, blank-field behavior, and email recipient before processing the remaining rows.
A one-row test catches template and mapping problems while they are still easy to fix. After the result looks right, run the full batch and use the status columns and generated-file links written back to the sheet as the audit trail.
Mail merge Google Sheets rows into PDFs, Docs, or both
Use Google Docs when recipients or teammates need to edit the generated document. Use PDFs when the layout should stay fixed for delivery, printing, or archiving. Generating both gives you an editable working copy and a stable distribution copy.
Common mail merge problems to check
Most failed or incomplete merges come from mismatched field names, inaccessible templates, inconsistent source data, or running a large batch before testing. Check the basics before changing the workflow.
- Make every placeholder match its Google Sheets header exactly.
- Select the template through the file picker so Sheet2Doc receives access to it.
- Use a small test batch when changing a template or output setting.
- Review the status and generated-file URL columns before rerunning completed rows.
Frequently asked questions
Can Google Sheets mail merge directly into Google Docs?
Google Sheets and Docs do not include a simple native workflow that creates a separate templated document for every spreadsheet row. Sheet2Doc adds that workflow as a Google Workspace add-on.
Can I use a Google Doc as the mail merge template?
Yes. Format the Google Doc normally and add placeholders such as {{Name}} that match the column headers in the source sheet.
Can the merge create both Google Docs and PDFs?
Yes. Sheet2Doc can generate an editable Google Doc, a PDF, or both for each selected spreadsheet row.
Can each PDF be emailed to a different person?
Yes. Map the recipient email column and Sheet2Doc can deliver each generated PDF to the address on the matching row.
Sheet2Doc
Put this workflow to work
Start from the product page for setup details, or install the add-on from the Google Workspace Marketplace.