Skip to content

Unpaid invoices: reminders with a graded tone

Every weekday morning, lists the invoices of your Table that are unpaid and at least 7 days overdue (columns invoice_number, client, email, amount, days_overdue, status, notes) and drafts one reminder each: friendly at 7 days, firm at 15, formal at 30. Drafts only, plus a Slack summary.

By
Loop & Roll team · Official
Copied
0 times
Steps
7
Version
1 · 18 October 2026
Requires
Loop & Roll 1.0.0 or later

Workflow graph

Unpaid invoices: reminders with a graded tone Hover a node to see its role · Drag to move the graph
For each item of “For each invoice”Every weekday at 9:00 — ScheduleEvery weekday at 9:00ScheduleList overdue invoices — Table — list rowsList overdue invoicesTable — list rowsFor each invoice — LoopFor each invoiceLoopfor eachdoneWrite the reminder — Compose (AI)Write the reminderCompose (AI)ModelSave the draft — SendSave the draftSendLog the reminder — Table — append a commentLog the reminderTable — append a comme…Tell the team — NotifyTell the teamNotifyOpenAI — OpenAI (GPT)OpenAIgpt-5-mini
Unpaid invoices: reminders with a graded tone

How it works

  1. 1

    Every weekday at 9:00

    trigger.schedule

  2. 2

    List overdue invoices

    table.list

  3. 3

    For each invoice

    flow.loop

  4. 4

    Write the reminder

    ai.compose

  5. 5

    Save the draft

    mail.send

  6. 6

    Log the reminder

    table.append_text

  7. 7

    Tell the team

    notify.send

What you will fill in after import

Nothing personal travels with a template: connections, mailboxes, tables and recipients are left blank for you to pick in your instance.

Tables to choose
List overdue invoices · table Log the reminder · table
Mailboxes to choose
Save the draft · mailbox
Connections to choose
OpenAI · connection (llm_provider)
Secrets to fill in
Tell the team · webhookUrl