Mail merge Google Docs, one PDF per row

Bring a Google Doc as your template, upload a spreadsheet with your data, and DocuPotion generates a separate, pixel-perfect PDF for every row. No add-on to install, no copying the document by hand, and each PDF matches your Doc exactly.

50 free documents No credit card Set up in minutes
Google Doc
Dear {{student_name}},
{{programme}}
PDF
Dear Maria,
BA Business Administration
G24.9/5 Rated on G2 by real users
860,000+
Documents generated to date
2,000+
Documents generated every day

Google Docs has no built-in mail merge, so people reach for a Workspace add-on or copy the document by hand for every record. Even with an add-on there is friction: you set it up, run every batch through it, and each run leaves temporary copies behind in your Drive, and the simpler ones struggle with line items and totals. DocuPotion does it directly. Use your Google Doc as the template, upload a spreadsheet, and get one finished PDF per row, exported with Google's own renderer so each file looks exactly like your Doc. It is the same idea as a PDF mail merge, with your Google Doc as the source. Try it below.

Try it yourself

A real, read-only Google Doc template on one side and a sample spreadsheet on the other. Run the batch and watch each row become its own PDF.

A real Google Doc, with merge fields wherever data should be filled in. Read-only here, fully editable in your own Google Drive.

Open the Doc
Google DocsAdmission Offer Letter· Read-only

Here's how it works

From one Google Doc to a finished PDF for every record.

1

Bring your Google Doc

Use a Google Doc as your template and type merge fields like {{name}} wherever the details change. It stays in your own Google Drive, so you keep the original.

2

Add your spreadsheet

Upload a spreadsheet with your data: CSV, Excel or Google Sheets. Each row becomes one document, with your columns mapped to the merge fields in the Doc.

3

Generate a PDF per row

DocuPotion fills the Doc for every row and returns a separate PDF for each, exported with Google's own renderer so every file matches your Doc exactly. Map an email column and each PDF can be sent straight to its recipient.

A Google Doc template with merge fields, mail merged into an individual PDF per row

Not just another Google Docs add-on

Most Google Docs mail merges mean installing a Workspace add-on, running every batch through it, and clearing out the temporary copies it leaves in your Drive, and the simpler add-ons struggle with repeating line items and totals. DocuPotion connects to your Google Doc once and returns a separate, correctly named PDF for every row.

Because your Google Doc is the template and Google renders each file, the output is pixel-perfect, the same fonts, spacing, tables and headers as your Doc. Map an email column and each recipient can get their own PDF automatically.

  • Nothing to install. Connect your Google Doc once. There's no add-on to install in Google Docs.

  • Line items and totals. Repeat a table row for line items, and total the columns automatically.

  • Not just Google Docs. The same merge works with PDF and AI-built templates, plus your integrations or REST API.

Frequently asked questions

How do I mail merge in Google Docs?

Use your Google Doc as a template and add merge fields like {{name}} where the details change, then connect a spreadsheet with your data. DocuPotion fills the Doc once per row and returns an individual PDF for each record, so there is no Workspace add-on to install and no copying the document by hand for each one.

Can I get a separate PDF for each row instead of one combined document?

Yes. DocuPotion creates a separate, individually named PDF for every row in your spreadsheet, rather than one combined file.

Do I need a Google Workspace add-on?

No. You connect your Google Doc to DocuPotion once, and the merge runs there. There is no add-on to install in Google Docs and no developer needed.

Does the PDF match my Google Doc exactly?

Yes. DocuPotion fills your merge fields and exports each document with Google's own renderer rather than rebuilding it in another editor, so the PDF matches your Doc exactly: the same fonts, spacing, tables and layout.

Can DocuPotion email each merged PDF to its recipient?

Yes. Map a column in your spreadsheet as the recipient address and DocuPotion can email each person their own PDF as an attachment, with a subject and message personalised from their row. Email delivery is available on paid plans.

What can I use as the data source?

A spreadsheet: CSV, Excel or Google Sheets, where each row becomes one PDF. If you would rather generate documents one at a time as new data arrives, you can also drive the same Google Doc template from your existing tools through our integrations, or from your own app with our REST API.

Can I include line items or a total?

Yes. Repeat a table row and DocuPotion clones it for each line item in your data, and it can total a column for you, so quotes, invoices and reports with variable-length tables stay correct however many rows there are.

Do I have to use a Google Doc?

No. A Google Doc is one option. You can also build a template in DocuPotion's editor or upload an existing PDF, and mail merge a spreadsheet into any of them the same way.

Mail merge your Google Docs without the busywork

Bring a Doc you already use, upload your spreadsheet, and let DocuPotion turn every row into its own finished PDF. Start free with 50 documents, no credit card required.