Skip to content
Workflow · Calculate · Opening soon

Xero invoices to Google Sheets every day, with checks

Export your sales invoices from Xero, then have Mammoth read the file and write one row per unpaid invoice into Google Sheets. Include Xero status, invoice date, due date, amount due, and days overdue, then mark each row as Overdue, Old draft, No due date, or Agrees.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Xero sales invoices
    CSV export · 44 rows
  2. Step
    Mark drafts 30 days old
    Step 1
  3. Result
    Unpaid invoice status
    24 rows · 10 flagged
  4. Schedule
    Runs daily
    Proposed

On the sample files, every step runs and the result has 24 rows.

What you get back

The result of that run, the rows to look at first.

Unpaid invoice statusSample data24 rows
14 agrees8 overdue2 no due date
Invoice NumberDays overdueAmount dueStatusXero statusInvoice dateDue date
INV-1076·7,300No due dateAwaiting Payment2026-11-16·
INV-1077·5,400No due dateDraft2026-11-16·
INV-1046434,800OverdueAwaiting Payment2026-09-282026-10-10
INV-1042418,400OverdueAwaiting Payment2026-09-122026-10-12
INV-10443812,750OverdueAwaiting Payment2026-09-202026-10-15
INV-1048376,500OverdueAwaiting Payment2026-10-032026-10-16
INV-1052367,600OverdueAwaiting Payment2026-10-122026-10-17
INV-10501511,800OverdueAwaiting Payment2026-10-082026-11-07
INV-105476,900OverdueAwaiting Payment2026-10-162026-11-15
INV-105628,800OverdueAwaiting Payment2026-10-212026-11-20
INV-106608,400AgreesAwaiting Payment2026-11-062026-12-06
INV-106009,700AgreesAwaiting Payment2026-10-302026-11-29
24 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Unpaid invoice status workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your sales invoices from Xero, then have Mammoth read the file and write one row per unpaid invoice into Google Sheets. Include Xero status, invoice date, due date, amount due, and days overdue, then mark each row as Overdue, Old draft, No due date, or Agrees. Sort the sheet by days overdue, with the most overdue invoices first, and treat drafts that are at least 30 days old as old.
Which Xero export should you use?
Use a sales invoices export from Xero that includes the invoice status, invoice date, due date, amount due, and days overdue if you want that field in the sheet.
What happens to invoices that do not match a check?
They still appear in the sheet. They get the status that matches the rules, such as Overdue, Old draft, No due date, or Agrees.
How do you change the rules later?
Change the rule text in words, for example, adjust the age for old drafts or the overdue threshold, then run the workflow again with a new export.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

Schedules, commissions, costing and margins, worked out the same way from every new export.

All calculate workflows →