Olmec Dynamics
D
·6 min read

Document generation & templating: How to generate PDFs from Google Docs templates with Make.com and PandaDoc

Automate PDF generation from Google Docs templates using Make.com and PandaDoc. Create, store, and email client documents in minutes for your team today.

Introduction

If you still draft client proposals by hand or copy data from a form into a document, you know how much time is wasted and how easy mistakes slip in. This document generation workflow uses Google Docs templates to produce branded documents automatically, then PandaDoc renders a polished PDF and Make.com coordinates the data flow. The result is a reliable, repeatable process that saves hours per week and reduces errors in client proposals.

By the end, you’ll be able to trigger PDF generation from data in Google Sheets, fill a Google Docs template, generate a PDF with PandaDoc, and email the final document to a client. You’ll also learn practical field mappings and how to test for edge cases.

If you want to see a similar data-to-doc flow in action, check our Typeform to HubSpot lead sync guide. You can read it here: Typeform to HubSpot lead sync. For an e commerce oriented example, see our Shopify orders to Google Sheets and Slack guide: Shopify orders to Google Sheets and Slack.

What You'll Need

  • A Google Docs template prepared with placeholders like {{ClientName}}, {{ProposalTitle}}, {{DueDate}}, {{Amount}} etc.
  • A PandaDoc account with a ready-to-use template for the PDF output
  • A Make.com account with Google Docs, PandaDoc, and Google Sheets connections
  • A source of data to populate the template, typically a Google Sheet with columns such as client_name, client_email, proposal_title, due_date, amount, currency
  • A Gmail account or similar email service connected in Make.com to deliver the final PDF

Note: You will likely need a paid Make.com plan if you want to run multiple scenarios or high volumes. PandaDoc usage may also require a paid tier for API access and document generation.

How It Works (The Logic)

Trigger → Data flows from Google Sheets into Google Docs template → Generated Google Doc feeds PandaDoc template to render a PDF → PDF is emailed to the client (and optionally saved)

This keeps document production fast and brand consistent. You map fields from your sheet to the template placeholders in Google Docs and PandaDoc, then Make.com handles the orchestration.

Step-by-Step Setup

  1. Prepare your Google Docs template
  • Create a document with placeholders like {{ClientName}}, {{ProposalTitle}}, {{DueDate}}, {{Amount}}, {{Currency}}, {{CompanyLogoUrl}}.
  • Save it in a known Drive folder and note the document ID for Make.com.
  1. Prepare your PandaDoc template
  • Create a PandaDoc document template for the final PDF. Include fields that will be populated from your data, for example client_name, proposal_title, due_date, amount, and currency.
  • Save the template and note the template ID.
  1. Build the Google Sheets data source
  • Create a sheet named Proposals with columns: client_name, client_email, proposal_title, due_date, amount, currency, notes, and template_id (optional).
  • Ensure data quality by validating emails and dates prior to triggering the workflow.
  1. Create a new scenario in Make.com
  • Start with a Google Sheets module: Watch Rows (or List Rows with a filter) from your Proposals sheet.
  • Set a reasonable trigger condition such as new or updated row with a status value of “Ready to generate.”
  1. Fill the Google Docs template
  • Add Google Docs: Create a Document from Template module.
  • Choose the template document you prepared and map fields from Google Sheets to placeholders in the Google Docs template:
    • ClientName → {{ClientName}}
    • ProposalTitle → {{ProposalTitle}}
    • DueDate → {{DueDate}}
    • Amount → {{Amount}}
    • Currency → {{Currency}}
    • CompanyLogoUrl → {{CompanyLogoUrl}}
  • Output the new document ID for the next step.
  1. Generate the PDF via PandaDoc
  • Add PandaDoc: Create Document from Template.
  • Use your PandaDoc template and map fields from Google Sheets to PandaDoc placeholders, matching to client_name, proposal_title, due_date, amount, currency.
  • After creation, use PandaDoc: Download Document (PDF) or Retrieve the PDF URL to attach to email.
  1. Email the final PDF
  • Add Gmail (or your mail connector): Send Email.
  • To: {{ClientEmail}}
  • Subject: "Your proposal: {{ProposalTitle}}" or similar
  • Body: Include a short note and link to the PandaDoc document if you want the client to view or sign.
  • Attach the PDF from PandaDoc (or include it as an inline attachment depending on your email provider).
  1. Optional: Save a copy and log an audit trail
  • Add Google Drive: Save a copy of the final PDF in a Drive folder for archival.
  • Add Google Sheets: Append a row to a log sheet with the proposal_id, client_name, date_sent, and the PDF link for future reference.
  1. Testing the end-to-end flow
  • Create a test row in your Proposals sheet with sample data and trigger the scenario.
  • Confirm: a Google Doc is created from the template, a PandaDoc PDF is generated, and the email arrives with the correct attachment.
  • Check the audit log to verify the row was written and the correct IDs were captured.
  1. Turn it on and monitor
  • Activate the scenario and monitor the first few runs in Make.com. Watch for formatting issues, missing placeholders, or incorrect mappings. If you see anything off, adjust the field mappings and test again.

Real-World Business Scenario

A mid sized design agency uses this pattern to automatically generate client proposals. When a new row is added to the Proposals sheet, the system fabricates a branded proposal in Google Docs, renders a PDF via PandaDoc, and emails it to the client. The team saves hours per proposal and reduces errors from manual drafting. This pattern scales as you add more templates or logos for different brands. If you want a similar approach applied to other document types such as contracts or NDAs, Olmec Dynamics can build it for you. Learn more at Olmec Dynamics.

Common Variations

  • Add e-signatures with PandaDoc by routing the document for signature after the initial send. This shortens the close cycle dramatically.
  • Add a conditional route so only high value proposals use PandaDoc templates for signatures while standard proposals stay document-only.
  • Store the final PDF in multiple locations such as Google Drive and a shared drive folder, and notify stakeholders via Slack with a quick status update.

What this means for your docs

Document generation and templating are no longer a bottleneck. This Make.com driven flow provides a repeatable, auditable approach to turning data into branded PDFs, sending them automatically, and keeping a tidy trail of all proposals. If you want these kinds of automations built for your business, Olmec Dynamics specializes in this work. Learn more at Olmec Dynamics.