Bulk Email & PDF Mail Merge reads the rows of your Google Sheets™ spreadsheet, fills a Google Docs™ template with each row's values, converts it to PDF, and emails that PDF to the address in the row — invoices, certificates, statements, offer letters, hundreds at a time.
HOW IT WORKS
1. Put one recipient per row, with a header row.
2. Write a Google Docs™ document with {{Column Name}} placeholders and pick it with the file picker.
3. Preview: the add-on counts what would be sent and checks every placeholder — without sending anything.
4. Send. Each row is marked SENT as it goes out. Re-running skips sent rows and retries only failures, so nobody is emailed twice.
WHAT MAKES IT DIFFERENT
• No Gmail™ API scope. It sends through Apps Script's own mail service (send-only). It cannot read, search or modify your mailbox.
• No full Google Drive™ access. It uses drive.file: only the template and folder you pick, and the files it creates.
• No server, no analytics, no tracking. Everything runs inside your own Google account.
• Honest about limits. Google allows 100 recipients/day on consumer accounts and 1,500 on Google Workspace™ accounts; no add-on can raise that. Long runs pause cleanly and continue where they stopped.
PLANS
Free: every feature, unlimited preview, 20 recipients per day, a one-line signature at the end of each email.
Annual ($29/year) and Lifetime ($59 once) remove the daily allowance and the signature line. Taxes may apply depending on your country. Details: https://bulkmerge.sumitsubo.com/#pricing
SUPPORT & GUIDES
https://bulkmerge.sumitsubo.com/support — with two free, complete how-to guides if you would rather script it yourself.
Google Sheets™, Google Docs™, Google Drive™, Gmail™ and Google Workspace™ are trademarks of Google LLC. This add-on is not affiliated with or endorsed by Google.