Chase Overdue Google Sheets Invoices Automatically via Slack
This checks Google Sheets for invoices past their due date and sends a polite, escalating Slack reminder to the client — so you get paid faster without the awkward manual chasing.
- 1
Step 1 — Schedule the check
Add a
Schedule Trigger(daily). - 2
Step 2 — Find overdue invoices
Add a
Google Sheetsnode returning unpaid invoices whose due date has passed, with the client contact and amount. - 3
Step 3 — Pick the right reminder
Add a
Switchon how many days overdue so tone escalates gently: a nudge at 3 days, firmer at 14, final notice at 30. - 4
Step 4 — Send via Slack
Add a
Slacknode. SetResourcetoMessageandOperationtoSend. Choose the channel (e.g.#alerts) and drop the invoice number, amount due, and a payment link into the message text using expressions like{{ $json.summary }}. Connect your Slack OAuth or bot-token credential.
Frequently asked questions
Will it message paid invoices by mistake?
No — Step 2 filters to unpaid status straight from Google Sheets, so once an invoice is marked paid it drops out of the chase.
Can I CC my accounts team?
Yes — add them as a CC in the Slack step, or branch a copy to a Slack channel so finance can see who's been chased.