A Google Workspace™ add-on for Google Sheets™.
One row in, one PDF out, sent to the address in that row. Bulk Email & PDF Mail Merge reads the rows of a Google Sheet, fills a document template with each row's values, converts it to PDF, and emails it to that row's recipient — hundreds at a time.
It runs entirely inside your own Google account as a Google Apps Script add-on. There is no server behind the add-on, and it never asks for a Gmail API scope.
Available on Google Workspace Marketplace. Install Bulk Email & PDF Mail Merge from its Marketplace listing, then follow Getting started for the first run.
If you would rather not install anything, the guides below solve the same problems by hand, with working code you can copy. They are free and require nothing from us.
These are complete, working walkthroughs — not teasers. Each one ends with a script you can paste into your own sheet and run today.
{{Placeholder}} tokens with that row's values.Tools built on the Gmail API need a Gmail scope. Google classifies gmail.send as
sensitive, and broader ones such as gmail.modify and gmail.readonly as
restricted: they can read your mailbox, and an app that reaches that data through
its own servers must pass an independent security assessment at least every 12 months.
This add-on sends through Apps Script's own mail service
(script.send_mail) instead. That scope can send mail as you — and it cannot read
your mailbox at all. Nothing in this add-on is capable of opening an email you have
received.
| Permission | Google's classification | Why it is needed |
|---|---|---|
drive.file |
Non-sensitive | You pick your template and output folder through Google's own file picker, not a typed-in ID. That picker selection is what grants access — limited to the files you pick or that the add-on creates — it cannot see the rest of your Drive. |
spreadsheets.currentonly |
Non-sensitive | Read the rows of this spreadsheet only, and write each row's send status into a column of it, so a re-run never sends twice. It cannot open any other spreadsheet. |
script.send_mail |
Sensitive | Send the merged documents to each row's recipient. Send only — no read access to your mailbox. |
script.container.ui |
Sensitive | Show the add-on's side panel inside Google Sheets. |
script.storage |
Non-sensitive | Remember your settings and a job's progress between runs, inside your own account. |
script.external_request |
Sensitive | Ask Google's own Drive API to convert each merged document to PDF. The add-on's manifest allow-list (enforced by Google) permits that one Google endpoint and nothing else — it cannot contact our servers or anyone else's. |
Classifications above are the ones Google Cloud Console shows for this project, read on 2026-09-22. No restricted scope is requested.
Buy Annual — $29/year Buy Lifetime — $59 Your license key appears on the page you return to after paying.
Every plan has every feature. Paid plans differ from Free only in the daily allowance and the signature line. Payment is handled by Link, Stripe's checkout; you receive a license key that the add-on checks inside your own account, without contacting any server.
Availability. The add-on is not offered in the European Economic Area (the EU member states, Iceland, Liechtenstein and Norway). Please do not buy a plan from there: the Marketplace listing cannot be opened in those countries. If you do by mistake, we will refund it in full.
Your own Google account applies its own sending limit regardless of plan: Google documents 100 recipients per day for consumer accounts and 1,500 per day for Google Workspace accounts. No add-on can raise that.