Workflow 03Design, not built yet

QuickBooks overdue invoice follow-up with AI: an n8n workflow design

Chasing overdue invoices is a weekly chore that is easy to put off. This workflow fetches the overdue invoices from QuickBooks every Monday, asks an AI to draft a polite reminder for each, and by default sends the drafts to a staff member as one review email. Nothing goes to a customer unless you switch automatic sending on. Invoices over 30 days overdue, or with no email on file, always go to a person.

The workflow canvas

03 - QuickBooks Overdue Invoice Follow-up

Steps, in order

  1. In the sample run

    Starts the workflow every Monday at 9 am.

    You would set

    • Scheduleweekly, Monday 09:00

Branch, off by default

A person reviews here

  • Mondays 9 am. autoSend is off by default, so drafts go to staff for review.
  • Over 30 days overdue, or no email on file: always goes to a human.

IllustrationThe ticks mark the steps of a sample run, drawn as an example.

An illustration of how the steps connect, not a screenshot from a live n8n. Green ticks mark the steps of a sample run. A dashed step is off by default.
  • Starts it
  • Calls or sends
  • AI
  • Accounting
  • Logic and settings
  • Sample run
  • Off by default

Use the arrow keys to move between steps. The selected step is described after the canvas.

What is built into the design

  • Runs on Mondays at 9 am.
  • Automatic sending is off by default. Drafts go to staff as a review digest.
  • Anything over 30 days overdue, or with no email address on file, always goes to a human.
  • The AI only drafts the email. It does not decide whether to send.

What you need

  1. 01A QuickBooks account with API access
  2. 02An n8n instance
  3. 03An AI model account (the design uses a Claude model)
  4. 04An email account to send from

How you would set it up

  1. 01

    Connect QuickBooks and choose which invoices count as overdue.

  2. 02

    In Config, set the sender name, the tone of the emails and the staff address that receives the review email.

  3. 03

    Leave automatic sending off. Run the workflow and read a week of drafts first.

  4. 04

    Only if you decide to, turn automatic sending on for invoices that are lightly overdue.

Add these before it touches real customers

  • Put the invoice number, amount and due date into the email in code, not from the AI, so a wrong figure cannot reach a customer.
  • An error workflow that alerts a person if QuickBooks, the AI or the email step fails.
  • A rule that the AI never mentions fees, legal action or deadlines that are not in your policy.
  • A written test with a lightly overdue invoice, a very overdue invoice and an invoice with no email.

Stay safe

  • Anything that goes to a customer about money should have a person’s sign-off until you trust it. That is why the review digest is the default path. The approval gate demo shows the same idea.
  • Do not let the AI invent amounts, dates or threats. Give it the invoice facts and tell it to use only those.
  • Invoice data is business data, but it can still name people. Keep it out of places it does not need to be.

Texting and emailing rules differ by country and by who you are contacting. Check yours with a qualified adviser. This page is not legal advice.

Questions

Does the AI send the emails?

Not by default. The AI only writes drafts. With automatic sending off, which is the default, all drafts go to a staff member as one review email, and a person decides what to send.

What stops the AI from getting an amount wrong?

In the safe version of this design, the invoice number, amount and due date are filled in by code from QuickBooks, and the AI writes only the wording around them. That is on the list to add before going live.

Is the design tested?

No. This is a drawn design, not a built and tested workflow, and not a screenshot of a live n8n. Any real build would be tested with made-up invoices first.

Want this built into your own workflow?

Tell me what you use today and what you do by hand. I will say what is safe to automate, what needs a person, and roughly what it would take. I reply within 24 hours.

Wondering what your project will cost?

Get a free price range and timeline in 24 to 48 hours. No commitment.

Get a Free Estimate