How to Automate Unpaid Invoice Reminders Without Coding (Free Blueprint)

Chasing overdue invoices is one of the most time-consuming and uncomfortable tasks for freelancers and agencies. This blueprint automates the entire follow-up sequence — a friendly nudge at Day+5, a firm reminder at Day+15, and a formal notice at Day+30 — with zero code and about 30 minutes of setup.

Why automating invoice reminders is the highest-ROI automation for freelancers

The average freelancer or agency owner spends 2–4 hours per month manually chasing late payments. That's not just lost time — it's an awkward, recurring task that often gets delayed out of discomfort, making the late payment even later. Automated invoice reminders eliminate both problems: the follow-ups go out on schedule, consistently, and you never have to think about it.

This guide gives you a complete no-code invoice automation blueprint with three escalation levels. It works with Google Sheets, Airtable, or any invoicing tool that has an API or CSV export. No developers, no monthly SaaS fee for a dedicated collections tool.

What you need before starting

• An invoice tracker: Pennylane, Google Sheets, Airtable, or a CSV from your invoicing software
• An email sending service: Gmail, Brevo (formerly Sendinblue), or Mailgun
• A NanoCorp account to orchestrate the automation (free to start)
• 30 minutes for the initial setup

How the automated follow-up system works

The blueprint has three components working together:

1. A data source: your invoice list with due dates and payment status
2. A conditions engine: calculates whether an invoice is at Day+5, Day+15, or Day+30 overdue
3. An email sender: delivers the right message to the right client at the right time

NanoCorp connects these three pieces in a single automated debt recovery workflow triggered every weekday morning.

6 steps to automate your overdue invoice follow-ups

Here's the full setup from scratch:

1. Set up your invoice data source (Google Sheets, Airtable, or your invoicing tool)
2. Create the detection workflow in NanoCorp
3. Configure the overdue logic by escalation level (Day+5, Day+15, Day+30)
4. Write the 3 email templates
5. Auto-update the status field after each send
6. Test with a dummy invoice before activating

1 Set up your invoice data source

Whatever tool you use, you need at minimum these columns in your invoice tracker:

• invoice_number — unique ID (e.g., INV-2026-042)
• client_name — full name or company
• client_email — billing contact email
• amount — total amount due
• due_date — payment deadline (YYYY-MM-DD format)
• status — values: pending, paid, overdue
• reminder_1_sent — boolean (Yes/No)
• reminder_2_sent — boolean
• reminder_3_sent — boolean

If you use invoicing software, it likely has an API or automatic CSV export. A Google Sheet is perfectly sufficient to get started with your first automated invoice follow-up workflow.

2 Create the workflow in NanoCorp

Log into NanoCorp and create a new workflow. Name it Automated Invoice Reminders.

Configure the trigger:

• Type: Scheduler
• Frequency: Every day at 9:00 AM
• Timezone: Your local timezone
• Active days: Monday through Friday only

3 Configure the overdue logic

In NanoCorp, add a Read data source module connected to your Google Sheet or Airtable. Then add a Filter / Conditions module with this logic:

Reminder 1 — Day+5 (friendly nudge):

due_date < today - 5 days
AND status = "pending"
AND reminder_1_sent = No

Reminder 2 — Day+15 (firm follow-up):

due_date < today - 15 days
AND status = "pending"
AND reminder_1_sent = Yes
AND reminder_2_sent = No

Reminder 3 — Day+30 (formal notice):

due_date < today - 30 days
AND status = "pending"
AND reminder_2_sent = Yes
AND reminder_3_sent = No

4 Write the 3 email templates

Here are the three invoice reminder email templates to configure. Keep the tone progression: friendly → firm → formal.

Reminder 1 — Friendly nudge (Day+5):

Subject: Invoice {invoice_number} — quick payment reminder

Hi {client_name},

Just a quick note that invoice {invoice_number} for {amount} was due on {due_date}. If payment is already on its way, please disregard this message.

Otherwise, you can transfer to the usual bank details at your convenience.

Thanks,
[Your name]

Reminder 2 — Firm follow-up (Day+15):

Subject: Invoice {invoice_number} — second payment reminder

Hi {client_name},

Despite my previous reminder, invoice {invoice_number} for {amount}remains unpaid. I'd appreciate you settling this within the next 5 business days.

If there's an issue on your end, feel free to reach out so we can find a solution.

Best regards,
[Your name]

Reminder 3 — Formal notice (Day+30):

Subject: FORMAL NOTICE — Invoice {invoice_number} overdue

Dear {client_name},

This is a formal notice that invoice {invoice_number} for {amount} remains unpaid, despite two prior reminders. You are required to settle this amount within 8 calendar days. Failure to do so may result in collection proceedings.

[Your full name]
[Your professional contact details]

5 Auto-update the status after each send

After each invoice reminder email is sent, NanoCorp must update your data source to prevent re-sending. In your workflow, after each email send module, add an Update row module:

• After Reminder 1: set reminder_1_sent → Yes
• After Reminder 2: set reminder_2_sent → Yes
• After Reminder 3: set reminder_3_sent → Yes and status → collections

6 Test before going live

Before activating the scheduler, test with a dummy invoice where you've replaced the client email with your own:

1. Create a test row with a due date 6 days in the past and reminder_1_sent = No
2. Trigger the workflow manually in NanoCorp
3. Confirm you receive the Reminder 1 email with all variables correctly filled
4. Check that reminder_1_sent has updated to Yes in your data source
5. Re-trigger the workflow — the email should NOT be sent again (idempotency test)

Once everything checks out, activate the scheduler. The workflow will run every weekday morning automatically.

AI prompt to personalize your reminder emails

To generate AI-personalized invoice reminder emails based on client history (adjust tone per relationship), use this prompt in your NanoCorp AI module:

You are a professional collections assistant.
Write an invoice reminder at escalation level {{reminder_level}} (1=friendly, 2=firm, 3=formal).

Invoice details:
- Number: {{invoice_number}}
- Amount: {{amount}}
- Days overdue: {{days_overdue}}
- Client name: {{client_name}}

Relationship notes: {{client_notes}}

Rules:
- Level 1: warm, conversational, 80-120 words, assume good faith
- Level 2: firm but professional, 100-150 words
- Level 3: formal legal language, 150-200 words
- Never open with "In today's digital age..."
- Return only the email body (no subject line)

5 mistakes to avoid in your invoice automation

1. Sending reminders on weekends. Set your scheduler to weekdays only. A formal notice arriving on Sunday evening sends the wrong signal.
2. Not handling partial payments. Add an amount_paid column. The workflow should check amount_paid < amount before sending any reminder.
3. Reminding a client already in dispute. Add a filter that excludes invoices with status dispute or collections from the automated flow. Those need manual handling.
4. Using the same template for all clients. Add a tone column (formal/informal) and branch your email template based on it. Long-term clients get a different message than a one-off client.
5. Not storing the message ID. Configure your email module to store the message_id for every sent reminder. If a client claims they never received it, you have proof.

Typical results from automated invoice reminders

Based on typical freelancer and agency workflows using this system:

• 65–70% of overdue invoices paid after Reminder 1 (Day+5)
• 20–25% more resolved after Reminder 2 (Day+15)
• 5–8% requiring Reminder 3 or manual intervention
• 2–4 hours per month saved on manual follow-up tasks

Conclusion

Automating overdue invoice reminders delivers one of the best ROIs of any automation a freelancer or small agency can set up. Configure it once, and it runs every morning without you thinking about it — no more awkward follow-up emails, no missed invoices aging past 60 days.

The key is a clean data source and idempotent logic (never send the same reminder twice). NanoCorp handles both natively: conditional workflows that check sent status before firing, and native connectors for Google Sheets, Airtable, and most invoicing tools.

Start with Reminder 1 only. Watch the results for 2 weeks. Then activate Reminders 2 and 3 once you've validated the flow.

Running other automations on Make.com or Zapier? Read our comparison of the best free Zapier alternatives in 2025 to find the right platform for your full automation stack. And if your Make.com webhook scenarios keep timing out, check our fix guide for the Make.com Shopify webhook timeout error.