Chase unpaid Podium invoices with escalating text reminders

By General Input

Every weekday morning, every overdue Podium invoice gets the right nudge by text, and the oldest or largest ones go to a person to call instead.

Integrations

  • Podium
  • Google Sheets
  • Slack

Type

Agentic Task

Categories

  • Finance
  • Operations

Every weekday at 9am, chase my unpaid Podium payment invoices, and escalate the ones that are too old or too large to keep texting about.

Start by reading my Google Sheets collections tracker with Get Values, before sending anything at all. The tracker is my record of which invoices have already been chased, how many reminders each one has received, and when the last reminder went out. This read has to happen first on every single run. If you send before you read, the reminder cap silently breaks and customers get spammed.

Then pull my invoices from Podium with List Invoices. Use Get Invoice on any invoice where you need more detail, such as the contact on it, the balance, or the due date. Work out which invoices are still unpaid, and how many days past due each one is.

For each unpaid invoice, decide the follow up from both the age of the invoice and what the tracker says has already been sent. Around 3 days overdue, send a light friendly nudge. Around 14 days overdue, send a firmer reminder that is clear about next steps. Never send more than three reminders in total for the same invoice, counting every previous run, not just this one. Never send the same invoice two reminders in the same run, and leave a sensible gap since the last reminder rather than chasing on consecutive days.

Send each reminder as a text message to the contact on the invoice using Podium Send Message. Write the message yourself and match the tone to how late the invoice is: warm and low pressure at 3 days, direct and specific at 14. Keep them short, reference the invoice amount and the due date, and include the payment link if the invoice has one.

Do not text an invoice that is more than 30 days overdue, or whose balance is above a dollar threshold I set. Make that threshold an easy input to change, and default it to 1000 dollars. Those invoices go to my Slack collections channel with Send a Message instead, so a person picks up the phone rather than sending another text. Include the customer name, the amount outstanding, how many days overdue it is, how many reminders have already gone out, and the contact phone number, so whoever grabs it can call without digging anything up.

Log everything back to the tracker with Append Values. Write one row per reminder sent and one row per escalation, each with the date, the invoice id, the customer, the amount, the days overdue, which action was taken (friendly nudge, firm reminder, or escalated to Slack), the running reminder count for that invoice, and a short note. Also record when an invoice that was chased in an earlier run now comes back as paid, so I can see what the chasing actually recovered.

If there is nothing overdue to chase on a given morning, do nothing quietly. Do not post an empty summary to Slack.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageWin back LiveChat visitors whose chats went unansweredLet support send one-off Loops emails without an engineerStop cold emails to anyone with a live deal in PipedriveiMessage campaign console with pre-flight checks and delivery boardChat quality review board for LiveChat support leadsLinkedIn Ads budget pacing dashboard for every client accountFront desk appointment confirmation board for the next 3 daysGive your team Looker numbers without buying more seats