Send branded overdue invoice statements from Xero with PDFMint and Gmail
UnknownWhat this workflow does
This workflow has 7 nodes and runs on a schedule (cron 0 9 * * 1-5). Along the way it connects Xero, Gmail and Pdfmint (community).
How it runs
Trigger: On a schedule (cron 0 9 * * 1-5).
- Your company details (Edit Fields (Set)): sets 4 fields: companyName, companyAddress, accentColour…
- Get unpaid invoices from Xero (Xero): get many (invoice)
- Group overdue invoices per customer (Code): runs custom JavaScript code
- Anything actually overdue? (If): checks a condition and branches into true / false
- Render the statement as PDF (Pdf Mint): pdf (document)
- Email the statement (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-pdfmint is verified or supports 3.0 (used in Render the statement as PDF).
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Xero
n8n-nodes-base.xero - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Pdf Mint
n8n-nodes-pdfmint.pdfMint - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs every weekday morning to pull authorised accounts-receivable invoices from Xero, groups any past-due balances by customer, generates a branded overdue-invoice statement PDF with PDFMint, and emails each customer their…