{"product_id":"automated-overdue-invoice-email-reminders-n8n-gmail-google-sheets","title":"Automated Overdue Invoice Email Reminders (n8n, Gmail, Google Sheets)","description":"\u003ch3\u003eAutomated Overdue Invoice Email Reminders from Google Sheets (n8n + Gmail)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e invoices every morning, identifies which payments are overdue, generates the correct reminder message (first, second, or final), and sends it to your clients via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every day at \u003cstrong\u003e9:00\u003c\/strong\u003e using an n8n \u003cem\u003eSchedule Trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads settings:\u003c\/strong\u003e Pulls configuration such as your Google Sheet ID, business details, date format, and \u003cstrong\u003ereminder day thresholds\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice data:\u003c\/strong\u003e Loads all rows from the \u003cstrong\u003e“Invoices”\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetermines overdue reminders:\u003c\/strong\u003e Parses \u003cstrong\u003eDue Date\u003c\/strong\u003e, checks exact \u003cstrong\u003edays overdue\u003c\/strong\u003e, assigns invoices to a first\/second\/final reminder stage based on status and thresholds, and \u003cstrong\u003eskips rows with missing\/invalid email, amount, or due date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates email content:\u003c\/strong\u003e Creates a plain-text subject and body from a fixed template using invoice details and the reminder stage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail:\u003c\/strong\u003e Emails the reminder to the client using the \u003cem\u003egmail\u003c\/em\u003e node.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who track billing in Google Sheets and want automatic overdue reminders without manual outreach.\u003c\/li\u003e\n  \u003cli\u003eFreelancers and small businesses needing staged payment follow-ups (first\/second\/final) sent automatically.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up a reliable \u003cstrong\u003eaccounts receivable\u003c\/strong\u003e reminder process with n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tech stack:\u003c\/strong\u003e set, code, gmail, google sheets, schedule trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e Reads the \u003cstrong\u003eInvoices\u003c\/strong\u003e tab with columns for Invoice Number, Client Name, Client Email, Status, Amount, and Due Date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail integration:\u003c\/strong\u003e Uses Gmail to send the reminder emails to client addresses.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect Google Sheets and set the sheet ID in the \u003cstrong\u003eSettings\u003c\/strong\u003e step.\u003c\/li\u003e\n  \u003cli\u003eConnect Gmail and ensure the workflow is allowed to send mail.\u003c\/li\u003e\n  \u003cli\u003eUpdate Settings values (businessName, senderName, currencySymbol, dateFormat, and reminder day thresholds) to match your locale and billing rules.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008796741811,"sku":"N8N-19484","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/R1Yie8arxtrsjBxZ-rs1i_Di3qNF93.png?v=1789204540","url":"https:\/\/buyflowscripts.com\/products\/automated-overdue-invoice-email-reminders-n8n-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}