{"product_id":"n8n-xero-overdue-invoice-reminders-gmail-slack-sheets","title":"n8n Xero Overdue Invoice Reminders: Gmail + Slack + Sheets","description":"\u003ch3\u003eAutomate Xero overdue invoice reminders—daily, tiered, and logged\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls unpaid invoices from \u003cstrong\u003eXero\u003c\/strong\u003e every morning, calculates how many days they’re overdue, then sends \u003cstrong\u003etiered Gmail reminders\u003c\/strong\u003e and \u003cstrong\u003eSlack alerts\u003c\/strong\u003e—while recording each reminder in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to prevent duplicate follow-ups.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 08:00\u003c\/strong\u003e using a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads overdue thresholds\u003c\/strong\u003e (7, 14, 30 days) and fetches \u003cstrong\u003eunpaid invoices\u003c\/strong\u003e from your selected \u003cstrong\u003eXero organisation\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates days overdue\u003c\/strong\u003e for each invoice and assigns it to a 7-, 14-, or 30-day tier.\u003c\/li\u003e\n  \u003cli\u003eGenerates a unique identifier \u003cstrong\u003einvoiceId_tier\u003c\/strong\u003e and prepares key fields such as contact email and amount due.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks Google Sheets log\u003c\/strong\u003e to see whether \u003cem\u003ethat exact invoiceId_tier\u003c\/em\u003e has already been processed; if it has, the workflow skips it.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e7-day overdue:\u003c\/strong\u003e sends a friendly \u003cstrong\u003eGmail\u003c\/strong\u003e reminder to the customer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e14-day overdue:\u003c\/strong\u003e sends a firmer \u003cstrong\u003eGmail\u003c\/strong\u003e reminder and posts an internal \u003cstrong\u003eSlack\u003c\/strong\u003e alert.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e30-day overdue:\u003c\/strong\u003e posts a \u003cstrong\u003eSlack\u003c\/strong\u003e escalation message that includes a \u003cstrong\u003ecall task\u003c\/strong\u003e, then logs the processed \u003cstrong\u003einvoiceId_tier\u003c\/strong\u003e entries back to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce manual follow-up for customers with outstanding invoices in Xero.\u003c\/li\u003e\n  \u003cli\u003eGive your team early visibility at 14 days and escalation workflow at 30 days.\u003c\/li\u003e\n  \u003cli\u003eMaintain a reliable audit trail of reminders so customers aren’t spammed with repeated messages.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e Xero, Gmail, Slack, Google Sheets (plus if, set, code, merge).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthentication:\u003c\/strong\u003e OAuth credentials for \u003cem\u003eXero\u003c\/em\u003e, \u003cem\u003eGmail\u003c\/em\u003e, and \u003cem\u003eGoogle Sheets\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrerequisites:\u003c\/strong\u003e Xero contacts must include an email address so reminders have a valid recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheets requirement:\u003c\/strong\u003e a tab containing an \u003cstrong\u003einvoiceId_tier\u003c\/strong\u003e column for de-duplication.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114694103219,"sku":"N8N-20015","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6-3mATHgqGgpnhR6Wd1iX_dXhjKzBL.png?v=1790586647","url":"https:\/\/buyflowscripts.com\/products\/n8n-xero-overdue-invoice-reminders-gmail-slack-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}