{"product_id":"n8n-invoice-follow-up-automation-gmail-google-sheets","title":"n8n Invoice Follow-Up Automation: Gmail + Google Sheets","description":"\u003ch3\u003eNever miss an invoice follow-up—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation scans your \u003cstrong\u003eunpaid invoices in Google Sheets\u003c\/strong\u003e, sends \u003cstrong\u003eGmail reminders\u003c\/strong\u003e for due-soon and overdue items, logs every follow-up, escalates high-risk cases to your finance owner, and emails a \u003cstrong\u003eweekly payment digest\u003c\/strong\u003e to keep receivables under control.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily (9am) invoice follow-ups:\u003c\/strong\u003e The workflow runs every day at \u003cstrong\u003e9am\u003c\/strong\u003e and reads invoices marked \u003cstrong\u003eUnpaid\u003c\/strong\u003e from the Google Sheets \u003cstrong\u003eInvoices\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStage-aware reminders:\u003c\/strong\u003e It calculates days until due\/overdue, determines the correct reminder stage (due-soon vs overdue) and whether escalation is needed, then prepares the \u003cstrong\u003eemail subject and body\u003c\/strong\u003e for each actionable invoice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend via Gmail:\u003c\/strong\u003e For invoices that require follow-up, it emails the client using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog reminders in Sheets:\u003c\/strong\u003e Every sent reminder is appended to the \u003cstrong\u003eReminder Log\u003c\/strong\u003e tab, including overdue days, stage, email subject, and recommended action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalate high-risk invoices:\u003c\/strong\u003e For invoices flagged for escalation (e.g., \u003cem\u003efinal notice\u003c\/em\u003e or high-value overdue), the workflow appends an entry to the \u003cstrong\u003eEscalation Log\u003c\/strong\u003e tab and emails the \u003cstrong\u003efinance owner\u003c\/strong\u003e with invoice details and the reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly (Monday 9am) digest:\u003c\/strong\u003e Every Monday at \u003cstrong\u003e9am\u003c\/strong\u003e, it reads unpaid invoices again, generates a receivables summary (due soon, overdue, high-risk), and emails the digest to the finance owner via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFreelancers who want reliable, automated reminders without manually tracking due dates.\u003c\/li\u003e\n  \u003cli\u003eAgencies managing multiple clients and needing consistent escalation for overdue invoices.\u003c\/li\u003e\n  \u003cli\u003eSmall finance teams that want weekly visibility into receivables and overdue risk.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e Schedule-based runs (daily and weekly), conditional routing for escalation, and email composition per invoice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Google Sheets tabs:\u003c\/strong\u003e \u003cstrong\u003eInvoices\u003c\/strong\u003e, \u003cstrong\u003eReminder Log\u003c\/strong\u003e, and \u003cstrong\u003eEscalation Log\u003c\/strong\u003e (with expected columns such as Invoice ID, Client Email, Amount, Currency, Due Date, Status, and Last Reminder Date).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916246016179,"sku":"N8N-18797","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wbLgoc3dIQh7_7LR5fqtw_b9TRo4EJ.png?v=1788013539","url":"https:\/\/buyflowscripts.com\/products\/n8n-invoice-follow-up-automation-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}