Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Documents, PDF & OCR

Documents, PDF & OCR

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

On each new Google Sheets row, fills a blank PDF from Google Drive with JustFill, verifies the fields, uploads the result and writes the Drive link back to the row.

What it does

## Fill PDF forms from new Google Sheets rows with Google Drive and JustFill ### Try it out / How it works Whenever a new row is added to your Google Sheet, this workflow automatically downloads your blank PDF form from Google Drive, populates its fields with the row values using JustFill (supporting native AcroForm PDFs as well as flat or scanned PDFs), verifies that fields were populated, uploads the completed PDF to Google Drive, and writes the resulting Drive file link back to the Google Sheet row. ### Prerequisites - Google Sheets & Google Drive credentials configured in n8n. - JustFill account & API Key (jf_live_...) from justfill.app/account. - n8n-nodes-justfill community node installed via *Settings → Community Nodes → Install* (or call the JustFill HTTP API directly). - A blank PDF form uploaded to Google Drive (and optionally saved once as a calibrated layout at justfill.app). ### Step-by-step Setup Instructions 1. Configure the Trigger (Step 1): Select your Google Sheets credential, replace YOUR_GOOGLE_SHEET_ID with your spreadsheet ID, and choose the worksheet tab (gid=0). 2. Select the Blank PDF (Step 2): In *Google Drive (Download Blank PDF)*, replace YOUR_BLANK_PDF_DRIVE_FILE_ID with the file ID of your blank PDF template. 3. Map PDF Fields (Step 3): Connect your JustFill API credential. Run the JustFill node once with Operation = List Fields to inspect your PDF's exact field names, then map each PDF field name to the matching Google Sheets column in Values. 4. Set Output Folder & Sheet Update (Steps 4–5): Replace YOUR_OUTPUT_DRIVE_FOLDER_ID in *Google Drive (Save Filled PDF)* and YOUR_GOOGLE_SHEET_ID in *Google Sheets (Update Row with PDF Link)*. ### Customization & Use Cases - Keep fields editable: Set Flatten = false in the JustFill node options if recipients still need to edit or sign fields after generation. - Use cases: Client intake packets, W-9 / tax forms, HR onboarding documents, lease agreements, and compliance certificates.

The steps

  1. Google Sheets Trigger (New Row)
  2. Google Drive (Download Blank PDF)
  3. JustFill (Fill PDF Form)
  4. Verify Fields Populated
  5. Google Drive (Save Filled PDF)
  6. Google Sheets (Update Row with PDF Link)

Similar automations