Monitors invoice due dates from Google Sheets, calculates overdue days, and sends escalating reminder emails at 7, 14, and 21 days to ensure timely client payments.
This workflow automates invoice payment reminders by triggering on new or updated rows in a Google Sheets spreadsheet containing invoice data, such as due dates in column D. It fetches the current date, calculates the number of overdue days using a date helper, and employs a router to direct the flow based on overdue thresholds: polite reminders after 7 days, firmer notices at 14 days, and urgent demands at 21 days. Emails are customized with increasing urgency to prompt payment without manual i
Platform
n8n
Category
Real Estate
Price
$12.99
Creator
Fred Garcia
invoice-reminders
overdue-payments
google-sheets
email-automation
date-calculation
finance-automation
collections
real-estate
billing
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.