Automated Invoice Payment Reminders with Google Sheets & Gmail

This workflow automates invoice payment reminders by running daily via a schedule trigger. It reads invoice data from Google Sheets, including columns like InvoiceID, ClientName, ClientEmail, Amount, DueDate, and Status. A function node filters for invoices due within 3 days or overdue up to 7 days, skipping paid ones, and prepares custom email subjects and bodies.

An IF node checks if any reminders are needed; if yes, it proceeds to send personalized emails via Gmail for each qualifying invoice. This prevents oversight, improves cash flow, and saves hours of manual tracking.

Ideal for freelancers, small businesses, or any operation using Google Sheets for invoicing. Benefits include reduced late payments, professional client communication, and scalability. Customize dates, thresholds, and email templates easily in n8n.