Xero invoices to Google Sheets every day, with checks
“send xero sales invoices to google sheets daily, one row per invoice not paid, with xero status, invoice and due dates, amount due, days overdue, and a status of Overdue, Old draft, No due date, or Agrees; sort by days overdue descending”
Send Xero sales invoices to Google Sheets daily, one row per invoice not paid, with Xero status, invoice and due dates, amount due, days overdue, and a status of Overdue, Old draft, No due date, or Agrees; sort by days overdue descending, counting drafts at least 30 days old as old.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileXero sales invoicesCSV export · 44 rows
- StepMark drafts 30 days oldStep 1
- ResultUnpaid invoice status24 rows · 10 flagged
- ScheduleRuns dailyProposed
On the sample files, every step runs and the result has 24 rows.
- Download Xero sales invoices sample (44 rows)Xero: Business > Invoices > Awaiting Payment (and other statuses) > Export
What you get back
The result of that run, the rows to look at first.
| Invoice Number | Days overdue | Amount due | Status | Xero status | Invoice date | Due date |
|---|---|---|---|---|---|---|
| INV-1076 | · | 7,300 | No due date | Awaiting Payment | 2026-11-16 | · |
| INV-1077 | · | 5,400 | No due date | Draft | 2026-11-16 | · |
| INV-1046 | 43 | 4,800 | Overdue | Awaiting Payment | 2026-09-28 | 2026-10-10 |
| INV-1042 | 41 | 8,400 | Overdue | Awaiting Payment | 2026-09-12 | 2026-10-12 |
| INV-1044 | 38 | 12,750 | Overdue | Awaiting Payment | 2026-09-20 | 2026-10-15 |
| INV-1048 | 37 | 6,500 | Overdue | Awaiting Payment | 2026-10-03 | 2026-10-16 |
| INV-1052 | 36 | 7,600 | Overdue | Awaiting Payment | 2026-10-12 | 2026-10-17 |
| INV-1050 | 15 | 11,800 | Overdue | Awaiting Payment | 2026-10-08 | 2026-11-07 |
| INV-1054 | 7 | 6,900 | Overdue | Awaiting Payment | 2026-10-16 | 2026-11-15 |
| INV-1056 | 2 | 8,800 | Overdue | Awaiting Payment | 2026-10-21 | 2026-11-20 |
| INV-1066 | 0 | 8,400 | Agrees | Awaiting Payment | 2026-11-06 | 2026-12-06 |
| INV-1060 | 0 | 9,700 | Agrees | Awaiting Payment | 2026-10-30 | 2026-11-29 |
How it works
How to use the Unpaid invoice status workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Unpaid invoice status: questions
How do you send Xero invoices to Google Sheets every day with checks?
Which Xero export should you use?
What happens to invoices that do not match a check?
How do you change the rules later?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Schedules, commissions, costing and margins, worked out the same way from every new export.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template