Bulk Email & PDF Merge

A Google Workspace™ add-on for Google Sheets™.

One row in, one PDF out, sent to the address in that row. Bulk Email & PDF 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, and it never asks for a Gmail API scope.

Status: in development. The add-on is not yet published on Google Workspace Marketplace. This page describes what it does and what it will ask permission for, so you can decide in advance whether it is the kind of tool you want near your data.

In the meantime, the guides below solve the same problems by hand, with working code you can copy. They are free and require nothing from us.

Guides

These are complete, working walkthroughs — not teasers. Each one ends with a script you can paste into your own sheet and run today.

How to send bulk email from Google Sheets — the mail merge loop, the daily quota that stops it, and how to make a long run resumable.
How to mail merge to PDF from Google Sheets — fill a Docs template per row, export each one to PDF, and attach it to that row's email.

What it will do

Merge each spreadsheet row into a Google Docs template you choose, by replacing {{Placeholder}} tokens with that row's values.
Convert each merged document to PDF.
Send the PDF to the address in that row, with a subject and body that can themselves contain per-row placeholders.
Resume. Apps Script stops any single execution at 6 minutes. Long runs are processed in batches that pick up where they stopped, so a thousand-row job is not something you have to babysit.
Never send twice. Each row records what was sent against it, so re-running skips rows that already went out and retries only the ones that failed.
Preview first. Count exactly what would be sent, and list every row that cannot be read, without sending anything.

Why no Gmail API scope

Most add-ons that send mail ask for gmail.send or gmail.modify. Google classifies those as restricted scopes: they can reach your whole mailbox, and the developer must pass a third-party security assessment every year.

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.

What it accesses

Permission	Google's classification	Why it is needed
`drive.file`	Non-sensitive	Open the template you pick and write the merged PDFs. Limited to files you open or create with this add-on — it cannot see the rest of your Drive.
`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.

Classifications above are the ones Google Cloud Console shows for this project, read on 2026-09-22. No restricted scope is requested.

Planned pricing

FreeUnlimited preview. A daily send allowance, which resets each day.

$4.99/moStarter. Removes the daily allowance.

$9.99/moPro. Higher volume and scheduling.

$29 onceLifetime. No subscription.

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.