n8n TemplateJSON1 min read

Accounts Receivable Automation: Automatically Send Payment Reminders and Dunning Emails Every Day

Automates your accounts receivable process, automatically sends payment reminders and overdue notices, and follows up on outstanding invoices daily.

Philipp Schönberg

Philipp Schönberg

Co-Founder & Head of AI Automation

LinkedIn
Published July 1, 2026

Description

Manually tracking overdue invoices consumes valuable time and resources. As a result, payment follow-ups are often delayed until overdue payments have already turned into a cash flow problem. This n8n workflow automates your entire accounts receivable automation process. It reviews all outstanding invoices from SAP or Google Sheets every day, calculates how many days each payment is overdue, and automatically sends the appropriate email — from a friendly payment reminder on day one to a collection notice after 21 days, with tone and urgency increasing automatically over time. The result: a complete receivables management process running every day without manual intervention or expensive dunning software subscriptions.

What this workflow covers

Fully Automated 6-Step Dunning Process — From a friendly payment reminder on day one to multiple escalation stages and a collection notice after 21 days, each communication is triggered automatically at the appropriate time.

Automatically Escalating Communication — Email tone evolves with the severity of the delay, progressing from professional and cooperative to formal and legally oriented without requiring manual adjustments.

Daily Review of Outstanding Invoices — The workflow scans your Google Sheets invoice database every day, identifies unpaid invoices, and contacts only those that require the next escalation step. No duplicate reminders. No forgotten invoices.

Automatic Status Updates — After each email is sent, the corresponding dunning stage and communication date are automatically updated within the invoice sheet, ensuring accurate records at all times.

Set Up Once, Benefit Permanently — Customize email templates, timelines, and sender information once. After that, the entire automated dunning process runs without ongoing maintenance or manual involvement.

Whether you are looking to replace costly dunning software or simply want a more reliable way to manage outstanding invoices, this workflow provides a practical foundation for modern accounts receivable automation.

Free Download

Accounts Receivable Automation: Automatically Send Payment Reminders and Dunning Emails Every Day

Step 1 of 4

How can we reach you?

Enter your business details to unlock the download.

Want to adapt this for your business?

Request Automation Audit