Prepare the sheet
Use one row per recipient or record, with clear column headers such as Name, Email, Date, and Amount.
Sheet2DocMail merge Google Sheets into personalized Docs and PDFs.
Sheet2Doc turns each spreadsheet row into a polished Google Doc, PDF, or both using a reusable template—then optionally emails each file and records its status in the sheet.
After installing: open a Google Sheet → Extensions → Sheet2Doc → Open Sheet2Doc.
Certificate rows
Course completion batch
| Name | Status | |
|---|---|---|
| Avery Chen | avery@example.com | Emailed |
| Marcus Lee | marcus@example.com | Generated |
| Priya Shah | priya@example.com | Pending |
Template: Certificate {{Name}} - {{Course}} - {{Date}}
Built for repeatable Google Sheets mail merge jobs
Pick a sheet, choose a Google Doc template, generate personalized files, email recipients, and keep a status trail without writing code.
Rows become documents
Use one Google Sheet row as one merge record for certificates, letters, invoices, reports, and approvals.
Google Doc templates
Add fields like {{Name}}, {{Course}}, and {{Date}} to a Doc template, then map them to sheet columns.
PDF and Doc output
Generate PDFs, editable Google Docs, or both, with custom file names and output folder routing.
Email delivery
Send each generated PDF to the email address in a row and write delivery status back to the sheet.
Three-step workflow
How to mail merge from Google Sheets to Google Docs
Create the template
Add matching placeholders such as {{Name}} and {{Date}} to the Google Doc you want to reuse.
Generate and deliver
Choose Docs, PDFs, or both, test one row, then run the full batch and optionally email each result.
25 free generated documents per month
Designed around drive.file instead of full Drive access
Files stay in the Google Drive folder you choose
Stripe handles subscriptions and invoices
Want your first merge workflow built for you?
Done-for-you Sheet2Doc setup starts at $199 for one template and workflow.
Frequently asked questions
How do I mail merge from Google Sheets to Google Docs?
Create a Google Sheet with one record per row, add matching placeholders such as {{Name}} to a Google Doc template, then use Sheet2Doc to select the template and generate a personalized document for each row.
Can a Google Sheets mail merge create PDFs?
Yes. Sheet2Doc can create an editable Google Doc, a PDF, or both for each spreadsheet row. You can also choose the destination folder and file-name pattern.
Can I email each mail-merged document automatically?
Yes. Map an email-address column and Sheet2Doc can send each generated PDF to the matching recipient while writing delivery status back to the spreadsheet.
Is Sheet2Doc free?
Sheet2Doc includes 25 generated documents per month for free, so you can test a real Google Sheets mail merge before upgrading.
Do I need Apps Script or programming experience?
No. Sheet2Doc runs as a Google Workspace add-on and guides you through selecting the sheet, template, output format, folder, and optional email delivery.