Skip to main content

List overdue QuickBooks Online invoices in Google Sheets

  • Nov 11, 2026 4:42 PM UTC
  • 0 replies
  • 0 views

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager

Using Zapier, find the invoices in QuickBooks Online that are past their due date. List the customer, amount and due date for each one, then wait for my OK before adding them as rows to my Google Sheet called Chase list. Don't send anything to customers.

 

This prompt finds the QuickBooks Online invoices that are past their due date, lists the customer, amount and due date for each one and, once you approve, adds them to a Google Sheet so you know who to chase. It sends nothing to customers.

Apps you need: QuickBooks Online and Google Sheets, both connected to Zapier MCP
Good for: small businesses and finance admins who chase late payments

Make it yours

  • Change Chase list to your own sheet.
  • Only include invoices more than 14 days overdue.
  • Ask for the list sorted by amount, largest first.

Used it to chase payments? Reply here with how you sorted your list, by amount, by days overdue or by customer.