{"product_id":"n8n-workflow-google-sheets-overdue-invoice-chaser-via-gmail","title":"n8n Workflow: Google Sheets Overdue Invoice Chaser via Gmail","description":"\u003ch3\u003eNever miss an overdue invoice again—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e invoice ledger every weekday morning, detects invoices that are truly overdue, and sends staged reminder emails via \u003cstrong\u003eGmail\u003c\/strong\u003e—while logging actions and capturing problematic rows for review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules:\u003c\/strong\u003e Runs at \u003cstrong\u003e9:00 AM\u003c\/strong\u003e, Monday through Friday.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice data:\u003c\/strong\u003e Pulls all rows from the \u003cstrong\u003eInvoices\u003c\/strong\u003e tab in your Google Sheets spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and validates:\u003c\/strong\u003e Excludes settled or already-chased invoices, de-duplicates \u003cstrong\u003einvoice_number\u003c\/strong\u003e, and validates due dates, amounts, and email fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates urgency:\u003c\/strong\u003e Computes \u003cstrong\u003edays overdue\u003c\/strong\u003e and assigns each invoice to a bucket: \u003cem\u003egentle\u003c\/em\u003e (1–7 days), \u003cem\u003efirm\u003c\/em\u003e (8–30 days), \u003cem\u003eescalate\u003c\/em\u003e, or \u003cem\u003eneeds review\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends reminders via Gmail:\u003c\/strong\u003e\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003e1–7 days overdue:\u003c\/strong\u003e Sends a gentle reminder email.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003e8–30 days overdue:\u003c\/strong\u003e Sends a firmer reminder email.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eMore than 30 days overdue:\u003c\/strong\u003e Emails you (internal escalation) instead of the customer.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs and exceptions:\u003c\/strong\u003e Appends each chase to \u003cstrong\u003eChase Log\u003c\/strong\u003e and writes unreadable\/problematic invoice rows to the \u003cstrong\u003eExceptions\u003c\/strong\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS and service businesses that track invoices in Google Sheets and need consistent overdue follow-ups.\u003c\/li\u003e\n  \u003cli\u003eTeams who want automated reminders with safeguards for settled, duplicate, or malformed invoice records.\u003c\/li\u003e\n  \u003cli\u003eOperators who prefer internal escalation after 30 days overdue to avoid customer-facing delays.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes:\u003c\/strong\u003e \u003cstrong\u003eschedule trigger\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired headers in Invoices:\u003c\/strong\u003e \u003ccode\u003einvoice_number\u003c\/code\u003e, \u003ccode\u003ecustomer_name\u003c\/code\u003e, \u003ccode\u003ecustomer_email\u003c\/code\u003e, \u003ccode\u003eamount_due\u003c\/code\u003e, \u003ccode\u003ecurrency\u003c\/code\u003e, \u003ccode\u003edue_date\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, \u003ccode\u003elast_chased_at\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Connect Google Sheets credentials and Gmail credentials, then paste your spreadsheet URL into all Google Sheets nodes.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916233334963,"sku":"N8N-18811","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fRWIAmOoCUDJmpgbHDubT_CWbGH1aY.png?v=1788013218","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-overdue-invoice-chaser-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}