{"product_id":"gmail-invoice-ocr-to-google-sheets-slack-reminders-n8n","title":"Gmail Invoice OCR to Google Sheets + Slack Reminders (n8n)","description":"\u003ch3\u003eTurn invoice emails into a tracked spreadsheet—and send due-date reminders automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n\u003c\/strong\u003e workflow monitors your \u003cstrong\u003eGmail\u003c\/strong\u003e inbox for invoice PDFs, extracts invoice details with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, records them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with duplicate detection, and then sends \u003cstrong\u003edaily payment reminders\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e plus real-time alerts to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks for new invoices hourly:\u003c\/strong\u003e Triggers every hour when a Gmail message arrives in Inbox with an attachment and a subject containing \u003cem\u003e“invoice”\u003c\/em\u003e or \u003cem\u003e“bill.”\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice data from the PDF:\u003c\/strong\u003e Downloads the attachment, extracts text from the PDF, and sends it to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to return structured JSON (vendor name, invoice number, amount, due date).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects duplicates automatically:\u003c\/strong\u003e Searches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tracker for an existing row matching the extracted invoice number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts on duplicates:\u003c\/strong\u003e If found, posts a \u003cstrong\u003eduplicate invoice alert\u003c\/strong\u003e message to a configured \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks new invoices:\u003c\/strong\u003e If not found, appends a new row to Google Sheets with a default \u003cstrong\u003ePending\u003c\/strong\u003e status and a \u003cstrong\u003ecreated timestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends reminders daily at 9:00:\u003c\/strong\u003e Loads invoice records from Google Sheets, calculates days remaining until the due date, assigns reminder type and priority, and for invoices requiring action sends:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003ePayment reminder emails via Gmail\u003c\/strong\u003e (to a configured recipient)\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eReminder messages via Slack\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates statuses:\u003c\/strong\u003e Modifies invoice status in Google Sheets (for example, marking overdue invoices as \u003cstrong\u003eOVERDUE\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAP teams who receive vendor invoices by email and want a live invoice tracker with due-date follow-ups.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want fewer missed payments by combining \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e logging with \u003cstrong\u003eGmail + Slack\u003c\/strong\u003e reminders.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying an invoice ingestion pipeline in \u003cstrong\u003en8n\u003c\/strong\u003e using OpenAI-powered extraction.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger:\u003c\/strong\u003e Gmail (Inbox monitoring for subjects containing “invoice”\/“bill” with attachments)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtraction:\u003c\/strong\u003e PDF text extraction + \u003cstrong\u003eOpenAI\u003c\/strong\u003e returning structured JSON\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplication \u0026amp; logging:\u003c\/strong\u003e Google Sheets lookup and append, with default “Pending” status\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifications:\u003c\/strong\u003e Slack duplicate alerts and reminder posts\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail reminders:\u003c\/strong\u003e Gmail send step at 9:00 daily\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore workflow logic:\u003c\/strong\u003e nodes such as \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, and \u003cem\u003ecode\u003c\/em\u003e (plus Sticky Note for guidance)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eRequires connecting your Gmail credentials for both reading and sending, and adding an OpenAI API credential for the invoice field extraction.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978929692851,"sku":"N8N-19319","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TUaPYyd5yzRzF0NmEx3v__iyJTfMVu.png?v=1788859695","url":"https:\/\/buyflowscripts.com\/products\/gmail-invoice-ocr-to-google-sheets-slack-reminders-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}