Bulk Email & PDF Mail Merge · Last updated: 2026-10-01
Email se.sato614@gmail.com. This is a one-person project; replies usually take one to two business days.
What to include: what you were trying to do, what happened instead, and — if a row was marked with an error — the exact text of that error. Please do not send us your spreadsheet or your recipient list; we do not want a copy, and we almost never need one to diagnose a problem.
This is expected behaviour, not a failure, and it has three possible causes.
The daily quota. Google caps how many recipients one account can email per day through Apps Script: 100 for consumer accounts, 1,500 for Google Workspace accounts. The quota is a rolling 24-hour window managed by Google, so it frees up gradually rather than at midnight. No plan, payment, or tool raises it — this limit belongs to your Google account, not to us.
The free plan's daily allowance. On the free plan the add-on itself stops after 20 recipients per day. The side panel tells you when this is the reason. Run again tomorrow, or activate a plan and press Start again — it continues from the first unsent row.
The 6-minute execution limit. Google stops any single Apps Script execution at six minutes. Long runs are therefore processed in batches that stop cleanly and resume.
In both cases, rows already processed are recorded. Running again continues from where it stopped rather than starting over, and nobody is emailed twice.
A placeholder such as {{Name}} appearing literally in the finished PDF means the name
inside the braces does not exactly match a column header in your sheet. Matching is literal:
{{name}} does not match a header of
Name.Merge a single row and open the result before running a list.
Can it read my Gmail? No. The add-on requests
script.send_mail, which can only send. It requests no Gmail API scope,
so reading, searching, or modifying your mailbox is not something it is able to do.
Can it see the rest of my Drive? No. It requests drive.file, and you
choose your template and output folder through Google's own file picker rather than typing a path.
Access is limited to what you pick there, or what the add-on creates itself. It does not request the
full drive scope, so it cannot browse or list the rest of your Drive.
Does my data leave my account? No. The add-on's only network access is to Google's own Drive API, to convert each document to PDF; its manifest allow-list — enforced by Google — permits that one endpoint and nothing else, so there is no mechanism by which your data could reach us or any third party. Full detail is in the Privacy Policy.
The add-on writes SENDING to a row just before it emails it and SENT right after. If a run is interrupted in between (a Google service hiccup at exactly that moment), the row keeps SENDING. Such rows are never sent again automatically, because the email most likely went out. Check your Sent folder; if it did not arrive, clear that one status cell and run again.
cs_); keep the order ID. Then in Google Sheets open the add-on, scroll to
Plan, paste the key and press Activate. The key is checked inside the add-on and is
not sent anywhere.Open Google Workspace Marketplace → the Settings (gear) icon → Manage Apps → the ⋮ menu next to Bulk Email & PDF Mail Merge → Remove. This revokes every permission you granted. Documents and PDFs already created stay in your Drive, because they are yours.
If you would rather run your own script than install anything, both guides are complete and free, with code you can keep:
Email se.sato614@gmail.com with “security” in the subject. Please report privately first and give us a reasonable chance to fix the issue before disclosing it.