{"product_id":"n8n-workflow-ocr-invoice-extraction-gmail-payment-reminders","title":"n8n Workflow: OCR Invoice Extraction + Gmail Payment Reminders","description":"\u003ch3\u003eOCR Invoice Extraction + Gmail Payment Reminders—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for new invoice\/receipt images, extracts key fields using \u003cstrong\u003eMistral AI OCR\u003c\/strong\u003e, stores them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003escheduled Gmail payment reminders\u003c\/strong\u003e when document dates are 7, 3, 1, or 0 days away.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors your Google Drive folder:\u003c\/strong\u003e Triggers when a new file is created in a specified Drive location.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns OCR with Mistral AI:\u003c\/strong\u003e Downloads the new file and sends it to \u003cstrong\u003eMistral AI\u003c\/strong\u003e to extract OCR text from the image.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured invoice data:\u003c\/strong\u003e Uses a \u003cstrong\u003eGroq-hosted LLM chain\u003c\/strong\u003e to parse the OCR text into JSON fields including:\n    \u003cul\u003e\n      \u003cli\u003eDocument date\u003c\/li\u003e\n      \u003cli\u003eTotal amount\u003c\/li\u003e\n      \u003cli\u003eCompany name\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets (upsert by Drive file ID):\u003c\/strong\u003e Formats the extracted values, adds the Drive file ID and link, then upserts the record into Google Sheets keyed by the Drive file ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends reminders on a daily schedule:\u003c\/strong\u003e Each day, it reads rows from the same Google Sheets document, filters entries where the document date is exactly \u003cstrong\u003e7, 3, 1, or 0 days\u003c\/strong\u003e from today, and emails a payment reminder via \u003cstrong\u003eGmail\u003c\/strong\u003e for each matching row.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts teams who receive invoices as images and need automatic due-date follow-ups.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking payments without manually transcribing invoice totals and dates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable document-to-sheet pipelines with scheduled email reminders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e trigger for new files\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMistral AI\u003c\/strong\u003e OCR for image text extraction\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq Chat LLM\u003c\/strong\u003e to transform OCR text into JSON\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to upsert by Drive file ID (columns include ID, Document_date, Total_Note, Company_Name, Note_Link)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter\u003c\/strong\u003e to select rows with dates 7\/3\/1\/0 days away\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to send reminders (configured via a [ReceiverEmail] placeholder)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837464731827,"sku":"N8N-18254","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RqLKupYaJ5oC0Gw9GpMVQ_iwmpT6M6.png?v=1786794702","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-ocr-invoice-extraction-gmail-payment-reminders","provider":"N8N Commerce","version":"1.0","type":"link"}