{"product_id":"n8n-workflow-send-overdue-invoice-reminders-via-gmail-sheets","title":"n8n Workflow: Send Overdue Invoice Reminders via Gmail + Sheets","description":"\u003ch3\u003eAutomate overdue invoice reminders with Gmail + Google Sheets in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your open invoices in Google Sheets every weekday and sends staged overdue payment reminders via Gmail—then emails a weekly receivables aging report to your finance inbox and logs each reminder stage back in the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every weekday at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice data from Google Sheets:\u003c\/strong\u003e Loads all rows from the \u003cstrong\u003eInvoices\u003c\/strong\u003e tab using \u003cstrong\u003eunformatted values\u003c\/strong\u003e for consistent date handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates overdue status:\u003c\/strong\u003e For each invoice not marked \u003cstrong\u003ePaid\u003c\/strong\u003e or \u003cstrong\u003eCancelled\u003c\/strong\u003e, it calculates \u003cstrong\u003edays overdue\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the next unsent reminder stage:\u003c\/strong\u003e Selects the next reminder stage based on the overdue timeline (for example \u003cstrong\u003eday 0, 7, 14\u003c\/strong\u003e) or triggers escalation when the escalation day is reached.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail:\u003c\/strong\u003e Sends reminder emails to the \u003cstrong\u003ecustomer\u003c\/strong\u003e, or—when \u003cstrong\u003etest mode\u003c\/strong\u003e is enabled—routes emails to the \u003cstrong\u003efinance inbox\u003c\/strong\u003e. Escalations can be sent to an \u003cstrong\u003eescalation contact\u003c\/strong\u003e for manual follow-up.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate sends:\u003c\/strong\u003e Updates the matching Google Sheets row with \u003cstrong\u003elast_stage_sent\u003c\/strong\u003e and \u003cstrong\u003elast_sent_at\u003c\/strong\u003e so the same stage isn’t sent twice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends weekly aging summary:\u003c\/strong\u003e On the configured weekday, builds a receivables aging summary (\u003cstrong\u003eNot yet due, 0–30, 31–60, 61–90, 90+\u003c\/strong\u003e) and emails it to the finance inbox via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce payment delays by automatically emailing overdue invoice reminders on day 0, 7, and 14.\u003c\/li\u003e\n  \u003cli\u003eEscalate long-overdue invoices to a dedicated contact without manual spreadsheet checks.\u003c\/li\u003e\n  \u003cli\u003eKeep finance updated with a weekly receivables aging report generated from the same invoice source.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n schedule\u003c\/strong\u003e (weekday 9:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e nodes (Invoices tab; unformatted values)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node for customer reminders, escalation emails, and weekly aging reports\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e \u003cem\u003eif, set, code, gmail, sticky note, google sheets\u003c\/em\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Create an \u003cstrong\u003eInvoices\u003c\/strong\u003e tab with required columns (including \u003cstrong\u003einvoice_id\u003c\/strong\u003e, \u003cstrong\u003edue_date\u003c\/strong\u003e, \u003cstrong\u003estatus\u003c\/strong\u003e, \u003cstrong\u003elast_stage_sent\u003c\/strong\u003e, \u003cstrong\u003elast_sent_at\u003c\/strong\u003e), add Google Sheets and Gmail credentials in n8n, and select the target spreadsheet in the Google Sheets nodes.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132821164211,"sku":"N8N-20173","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WqydPRgNEGyQbfruq20mN_7MZRy6Gl.png?v=1790759473","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-send-overdue-invoice-reminders-via-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}