Quick overview
Quick overview This workflow runs on a schedule to pull outstanding customer invoices and supplier bills from Xero, ranks the top 5 by amount due, and generates a Markdown AR/AP snapshot (optionally adding an OpenAI-based narrative summary). How it works Runs on a scheduled trigger (weekly by default). Sets report metadata and Xero invoice filters for receivables (ACCREC) and payables (ACCPAY) with AmountDue > 0. Fetches all matching authorised customer invoices and supplier bills from Xero. Normalizes dates and amounts, calculates days outstanding, sorts by amount due, and keeps the top 5 items for each list. Merges both lists and builds a Markdown snapshot with two tables and reporting notes. Outputs the final snapshot data (and, if enabled, sends the Markdown to OpenAI via an AI Agent to prepend a short AI summary). Setup Add a Xero OAuth2 credential and select the correct Xero tenant/organization ID used by the Xero nodes. Update the tenant/organization value in the snapshot settings (replace YOUR_XERO_TENANT_ID) and adjust the cadence label if needed. Configure the Schedule Trigger interval (weekly/monthly/quarterly/annual) to match your reporting rhythm. Optional: add an OpenAI (chat model) credential and connect the Markdown output through the AI Agent path to generate an AI summary. Connect the final output node to your delivery or storage destination (for example Email, Slack, Notion, or Google Sheets). An n8n automation workflow template by Kristian.
Kristian
web
free
Others in the same category, ranked by how often they are opened.
