How to Generate PDFs from Google Forms

Turning Google Forms Submissions into PDFs

Google Forms makes it easy to collect information — event registrations, applications, feedback, orders. But the responses sit in a spreadsheet. What if each submission could automatically produce a polished PDF — a certificate, receipt, ticket, or confirmation letter — and even email it to the submitter?

This guide shows you three ways to connect Google Forms to Mergram for PDF generation, from fully manual to fully automated.

How It Works

The workflow follows a simple pipeline:

Google Forms → Google Sheets → Mergram → PDF

Google Forms automatically saves every submission to a linked Google Sheet. Mergram reads that spreadsheet data and merges it into your PDF template. Automation platforms like Zapier connect the pieces to run the pipeline automatically.

Method 1: Manual — Google Sheets Integration

This method requires no automation tools. You collect responses, then generate PDFs on demand.

Step 1: Create Your Google Form

1. Go to forms.google.com and create a form
2. Add fields that correspond to your PDF template (name, email, date, etc.)
3. Click the Responses tab, then click Link to Sheets
4. Google creates a spreadsheet with columns matching your form fields

Step 2: Design Your PDF Template

1. Upload a PDF template to the Mergram editor
2. Place text fields where form data should appear
3. Add any static elements (logo, header text, decorative borders)

Step 3: Connect Google Sheets

1. In the editor, click Load Data and select Google Sheets
2. Authorize Mergram to access your Google account
3. Select the spreadsheet linked to your form
4. Choose the correct sheet tab (usually “Form Responses 1”)

Step 4: Map Fields and Merge

1. Drag spreadsheet columns onto the canvas to create mapped fields
2. Preview with real submission data to verify accuracy
3. Click Merge to generate PDFs for all rows

Method 2: Automated via Zapier

For hands-off operation, connect Google Forms to Mergram using Zapier.

Step 1: Create the Template in Mergram

1. Design and save your PDF template in Mergram
2. Note the template ID (visible in the URL or via the API)
3. Generate an API key in Developer → API Keys

Step 2: Set Up the Zapier Zap

1. Trigger: Choose Google Forms → New Response in Spreadsheet
2. Select your form and the linked spreadsheet

Step 3: Add the Mergram Action

1. Action: Choose Webhooks by Zapier → Custom Request
2. Configure:
   • Method: POST
   • URL: https://mergram.com/api/v1/merge
   • Headers: Authorization: Bearer mg_your_api_key
   • Payload Type: JSON
3. Build the data payload using form field values from the trigger:

{
  "templateId": "your-template-id",
  "data": [
    {
      "FirstName": "{{trigger.first_name}}",
      "Email": "{{trigger.email}}",
      "EventDate": "{{trigger.event_date}}"
    }
  ]
}

Step 4: Test and Activate

1. Submit a test response through your Google Form
2. Verify the Zap triggers and Mergram generates the PDF
3. Turn on the Zap for live operation

Method 3: API Automation (For Developers)

For maximum control, build a custom integration using the Mergram REST API.

Architecture

Google Form → Google Sheets → Your Script → Mergram API → PDF

Implementation Steps

1. Watch for new rows — Use the Google Sheets API to detect new form submissions (polling or push notifications)
2. Send to Mergram — POST new row data to /api/v1/merge with your template ID
3. Handle the response — Poll /api/v1/jobs/:id for completion status
4. Distribute — Download the PDF or trigger an email send

Common Use Cases

Tips for Google Forms Workflows

1. Validate form fields — Use Google Forms built-in validation (required fields, email format, number ranges) to ensure clean data before it reaches Mergram
2. Include a timestamp column — Google Sheets automatically adds a timestamp. Map it to your PDF for a submission date
3. Handle file upload fields carefully — Google Forms file uploads go to Google Drive, not the spreadsheet. You cannot directly merge uploaded files into your PDF template
4. Test with real submissions — Before automating, manually process a few real form responses to verify field mapping and output quality
5. Set up error notifications — In Zapier, configure a notification step for failed merges so you know when something goes wrong

Common Issues and Troubleshooting

Column headers don’t match: Google Forms may modify your question text (adding spaces, truncating long names). Check the actual column headers in the linked spreadsheet and adjust your Mergram field names accordingly.

New submissions not appearing: Click the refresh button in Mergram’s data panel to pull the latest rows from Google Sheets. For automated workflows, the API receives data directly — no refresh needed.

Zapier payload format errors: Ensure the JSON payload uses the correct column header names from your Mergram template, not the Google Form question text. They may differ.

PDF looks different from preview: Upload a custom font to Mergram that matches your template’s typography. The default Inter font may not match your template’s original styling.

Get Started

Create a Google Form linked to a spreadsheet, design your PDF template in the Mergram editor, and connect the two. Start with manual merging, then add Zapier automation when you’re ready for hands-off operation.