{"product_id":"automated-invoice-follow-ups-google-sheets-gmail-reminders-n8n","title":"Automated Invoice Follow-Ups: Google Sheets + Gmail Reminders (n8n)","description":"\u003ch3\u003eAutomatically chase unpaid invoices—every morning—with Google Sheets + Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your invoice tracker in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and automatically sends \u003cstrong\u003eescalating Gmail reminder emails\u003c\/strong\u003e to clients based on how many days an invoice is overdue—then logs every reminder back to your sheet and alerts you when a \u003cstrong\u003etier-3 final notice\u003c\/strong\u003e is sent.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9:00\u003c\/strong\u003e using a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from the \u003ccode\u003eInvoices\u003c\/code\u003e tab in your Google Sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIdentifies unpaid invoices\u003c\/strong\u003e that are at least \u003cstrong\u003e3 days overdue\u003c\/strong\u003e and have \u003cstrong\u003enot been emailed in the last 7 days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssigns an escalation tier\u003c\/strong\u003e (tier \u003cstrong\u003e1, 2, or 3\u003c\/strong\u003e) based on overdue timing, and generates an email subject and body.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the reminder\u003c\/strong\u003e to the client using the \u003cstrong\u003eGmail\u003c\/strong\u003e node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the same Google Sheets row\u003c\/strong\u003e with:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003ccode\u003eRemindersSent\u003c\/code\u003e (incremented\/count updated)\u003c\/li\u003e\n      \u003cli\u003e\u003ccode\u003eLastReminderDate\u003c\/code\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf the reminder is a \u003cstrong\u003etier-3 final notice\u003c\/strong\u003e, it also sends an \u003cstrong\u003eadditional escalation alert\u003c\/strong\u003e to your own email via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who want consistent \u003cstrong\u003einvoice follow-ups\u003c\/strong\u003e without manually checking overdue payments.\u003c\/li\u003e\n  \u003cli\u003eFreelancers and agencies using Google Sheets to track billing and letting n8n handle polite-to-final escalation.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable \u003cstrong\u003einvoice reminder workflow\u003c\/strong\u003e for recurring use.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads \u003ccode\u003eInvoices\u003c\/code\u003e tab and updates \u003ccode\u003eStatus\u003c\/code\u003e, \u003ccode\u003eDueDate\u003c\/code\u003e-related filters, \u003ccode\u003eClientEmail\u003c\/code\u003e, \u003ccode\u003eLastReminderDate\u003c\/code\u003e, and \u003ccode\u003eRemindersSent\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends client reminders and the tier-3 internal escalation alert.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs every day at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e + \u003cstrong\u003ecode\u003c\/strong\u003e: applies the overdue\/7-day cooldown logic and builds tiered email content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e: workflow documentation within n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup requires\u003c\/strong\u003e a Google account with access to your Google Sheet and Google\/Gmail credentials in n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45767897743539,"sku":"N8N-17878","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SE2qJZxNAPcnTkJ0psWm1_39o783Ad.png?v=1786093591","url":"https:\/\/buyflowscripts.com\/products\/automated-invoice-follow-ups-google-sheets-gmail-reminders-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}