{"product_id":"n8n-workflow-extract-pdf-form-fields-to-google-sheets","title":"n8n Workflow: Extract PDF Form Fields to Google Sheets","description":"\u003ch3\u003eTurn PDF form fields into a Google Sheets row automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for new PDF forms, runs \u003cstrong\u003eMistral OCR\u003c\/strong\u003e + \u003cstrong\u003eMistral Chat\u003c\/strong\u003e to extract structured form fields, and \u003cstrong\u003eappends each result to Google Sheets\u003c\/strong\u003e—so your form data lands ready for reporting and operations.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\u003c\/strong\u003e when a new file is created in a specified Google Drive folder (or you can run it manually to list and process PDFs already in the folder).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to PDFs only\u003c\/strong\u003e, then downloads each PDF from Google Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads the PDF to Mistral Files\u003c\/strong\u003e, requests a signed document URL, and sends that URL to \u003cstrong\u003eMistral OCR\u003c\/strong\u003e to extract the form text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCombines OCR output pages\u003c\/strong\u003e into a single text block and builds a fixed JSON schema containing the required fields plus Google Drive file metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Mistral Chat Completions\u003c\/strong\u003e with strict JSON output rules to extract the requested form fields from the OCR text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the returned JSON\u003c\/strong\u003e, maps values into the target \u003cem\u003eTurkish-labeled\u003c\/em\u003e Google Sheets columns, and \u003cstrong\u003eappends a new row\u003c\/strong\u003e including the source file name.\u003c\/li\u003e\n  \u003cli\u003eWhen processing in bulk, it \u003cstrong\u003ewaits briefly between items\u003c\/strong\u003e to pace requests and continues until all PDFs are processed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically capture data from \u003cstrong\u003ePDF application \/ registration forms\u003c\/strong\u003e stored in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eConvert \u003cstrong\u003escanned or image-based PDFs\u003c\/strong\u003e into structured records for CRM-like tracking in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBatch-process historical PDF forms by running the workflow manually and writing all results to a sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Code, Wait, Filter, Sticky Note, Google Drive, HTTP Request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Drive OAuth2, Google Sheets OAuth2, \u003cstrong\u003eMistral Cloud API key\u003c\/strong\u003e (Mistral Files, Mistral OCR, Mistral Chat Completions)\u003c\/li\u003e\n  \u003cli\u003eConfigured with a \u003cstrong\u003eGoogle Drive folder ID\u003c\/strong\u003e, plus Google Sheets \u003cstrong\u003edocument ID\u003c\/strong\u003e and target sheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal for n8n users, automation engineers, and SaaS operators who need reliable \u003cstrong\u003ePDF-to-structured-data\u003c\/strong\u003e extraction and \u003cstrong\u003eGoogle Sheets automation\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748946796723,"sku":"N8N-17681","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qBUsy7anF3VNrpvzs1inx_r2Prxp1B.png?v=1785575635","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-extract-pdf-form-fields-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}