Categories / Invoicing/Collections/Cash Flow

Reddit r/nocode: invoice follow-up on day 7/14/21 with cancel-on-pay

Invoice reminders on day 7, 14 and 21 that stop the moment the invoice is marked paid — no more awkward "did you see my last email?" after they've already paid.

CostFree (Google Sheets + Gmail) or Zapier Free/ProOriginal Reddit post (via search excerpt) didn't name the no-code tool. This reconstructs the same day-7/14/21 cancel-on-pay pattern with Sheets + Gmail drafts, or Zapier.
Businessautomation builder describing a client workflow (r/nocode; via search index)
Status✓ Setup guide
Added2026-10-14
SourceReddit View original ↗
Task
no-code invoice reminder sequence that stops when paid
Result
no numeric result in the indexed excerpt; exact trigger logic shared
Tools
  • no-code automation (unnamed in excerpt) + invoice register
Setup
  1. create invoice-register row → schedule reminders at days 7, 14, 21 → cancel pending reminders when payment is recorded → status flags to prevent duplicate sends → escalate 30+ day invoices to a human
Step-by-step setup guide + copy-paste prompt

Why this way: r/nocode builder pattern. Rule-based, not generative AI.

Prerequisites

  • Sheet "Invoices": Invoice #, Client, Email, Amount, Issue date, Due date, Status (open/paid), Last reminder day.
  • Gmail.
  • Optional Zapier Free/Pro for automation.
  • Time: 45 minutes.

Step-by-step setup

Step 1. Keep Status updated (paid = paid) — from your accounting export or by hand.

Step 2. Manual: every Monday filter Status=open and due age ≥7/14/21; send the matching template.

Step 3. Zapier: Schedule weekly → Google Sheets Get many rows where Status=open → Paths/Filter by days overdue → Gmail Create Draft (or Send once trusted) with template → update Last reminder day.

Step 4. Cancel-on-pay: when Status becomes paid, Filters stop matching — no more reminders.

Step 5. Never threaten legal action in templates; escalate to a human call after day 21.

Copy-paste prompt

(Optional) Tone-check this reminder for invoice {{num}} amount {{amount}} days overdue {{days}}. Keep under 80 words, firm but polite, include pay link {{link}}. No legal threats.

Sources

Results as reported by the source; not independently verified. Community-sourced from public sites and attributed to the source platform. Original author? Ask us to correct or remove it. Read the disclaimer.

More in Invoicing/Collections/Cash Flow

Invoicing & Cash Flow

J M Keehn: Docyt AI bill entry for boutique accounting firm

LA boutique accounting/business management firm (entertainment clients + restaurants/medical); 35+ years

~25 hours/week saved on bill entry; managing partner saves 10–15 hours/week on review; grew client base same headcount; "cleanest statements" for tax prep (as stated)

Paid: Docyt (quote / subscription)✓ Setup guide

Weekly newsletter

5 SMB Automations This Week

One short email a week: five real automations from small businesses, with the tools and setup steps. Free.

Coming soon. The newsletter launches shortly.