{"product_id":"n8n-google-drive-invoice-ocr-to-sheets-mistral","title":"n8n Google Drive Invoice OCR to Sheets (Mistral)","description":"\u003ch3\u003eAutomatically convert Google Drive invoice PDFs into structured rows in Google Sheets using Mistral OCR\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Google Drive “UPLOAD Invoices” folder for new invoice PDFs, extracts key invoice fields with \u003cstrong\u003eMistral OCR\u003c\/strong\u003e (free API keys available), and appends the results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—then moves the processed file to a “Processed Invoices” folder.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors your Drive folder\u003c\/strong\u003e: Triggers every minute when a new file is created in the specified source Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the new PDF\u003c\/strong\u003e from Google Drive for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice text\u003c\/strong\u003e from the PDF, using \u003cstrong\u003eMistral OCR\u003c\/strong\u003e to improve extraction quality.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses invoice details\u003c\/strong\u003e from the extracted content, identifying fields such as invoice number, issue date, due date, customer\/seller, amounts, and days left to pay.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to a target Google Sheets spreadsheet\/tab with the extracted fields, and marks the invoice as \u003cstrong\u003eunpaid\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents re-processing\u003c\/strong\u003e by moving the processed PDF to a \u003cstrong\u003eProcessed Invoices\u003c\/strong\u003e Google Drive folder.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators centralizing incoming invoice PDFs from a shared Drive workflow.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing reliable invoice OCR-to-ERP-style field capture into Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTeams that want quick invoice tracking (invoice number, due date, days left to pay) without manual data entry.\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\/workflow components\u003c\/strong\u003e: Code, Sticky Note, Google Drive, HTTP Request, Google Sheets, and file extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Drive (OAuth2), Google Sheets (OAuth2).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMistral OCR\u003c\/strong\u003e: Uses three HTTP calls to Mistral with your Bearer token to extract text from PDFs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements\u003c\/strong\u003e: Provide source\/destination Google Drive folder IDs, target spreadsheet + sheet tab, ensure columns match written fields, and supply a Mistral API key for the OCR requests.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eTip:\u003c\/strong\u003e For best results, upload PDF invoices with consistent formatting (or use the included Mistral OCR HTTP requests to replace built-in PDF text extraction when needed).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001884070067,"sku":"N8N-19444","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8PcED8my4_zsTjN2_-CdM_HtjTy5lS.png?v=1789118322","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-drive-invoice-ocr-to-sheets-mistral","provider":"N8N Commerce","version":"1.0","type":"link"}