Weekly reminders for overdue invoices

Every week the scenario finds unpaid invoices in Google Sheets more than a week overdue, emails a reminder via sendPulse and marks it as sent.

  • Overdue invoices aren't forgotten
  • The reminder goes out without an awkward conversation
  • No invoice is chased twice
  • It all runs itself, every Monday
Set it up for yourselfScriptera

How it works

To get Google Sheets notifications in sendPulse, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Every Monday 08:00
  2. Then: Configure
  3. Then: Read Invoice Sheet
  4. Then: Capture Row Index
  5. Check: Filter Unpaid Invoices
  6. Then: Calculate Days Overdue
  7. Check: Filter Overdue 7+ Days
  8. Then: Send Reminder Email
  9. Then: Prepare Row Update
  10. Then: Update Invoice Status

You can launch this Google Sheets + sendPulse integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios