{"product_id":"odoo-overdue-invoice-reminder-workflow-gmail-slack-n8n","title":"Odoo Overdue Invoice Reminder Workflow: Gmail + Slack (n8n)","description":"\u003ch3\u003eOdoo overdue invoices, automatically chased—every Monday\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls \u003cstrong\u003eoverdue invoices from Odoo\u003c\/strong\u003e and sends a \u003cstrong\u003eweekly overdue digest via Gmail\u003c\/strong\u003e plus a \u003cstrong\u003eSlack update\u003c\/strong\u003e, then escalates payment follow-ups by days overdue with tiered reminders and a \u003cstrong\u003e30+ day account-manager alert\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e executes every \u003cstrong\u003eMonday at 9am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls overdue invoices from Odoo:\u003c\/strong\u003e searches \u003cstrong\u003eaccount.move\u003c\/strong\u003e records for \u003cstrong\u003eposted, unpaid invoices\u003c\/strong\u003e with \u003cstrong\u003edue dates in the past\u003c\/strong\u003e (using data like \u003cem\u003epartner_id\u003c\/em\u003e, due date, and payment state).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFallback email when Odoo fetch fails:\u003c\/strong\u003e if the Odoo fetch fails, it sends the overdue ops email using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and calculates overdue days:\u003c\/strong\u003e prepares invoice fields and computes how many days each invoice is overdue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a weekly digest:\u003c\/strong\u003e aggregates all overdue invoices into an \u003cstrong\u003eHTML digest\u003c\/strong\u003e sent by \u003cstrong\u003eGmail\u003c\/strong\u003e to finance, and posts a \u003cstrong\u003etext summary\u003c\/strong\u003e to a \u003cstrong\u003eSlack\u003c\/strong\u003e finance channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates by tier:\u003c\/strong\u003e routes invoices into escalation tiers based on days overdue:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003e7–13 days\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003e14–29 days\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003e30+ days\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eUnder 7 days\u003c\/strong\u003e (included in routing logic)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReminds customers via Gmail:\u003c\/strong\u003e for \u003cstrong\u003e7–13\u003c\/strong\u003e and \u003cstrong\u003e14–29\u003c\/strong\u003e, looks up the \u003cstrong\u003ecustomer contact in Odoo\u003c\/strong\u003e and sends the correct reminder email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates 30+ to account managers:\u003c\/strong\u003e for \u003cstrong\u003e30+ day invoices\u003c\/strong\u003e, posts an alert to a \u003cstrong\u003eSlack account-manager channel\u003c\/strong\u003e and logs a follow-up \u003cstrong\u003eactivity back on the invoice in Odoo\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly A\/R follow-up for SaaS finance teams who want consistent overdue reminders.\u003c\/li\u003e\n  \u003cli\u003eEscalation workflows that move invoices from “reminder” to “account-manager attention” automatically at \u003cstrong\u003e30+ days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOps visibility: finance gets a digest in \u003cstrong\u003eGmail\u003c\/strong\u003e and a snapshot in \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e runs every Monday at 9am (n8n schedule).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ integrations:\u003c\/strong\u003e \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003eodoo\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e add an \u003cstrong\u003eOdoo API credential\u003c\/strong\u003e with access to Accounting\/Invoicing; ensure invoices exist in \u003cstrong\u003eaccount.move\u003c\/strong\u003e with \u003cstrong\u003epartner_id\u003c\/strong\u003e, due dates, and payment state populated.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail setup:\u003c\/strong\u003e configure finance\/ops recipients (e.g., \u003cem\u003efinance-team@yourcompany.com\u003c\/em\u003e, \u003cem\u003eops-team@yourcompany.com\u003c\/em\u003e) and email wording.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack setup:\u003c\/strong\u003e set target channel IDs\/names for the finance digest and the \u003cstrong\u003eaccount-manager\u003c\/strong\u003e alerts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814429286579,"sku":"N8N-17990","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/LJS8mG1X4CU9ls78Ab1wO_ZpoTynr4.png?v=1786439762","url":"https:\/\/buyflowscripts.com\/products\/odoo-overdue-invoice-reminder-workflow-gmail-slack-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}