Prepare the sheet
Use one row per recipient or record. For a certificate, start with Name, Course, and Certificate ID columns and one sample row.
Sheet2DocMail merge Google Sheets to Docs and PDFs.
Create personalized certificates, letters, and invoices from your spreadsheet rows. Sheet2Doc fills your Google Docs template with each row’s details, saves a Doc, PDF, or both, and writes the output links back to your sheet.
25 generated documents per month free. No coding required.
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}}
Watch the 50-second demo
From spreadsheet rows to personalized certificates
Follow a real recorded workflow: choose a Google Docs template, select an output folder, generate files, and open the resulting PDF. This demo uses fictional sample data with email delivery off.
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
Design your Google Doc and add placeholders that match your headers, such as {{Name}}, {{Course}}, and {{Certificate ID}}.
Generate and review
Open Extensions → Sheet2Doc → Open Sheet2Doc. Select your template and folder, choose Docs, PDFs, or both, and generate one row. Review the output before running a batch.
Compare your options
Google Sheets mail merge vs exporting a sheet to PDF
A spreadsheet PDF and a mail merge produce different results. Export the sheet when you want its table layout. Use Sheet2Doc when each row should become a personalized letter, certificate, or invoice.
| What matters | Sheet2Doc | Export Sheets to PDF | Manual Google Docs |
|---|---|---|---|
| What you get | A personalized document for each processed row | A PDF of the sheet or selected cells | A document you fill in yourself |
| Document layout | Your reusable Google Docs template | The spreadsheet's print layout | A Google Doc you edit for each recipient |
| Handle many records | Merge spreadsheet rows in a batch | Export the selected spreadsheet content | Repeat the copy-and-edit steps |
| Find the generated files | Doc and PDF links written back to the sheet | Save and organize the exported PDF | Save and organize each document yourself |
| Best fit | Personalized documents from existing rows | Sharing or printing the spreadsheet itself | A few documents needing individual edits |
Example: certificates for a class
Give each person a row with their name, course, and completion date. Sheet2Doc fills a certificate template for each row. Exporting the roster to PDF instead produces a printable roster, not individual certificates.
Need a document after each new form response?
Form2Doc starts from a new Google Form submission. Sheet2Doc starts from spreadsheet records. Choose the starting point that matches how you collect and review the information.
Sources checked : Google Sheets printing and PDF documentation. Features and plan limits can change.
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
Can I generate certificates in bulk from Google Sheets?
Yes. Put each recipient on a separate row with columns such as Name, Course, and Certificate ID. Add matching placeholders to your certificate template, then use Sheet2Doc to generate a personalized Google Doc, PDF, or both for each row. Test one row before running a batch.
Is this the same as exporting a Google Sheet to PDF?
No. Exporting a spreadsheet to PDF preserves the sheet layout. Sheet2Doc uses each row to fill a separate Google Docs template, creating personalized documents such as certificates, letters, or invoices. It does not convert PDFs into spreadsheet data.
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.