Docs & PDF Mail Merge automates PDF generation directly inside Google Workspace. Connect your Sheets data to a Docs template and produce branded, personalised documents in seconds.
Docs & PDF Mail Merge runs entirely within Google Workspace using your own Google Drive. No external servers receive your data.
{placeholder} syntax. The add-on replaces placeholders with your Sheets data automatically.Four steps from install to PDF — everything stays within Google Workspace.
Your Sheet is the data source. Each column becomes a merge field. The add-on reads only the active spreadsheet you authorise.
Pick any Google Doc from your Drive using the built-in Google Picker. Add {ColumnName} placeholders anywhere in the document.
Optionally define conditional logic. Save reusable text blocks and rules that automatically insert the right clauses per row.
Click Generate — PDFs are created and saved to a Docs & PDF Mail Merge – Output folder in your own Google Drive. No data leaves your Workspace.
The add-on uses only the minimum OAuth scopes required. Here is exactly what is accessed and why:
| Scope | Purpose |
|---|---|
| drive.file | Access only files created or opened by the add-on — templates you select and output PDFs. |
| documents.currentonly | Replace placeholder text in the currently open document copy only. |
| script.container.ui | Display the add-on sidebar UI inside Google Sheets. |
| script.external_request | Call Google Drive and Docs REST APIs to copy files and export PDFs. |
| script.locale | Read the user's locale for correct date formatting in documents. |