{"product_id":"n8n-workflow-send-xero-overdue-invoice-statements-via-gmail","title":"n8n Workflow: Send Xero Overdue Invoice Statements via Gmail","description":"\u003ch3\u003eAutomatically email Xero overdue invoice statements to customers—every weekday\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls unpaid, past-due \u003cstrong\u003eXero (ACCREC) invoices\u003c\/strong\u003e, generates a branded overdue statement PDF for each customer, and emails it via \u003cstrong\u003eGmail\u003c\/strong\u003e—running automatically every weekday morning at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Executes every weekday at 09:00 using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches invoices from Xero:\u003c\/strong\u003e Retrieves authorised accounts-receivable (ACCREC) invoices for your specified Xero organisation (tenant ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters overdue items:\u003c\/strong\u003e Keeps only invoices that are \u003cem\u003eunpaid\u003c\/em\u003e and \u003cem\u003epast their due date\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroups by customer:\u003c\/strong\u003e Aggregates overdue balances per contact and builds a branded HTML statement including totals and \u003cstrong\u003edays overdue\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents empty emails:\u003c\/strong\u003e Skips processing for customers when there are no overdue invoices, avoiding blank statements.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates PDF statements:\u003c\/strong\u003e Renders each customer’s HTML statement into a PDF using \u003cstrong\u003ePDFMint\u003c\/strong\u003e and names the PDF after the customer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail:\u003c\/strong\u003e Emails the PDF statement to the customer’s email address stored in Xero, using a subject line that includes \u003cstrong\u003einvoice count\u003c\/strong\u003e and \u003cstrong\u003etotal outstanding\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReducing manual dunning by sending consistent \u003cstrong\u003eoverdue invoice statement\u003c\/strong\u003e emails to customers in your accounts receivable process.\u003c\/li\u003e\n  \u003cli\u003eMaintaining professional, on-brand communication with automated PDFs generated through \u003cstrong\u003ePDFMint\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers who need a reliable Xero-to-email workflow that only sends when there’s something overdue.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/stack:\u003c\/strong\u003e if, set, code, xero, gmail, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Xero (OAuth2), Gmail (OAuth2), PDFMint\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup highlights:\u003c\/strong\u003e Provide your Xero OAuth2 credential, update the Xero organisation\/tenant ID, add PDFMint and Gmail credentials, and ensure each Xero contact has an email address.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931067277491,"sku":"N8N-18960","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xdykXkxneMVnh-nFaZt5g_wWQBTzHL.png?v=1788254131","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-send-xero-overdue-invoice-statements-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}