This workflow automates the process of monitoring overdue invoices, analyzing email interactions, generating personalized reminders, and sending follow-up emails automatically. It provides an efficient way to manage overdue payments by ensuring timely and context-aware communication.

The process begins with an initial manual trigger. It collects invoice data from a Google Sheet, focusing on invoices overdue by 7, 14, 21, or 28 days. The workflow calculates how many days have passed since each invoice was sent.

Next, it assesses if recent email communication with each client occurred within the last 72 hours using Gmail email history retrieval. If no recent interaction is found, an AI-powered analysis determines whether to send a follow-up based on conversation context and timing, choosing the appropriate email template with escalating urgency.

If the AI approves, the system drafts a personalized follow-up email using Gmail draft creation, tailoring the message to the specific overdue interval and client details. The process repeats for each overdue invoice, ensuring that clients receive timely, relevant reminders without feeling spammed.

This automation is highly useful for businesses aiming to streamline collections, reduce manual follow-up efforts, and maintain professional communication with clients.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.openAi, aggregate, filter, gmail, googleSheets, manualTrigger, scheduleTrigger, set, splitInBatches, stickyNote