Install and create your first documents

From a template and a sheet to a folder of PDFs in about five minutes.

1. Prepare the sheet

Row 1 holds the column headers; every row below is one document. For certificates, that might be Name, Course, Email, Completed on.

2. Prepare the template

Create a Google Doc and write it as the finished document should look, putting a placeholder wherever a value goes: {{Name}}, {{Course}}, {{Completed on}}. The text inside the braces must match a column header (capitalisation doesn’t matter). See templates and placeholders.

3. Install and open the add-on

Install from the Google Workspace Marketplace. Open the spreadsheet and choose Extensions → Row to Doc → Open.

The setup sidebar

5. Test with the first row

Click Test with first row. The add-on makes one file (named with “(test)”), shows an open link in the green bar, and writes nothing to the sheet. Open it and check the placeholders were filled.

6. Create documents

Click Create documents. A progress bar counts through the rows. When it finishes, a Document link column holds the file for each row.

After creating documents

Rows that already have a link are skipped, so you can add rows later and run again. To redo a row, clear its link cell first.