Build an Automated Unpaid Invoice Reminder in n8n

(Editor’s note: A version of this article was previously published on n8n.blog)

For early and growth stage startups, cash is oxygen. Every late payment puts extra strain on already tight budgets, distracts founders from growth, and forces teams to spend valuable hours chasing down invoices. Manual follow-ups are not only time-consuming, they’re inconsistent and prone to error.

That’s where automation comes in. With the right workflow, even lean finance or ops teams can ensure consistent, polite, and contextual reminders go out on time — protecting cash flow while freeing up resources to focus on customers and growth.

This blog walks you through a ready-to-use n8n workflow that combines Webhooks, vector embeddings, Weaviate, a RAG agent, Google Sheets, and Slack to create a smart and reliable unpaid invoice reminder system.

Key takeaways

Save time and resources: Automating invoice reminders eliminates repetitive manual follow-ups.
Improve cash flow: Consistent, timely nudges reduce late payments and speed up collections.
Personalize with context: Vector search and a RAG agent allow reminders to reference past communications or agreements.
Stay audit-ready: Logs in Google Sheets ensure every reminder is tracked and visible for reporting.
Scale without overhead: Lean finance teams can handle more clients and invoices without adding headcount.

Automating overdue invoice reminders saves time, reduces late payments, and keeps cash flow healthy. This guide walks you through a ready-to-use n8n workflow — using Webhooks, text splitting, vector embeddings, Weaviate, a RAG (retrieval-augmented generation) agent, Google Sheets, and Slack — to create a smart, reliable unpaid invoice reminder system.

Why automate invoice reminders?

Manual follow-ups are time-consuming and inconsistent. An automated unpaid invoice reminder system ensures timely, polite, and contextual messages to clients while capturing activity in your accounting log. By combining n8n with vector search and a language model, you can personalize reminders using invoice history and stored context.

Overview of the workflow

This n8n template includes the following components (as shown in the provided diagram):

Webhook Trigger — receives incoming invoice data or a scheduled event (POST /unpaid-invoice-reminder).
Text Splitter — splits long invoice notes or client communications into chunks for embedding.
Embeddings (Cohere) — converts text chunks into vector embeddings for semantic search.
Weaviate Insert & Query — stores invoice/context vectors and retrieves related context when needed.
Vector Tool — surfaces relevant documents for the RAG agent.
Window Memory — short-term memory to maintain context across processing steps.
Chat Model (OpenAI) — the LLM used by the RAG agent to generate reminder copy.
RAG Agent — orchestrates retrieval from Weaviate, memory, and the language model to create a contextual reminder.
Append Sheet (Google Sheets) — appends a log entry to your accounting sheet with the reminder status.
Slack Alert — on errors, notifies your #alerts channel.

How the parts work together

When the Webhook Trigger receives data (for example, invoice ID, client name, due date, balance, and notes), the Text Splitter breaks any long text fields into manageable chunks. These chunks are embedded via Cohere and inserted into Weaviate so you can perform semantic searches over invoice histories and client communications.

When generating a reminder, the workflow queries Weaviate for related context (past emails, payment agreements, notes). The Vector Tool formats that context for the RAG Agent. Window Memory supplies recent interaction context. The RAG Agent then sends the combined context and a system instruction to the Chat Model (OpenAI), which returns a polished reminder message.

Finally, the workflow appends the reminder status to a Google Sheet (for reporting) and — if anything goes wrong — sends a Slack Alert so your team can take corrective action.

Step-by-step setup

1. Create the Webhook

In n8n, add a Webhook node configured to POST at /unpaid-invoice-reminder. This is the entry point for your invoicing system or scheduled job to notify n8n of unpaid invoices.

2. Split and embed text

Use the Text Splitter node to break long notes or email history into chunks (for example, chunkSize: 400, chunkOverlap: 40). Connect a Cohere Embeddings node (model: embed-english-v3.0) to generate vector representations for each chunk.

3. Store vectors in Weaviate

Connect the embeddings output to a Weaviate Insert node to persist the text chunks, embeddings, and metadata (invoice ID, date, client ID). This enables quick semantic retrieval later.

4. Query for context

When composing a reminder, the workflow queries Weaviate with the invoice text or client details. The Weaviate Query node returns the most relevant documents. Use a Vector Tool node to shape these results into the format your RAG Agent expects.

5. Use short-term memory and an LLM

Window Memory provides conversational or session context to the RAG Agent. The Chat Model (OpenAI) is wired as the language model the agent uses to synthesize a human-friendly reminder.

6. RAG Agent orchestration

The RAG Agent receives the retrieved documents, memory, and system instructions (for example: “You are an assistant for Unpaid Invoice Reminder; produce a short, polite reminder including invoice number, amount due, due date, and call-to-action to pay.”). It returns the final reminder text.

7. Log and notify

Use a Google Sheets Append node to record the reminder status in a “Log” sheet (schema: Status and any additional columns you need). Configure an onError path from the agent to a Slack node so your team receives immediate alerts for failures.

Templates for system and user prompts

Use a clear system message for consistent tone and formatting. Example:

System: You are an assistant that writes unpaid invoice reminders. Keep tone polite and professional. Include invoice number, amount due, due date, and payment link. If there are previous payment promises or notes, acknowledge them briefly.

Example user prompt passed to the RAG Agent (with inserted context):

User: Compose a reminder for Invoice #12345 for Acme Co., amount $2,350, due 2025-10-10. Relevant notes: [retrieved documents].

Best practices and security

Protect API keys (Cohere, Weaviate, OpenAI, Google Sheets, Slack) with n8n credentials and environment variables.
Limit the scope of webhook endpoints (use authorization tokens or IP restrictions).
Validate and sanitize incoming data to avoid injection of malicious content into logs or prompts.
Monitor costs: embeddings and LLM queries incur usage fees — batch operations where possible.
Version your Weaviate schema and backups for vector data to prevent accidental loss.

Testing and troubleshooting

Test incrementally: start with the Webhook and log payloads, then add text splitting and embeddings, and finally enable the RAG Agent. Use n8n’s execution logs to inspect node outputs. If the RAG agent generates unexpected text, examine the retrieved context to ensure the query returns relevant documents and adjust your prompt instructions.

Use cases and extensions

Follow-up sequences: send a soft reminder, then a firmer message after X days, and finally escalate to collections.
Multichannel delivery: integrate email or SMS nodes to send reminders directly.
Personalization: include client name, past payment behavior, or specific payment terms to increase responsiveness.
Analytics: use the Sheets log and add a dashboard to track response rates and days-to-pay.

Conclusion

For early and growth stage startups, every dollar counts and every hour saved matters. An automated unpaid invoice reminder system not only strengthens cash flow but also ensures your client interactions remain professional and consistent. By combining n8n, vector search, and a RAG agent, you can turn what used to be a painful, manual process into a scalable and intelligent workflow.

Think of it as an investment in financial discipline: your team spends less time chasing payments and more time building product, acquiring customers, and growing your business.

Start small, test with a handful of invoices, and then expand the automation across your client base. The earlier you embed this type of operational rigor, the easier it becomes to scale without breaking your back-office processes.

By combining n8n with embeddings, Weaviate vector search, and a RAG agent, you build an intelligent unpaid invoice reminder system that’s contextual, auditable, and scalable. This workflow reduces manual follow-ups and improves your accounts receivable process.