{"product_id":"n8n-workflow-fill-pdf-forms-in-bulk-from-google-sheets","title":"n8n Workflow: Fill PDF Forms in Bulk from Google Sheets","description":"\u003ch3\u003eAutomatically fill PDF forms in bulk from Google Sheets—then upload results to Google Drive\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your Google Sheets hourly, fills a blank PDF form for each new row using \u003cstrong\u003ePDFops\u003c\/strong\u003e, uploads the completed PDFs to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and writes the Drive link (or an error) back to the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e on a schedule to process new data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads rows\u003c\/strong\u003e from a configured Google Sheets worksheet and keeps only rows where the \u003ccode\u003estatus\u003c\/code\u003e cell is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads a blank PDF template\u003c\/strong\u003e from the provided URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFills the PDF using PDFops\u003c\/strong\u003e by mapping your \u003cstrong\u003eGoogle Sheets column headers\u003c\/strong\u003e (excluding \u003ccode\u003erow_number\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, and \u003ccode\u003epdf_link\u003c\/code\u003e) to PDF field names.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates output filenames\u003c\/strong\u003e using the configured \u003ccode\u003efileNameColumn\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads generated PDFs\u003c\/strong\u003e to a target folder in Google Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the source row\u003c\/strong\u003e: writes \u003ccode\u003edone\u003c\/code\u003e and the Google Drive \u003ccode\u003epdf_link\u003c\/code\u003e, or records an \u003ccode\u003estatus\u003c\/code\u003e error message if filling or upload fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBatch-generating completed application forms from spreadsheet submissions.\u003c\/li\u003e\n  \u003cli\u003eProducing personalized PDFs for SaaS onboarding or document collection workflows.\u003c\/li\u003e\n  \u003cli\u003eCreating back-office document outputs (e.g., contracts\/forms) with traceable Drive links per record.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule\u003c\/strong\u003e: hourly execution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: filters rows where \u003ccode\u003estatus\u003c\/code\u003e is empty; updates by \u003ccode\u003erow_number\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDFops\u003c\/strong\u003e: implemented via the \u003ccode\u003en8n-nodes-pdfops\u003c\/code\u003e community node (\u003ccode\u003en8n-nodes-pdfops\u003c\/code\u003e \/ PDFops API credential) to fill\/optionally flatten PDFs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e: downloads the blank PDF template from a reachable URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e: uploads filled files to the configured folder and stores the resulting link in \u003ccode\u003epdf_link\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cp\u003eEnsure your sheet includes \u003ccode\u003erow_number\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, and \u003ccode\u003epdf_link\u003c\/code\u003e columns, and that PDF form field names match your Google Sheets headers. Provide \u003ccode\u003efileNameColumn\u003c\/code\u003e to control output filenames.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081435631795,"sku":"N8N-19863","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/McmjOW8qZy1jtUgpZ12aa_tkyk0wyp.png?v=1790241292","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-fill-pdf-forms-in-bulk-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}