Works with Google Sheets

Turn every row into a document

Make certificates, invoices, offer letters or receipts from a Google Docs template and a spreadsheet. One PDF or Doc per row, saved to Drive, linked back in the sheet, and emailed if you like.

Demo video coming soon

How it works

1

Make a template

Write a Google Doc and put placeholders where the data goes: {{Name}}, {{Course}}, {{Amount}}. Each one must match a column header in your sheet.

Make a template
2

Paste the link

Open your spreadsheet, choose Extensions → Row to Doc → Open, and paste the template's link. The sidebar shows your column headers as placeholders.

Paste the link
3

Test with the first row

Click Test with first row. A sample PDF appears in your Drive folder and a link to open it shows in the sidebar. Nothing is written to the sheet yet.

Test with the first row
4

Create documents

Click Create documents. A progress bar runs through every row, and a Document link column fills with the file for each one. Add rows later and run again; finished rows are skipped.

Create documents

Top features

PDF, Google Doc, or both

Choose what to keep. PDFs for certificates and receipts; Docs when someone still needs to edit. Learn more

PDF, Google Doc, or both

Placeholders from your headers

Every column header is a placeholder, shown as a chip in the sidebar. Text, headings, tables and images in the template are kept. Learn more

Placeholders from your headers

Links written back

A Document link column records the file for each row, so you always know what was made and nothing is generated twice. Learn more

Links written back

Email each document

Send every file to the address in a column, with the PDF attached and a personalised subject and message. Learn more

Email each document

Large sheets, no timeouts

Rows are processed in small batches with a progress bar and a Stop button, so a thousand-row sheet works. Learn more

Large sheets, no timeouts

Narrow permissions

The add-on only creates files; it never asks for access to your whole Drive. Templates are read, never changed. Learn more

Narrow permissions

Ready to try it? It's free to start.

Install Row to Doc

Plans and pricing

Start free. Upgrade when you need more.

Free

$0
  • 20 documents a month
  • PDF, Doc or both
  • Document link column and Activity log
  • Help Center support
Install

Pro

$29 / year per user
  • Unlimited documents
  • Email each document with the PDF attached
  • Email support within 1 business day
Upgrade

Google's own email limit applies when you email documents, about 100 a day on a free Gmail account and 1,500 on Google Workspace.

Frequently asked questions

Can I use my existing Google Doc as the template?

Yes. Any Google Doc you can open works. Add placeholders where the values should go. Word files must be converted to Google Docs first (File → Save as Google Docs).

Which parts of the template are copied?

The body of the document, including text formatting, headings, tables, lists and inline images. Headers and footers are not copied in this version.

How do I regenerate a document?

Clear that row's cell in the Document link column and run Create documents again.

Where do the files go?

Into a Drive folder the add-on creates with the name you set (default "Generated documents"). You can move or rename the folder afterwards.

What counts as a document?

One row processed. Choosing "PDF and Google Doc" still counts as one.

Can I cancel?

Yes, any time. The licence stays active until the end of the year you paid for.

Permissions it asks for, and why

We ask for the smallest set Google allows. Full details in the privacy policy.

PermissionWhy it is needed
spreadsheets.currentonlyRead the rows of the spreadsheet the add-on is open in and write the Document link column. No other spreadsheet.
documentsOpen the template Doc you paste and read its contents. Google offers no narrower permission for reading a Doc by link. The template is never modified.
drive.fileCreate the output folder, the generated Docs and PDFs. This permission only covers files the add-on itself creates; it cannot see the rest of your Drive.
script.send_mailEmail each document, if you turn that on.
script.external_requestTalk to Google's own Drive API to create the folder and save the files. No other address is contacted.
script.container.uiShow the sidebar inside Google Sheets.
userinfo.emailKnow which Google account installed the add-on, for the licence.

Who uses it

Training centres issue course certificates. Small businesses send invoices and fee receipts. HR teams produce offer letters. Event organisers print badges and confirmations.