How to Batch Fill PDF Forms from Google Sheets (Free Add-on - PDF Mail Merge)
In this tutorial, I'll show you how to use the PDF Mail Merge add-on for
Google Sheets to automatically batch fill PDF forms, certificates, invoices,
and contracts — all without any coding.
✅ What you'll learn:
How to install the PDF Mail Merge add-on
How to prepare your Google Sheet data
How to upload a PDF template and map fields visually
How to generate hundreds of filled PDFs in one click
🔒 Privacy First: All data processing happens 100% in your browser. Your
spreadsheet data is never stored on any server.
🔗 Get the Add-on (Free):
👉 https://workspace.google.com/marketpl... (search: PDF Mail Merge)
🌐 Website & Tools:
👉 https://sheetstolabels.com/fill-pdf-f...
📌 Chapters:
0:00 - Intro
0:30 - Install the Add-on
1:00 - Prepare your Google Sheet data
1:45 - Open the sidebar & detect columns
2:15 - Upload your PDF template
3:00 - Visual field mapping
4:00 - Generate & download PDFs
4:45 - Wrap up
💡 Perfect for:
Bulk certificates & awards
Personalized invoices & receipts
Business contracts
Shipping labels & custom forms
---
If this helped you, please like 👍 and subscribe for more Google Workspace
productivity tips!
#PDFMailMerge #GoogleSheets #PDFAutomation #GoogleWorkspace #MailMerge