Invoice Follow-up Agent with Dynamic Tone Control - n8n Workflow

• Freelancers and consultants seeking to professionalize billing.


• Digital agencies and small businesses managing client payments.


• Finance and accounting teams aiming to reduce manual collection time.


• Users looking for practical n8n templates for operational finance.

Managing overdue invoices is critical for cash flow, but manual follow-ups are time-consuming and often inconsistent. This robust n8n workflow solves this by fully automating the collection process. Every morning, the n8n trigger starts the process by fetching all invoice data from Google Sheets. It filters out paid invoices and calculates the exact number of days past due (DPD). The key value of this n8n template lies in its dynamic message generation, where the tone of the email reminder automatically escalates (from a friendly nudge to a firm demand) based on the DPD. By using this n8n automation, businesses ensure timely, consistent communication, improving collection rates without constant manual effort.

This powerful n8n workflow operates on a scheduled cadence to handle financial follow-ups efficiently.

1. Daily Initiation: The flow begins with the Daily Trigger, an n8n trigger, set to run early every morning (6 AM).


2. Load Data: The Load Invoices n8n node connects to Google Sheets to retrieve all data within the specified range (Invoices!A1:G1000).


3. Filtering: The Filter Overdue Invoices n8n node processes this list, keeping only records where the invoice status is 'unpaid' and the due_date is in the past.


4. Calculate DPD: The workflow then uses the Calculate DPD n8n node (a Function node) to determine the exact 'Days Past Due' (DPD) for each overdue invoice item.


5. Generate Message: The crucial Generate Message n8n node creates a personalized follow-up message. It uses conditional logic based on the DPD value:

1. Send Follow-up: Finally, the Send Email n8n node sends the dynamically generated, tone-adjusted message to the client's email address, completing the automated collections cycle using this effective n8n workflow.

To deploy this useful n8n workflow template, follow these steps:

1. Import: Copy the provided n8n workflow JSON and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Google Sheets Setup:

1. Email Configuration: Configure the Send Email n8n node with your SMTP or Gmail credentials so the n8n node can successfully dispatch the messages.


2. Customize Logic (Optional): Review the JavaScript logic within the Generate Message n8n node to fine-tune the reminder tones or DPD thresholds to match your company's policy.


3. Activate: Ensure the Daily Trigger is set to your preferred run time and activate the entire n8n workflow.

Daily Trigger (n8n trigger):
Function: Starts the entire n8n workflow automatically.
Key Configuration: Set to run daily at 6:00 AM.
Load Invoices (Google Sheets n8n node):
Function: Fetches all invoice data from the specified Google Sheet.
Key Configuration: Reads range Invoices!A1:G1000. Requires Google Sheets OAuth2 credentials.
Filter Overdue Invoices (Function n8n node):
Function: Uses JavaScript to filter the sheet data, passing only items where status is 'unpaid' and the due_date is earlier than today.
Calculate DPD (Function n8n node):
Function: Calculates the 'Days Past Due' (DPD) for each invoice item and attaches it as a new property (dpd) essential for the message generation step of this n8n workflow.
Generate Message (Function n8n node):
Function: Contains the core business logic. Based on the calculated DPD, it generates the appropriate email text with escalating levels of urgency (tone control).
Send Email (EmailSend n8n node):
Function: Sends the final, personalized reminder email using the text dynamically generated in the previous n8n node.
* Key Configuration: Uses expression ={{$json.message}} for the email body and sets the subject as 'Invoice Reminder'.