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.

Google Docs mail merge options

How the common ways to mail merge a Google Doc compared.

MethodNo add-on neededSeparate PDFsLine itemsAutomationNo coding required
Manual copy & paste Yes YesManual No Yes
Google Workspace add-on NoVariesVariesVaries Yes
Google Apps Script Yes Yes Yes Yes No
DocuPotion Yes Yes Yes Yes Yes

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 you mail merge in Google Docs?

Not with Google Docs on its own, because it has no built-in mail merge. You can copy the document by hand for each record, add a Workspace add-on, or connect your Doc to a tool like DocuPotion, which fills your merge fields from a spreadsheet and returns an individual PDF for every row.

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.

Is there a Google Docs mail merge add-on?

Yes. There are Workspace add-ons that bring mail merge to Google Docs, though they vary in how they handle things like line items and totals, and they run entirely inside Google. DocuPotion is an alternative that connects to your Google Doc without installing an add-on, generates an individual PDF per row, and also works with PDF and AI-built templates beyond Google Docs.

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 mail merge Google Docs from Google Sheets?

Yes. Use your Google Doc as the template and connect a Google Sheet as the data, and DocuPotion turns each row into its own PDF, with your columns mapped to the merge fields in the Doc. A CSV or Excel file works the same way.

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.