AI Advisor

Automated Invoice Follow-Up System

Automated accounts receivable system built in n8n. Reads invoices from Google Sheets, calculates overdue days, and sends staged payment reminder emails via Gmail — pausing when clients reply and escalating aged accounts to a human. Built to reduce DSO for contractors and small businesses.

Flowchart of the invoice follow-up workflow: a daily 10 AM check reads invoices from Google Sheets, filters the overdue rows and calculates days past due, then a switch routes each account to a first notice, follow-up 1, follow-up 2, or escalation. Escalation also posts a Slack alert. Every branch writes its result back to the invoice sheet.Daily Check10 AM · scheduleRead InvoicesGoogle SheetsFilter Overduecalculate daysSwitchmode: RulesSend Reminderfirst noticeSend Follow Upfollow up 1Send Follow Up 2follow up 2Escalationsend: messageSlack Alertpost: messageUpdate SheetappendOrUpdate

A glimpse of the actual build.

Watch it run end to end.

Four minutes through the live build: the morning check reading the invoice tracker, the switch sorting every overdue account into first notice, follow-up or escalation, and the reminders going out on their own. Nothing staged — this is the system working a real sheet.

Other systems I’ve built.