Automated Invoice Follow-ups with Smart Response Tones via Google Sheets & Email β n8n Workflow
Overview
π How It Works This AI Agent checks your invoice database (Google Sheets) daily and looks for unpaid invoices that are past their due date. It calculates how many days each invoice is overdue (Days Past Due / DPD), then automatically crafts a follow-up message with an appropriate tone:
1β7 days overdue: Friendly reminder 8β14 days overdue: Slightly firm nudge 15+ days overdue: Final warning tone
After generating the message, it sends the follow-up via email to the client and logs the interact
Nodes used
Workflow Preview
How it Works
- 1
Trigger
The workflow starts with a scheduled trigger, running on a defined schedule.
- 2
Process
Data flows through 6 nodes, connecting cron, emailsend, function.
- 3
Output
The workflow completes its automation and delivers the result to the configured destination.
Node Details (6)
Send Email
emailSend
Google Sheets
googleSheets
How to Import This Workflow
- 1Click Download JSON button on the right to save the workflow file.
- 2Open your n8n instance. Go to Workflows β New β Import from file.
- 3Select the downloaded
automated-invoice-follow-ups-with-smart-response-tones-via-google-sheets-emailfile and click Import. - 4Set up credentials for each service node (API keys, OAuth, etc.).
- 5Click Test Workflow to verify everything works, then activate it.
Or paste directly in n8n β Import from JSON:
Integrations
Created by
Marth - Business Automation
@marth
Tags
New to n8n?
n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.
Get n8n Free β