See llms.txt for all machine-readable content.

Back to Templates

Fill PDF forms from new Google Sheets rows with Google Drive and JustFill

Created by

Created by: JustFill || justfillapp
JustFill

Last update

Last update 2 days ago

Categories

Quick overview

This workflow watches a Google Sheets spreadsheet for new rows, downloads a blank PDF from Google Drive, uses JustFill to populate the PDF form fields with the row values, and then uploads the flattened filled PDF back to a target Google Drive folder.

How it works

  1. Triggers whenever a new row is added to the specified Google Sheets worksheet.
  2. Downloads the blank PDF template file from Google Drive.
  3. Sends the PDF and mapped Google Sheets column values to JustFill to fill matching PDF form fields and flatten the result.
  4. Uploads the filled PDF to a chosen Google Drive folder using the generated filename.

Setup

  1. Install the community node n8n-nodes-justfill and add a JustFill API credential.
  2. Add Google credentials for Google Sheets and Google Drive access.
  3. Update the Google Sheet document ID and sheet (gid) in the trigger.
  4. Set the Google Drive file ID for the blank PDF template and the folder ID where filled PDFs should be saved.
  5. Ensure the keys in the JustFill field mapping match your PDF form field names (use JustFill’s “List Fields” once to discover them) and that your Google Sheets columns use the expected headers (for example, Full Name, Company, Email, Phone, Date).