PDF Mail Merge from Google Sheets

What Is PDF Mail Merge from Google Sheets?

PDF mail merge from Google Sheets lets you connect a live Google spreadsheet directly to your PDF template — no file downloads, no manual uploads. Every merge reads the current values in your sheet at that moment, so your documents always reflect the latest data.

This is the fastest workflow when your data lives in Google Sheets and changes frequently. Team members can update the source spreadsheet collaboratively, and the next merge automatically picks up their edits.

Prerequisites

• A PDF template — an invoice, certificate, contract, label, or any PDF you want to fill
• A Google Sheet with column headers in the first row and data starting from row two
• A Google account with access to the spreadsheet
• A free Mergram account — sign up at mergram.com/new

How to Connect Google Sheets to PDF Mail Merge

Step 1 — Upload Your PDF Template

Open the Mergram editor and upload a PDF file from your computer, or import a design from Canva. Your template is the static layout — logos, borders, headings — that stays the same across all generated documents.

Step 2 — Connect Your Google Sheet

In the Data Source tab, select the Google Sheets option. You’ll go through a one-time OAuth flow:

1. Click Connect Google Sheets
2. Sign in to your Google account and grant read-only access
3. Select the spreadsheet from your Google Drive
4. Choose the worksheet tab (for multi-tab spreadsheets)

Mergram reads the first row as column headers and each subsequent row as one record. The connection is saved to your team — you only authenticate once.

Step 3 — Place Data Fields

Drag column headers from the sidebar onto your PDF pages. Each column becomes a positioned field:

• Text — Names, addresses, amounts, dates
• QR Codes — Payment links, verification URLs, event check-in codes
• Barcodes — Code 128, EAN-13, UPC-A, Code 39, ITF-14, Pharmacode
• Images — Photos, logos, signatures from your Media Albums

Step 4 — Preview & Generate

Preview any row directly in your browser — no server round-trip needed for single-row preview. When you’re ready, choose your output:

• Individual PDFs — One file per row, packaged as ZIP
• Combined PDF — All pages in a single document
• Email delivery — Send each PDF as a personalized attachment

Background workers process up to 100,000 rows with progress tracking.

Why Use Google Sheets Instead of File Upload?

Live Data & Auto-Refresh

Always-Current Data

When you connect a Google Sheet, Mergram reads the sheet contents at merge time — not at connection time. This means:

• A teammate adds a new row of data → it’s included in the next merge
• Someone fixes a typo in a cell → the corrected value appears in the next batch
• You add a new column → it appears as a new field in the sidebar

There’s no “sync” button or manual refresh step. The data is always live.

Collaborative Editing

Google Sheets supports real-time collaboration. Multiple team members can edit the source spreadsheet simultaneously, and those changes are reflected in subsequent merges. This is particularly useful for:

• Event planning — Team adds attendee names, dietary preferences, and ticket types in real time
• Sales teams — Reps update client data in a shared sheet, and invoices are generated from the latest information
• HR departments — Hiring managers add new employee records, and onboarding documents are generated without waiting for a consolidated file

Re-Merging Without Re-Uploading

The most common workflow with file uploads is: export → upload → merge → realize a value was wrong → fix in spreadsheet → re-export → re-upload → re-merge.

With Google Sheets, that cycle becomes: fix the cell → re-merge. No export, no upload, no file management.

Google Sheets Workflow Tips

Spreadsheet Setup

Follow these guidelines for best results:

1. First row = headers — Use clear, descriptive column names (e.g., Client Name, Invoice Number)
2. Data starts from row 2 — Each row is one record to merge
3. One sheet per purpose — Use separate tabs for different merge types (invoices, certificates, etc.)
4. Avoid merged cells — They can cause column misalignment during parsing
5. Use data validation — Dropdown lists and date pickers ensure consistent data entry across collaborators

Sharing & Permissions

For team workflows, share the Google Sheet with collaborators using Google’s built-in sharing. Mergram only needs the account that connected the sheet to have access — collaborators don’t need Mergram accounts to edit the source data.

When to Use Google Sheets vs. Excel Upload

Use Google Sheets when:

• Multiple people need to update the data
• Values change frequently and you merge on a regular schedule
• You want to eliminate the download-upload cycle
• Your data is already in Google Sheets

Use Excel upload when:

• Your data lives in a local file and doesn’t change often
• You need offline access to your data
• Your spreadsheet has complex formatting or macros
• You’re doing a one-time merge from exported data

Best Practices

1. Use a dedicated sheet tab — Keep merge data in its own tab, separate from calculations or notes
2. Lock the header row — Use Google Sheets’ “Protect range” feature to prevent accidental edits to column names
3. Share with edit access carefully — Use Google’s commenting or suggestion modes for review before changes go live
4. Preview before bulk merge — Check 2–3 rows in the browser preview to verify field placement
5. Save your template — Saved templates remember the Google Sheets connection, so you can re-merge in one click

Get Started

Connect your Google Sheet to a PDF template and generate personalized documents in minutes. No downloads, no file management — just live data flowing into your templates.

Try it free: mergram.com/new

Prefer to start with a file? See PDF Mail Merge from Excel or PDF Mail Merge from CSV.