{"product_id":"n8n-google-sheets-maintenance-reminders-via-gmail","title":"n8n Google Sheets Maintenance Reminders via Gmail","description":"\u003ch3\u003eAuto-send Google Sheets maintenance reminders every Monday—based on real service history\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your Google Sheets “Equipment” list every Monday, determines which customers are due (or recently overdue) for maintenance, and sends personalized HTML reminder emails via Gmail with your booking link. It also writes the next due date and reminder timestamp back to the sheet so your outreach stays accurate.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule:\u003c\/b\u003e Executes every Monday at \u003cb\u003e9am\u003c\/b\u003e (using the timezone configured in the workflow).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads maintenance data from Google Sheets:\u003c\/b\u003e Loads all rows from the \u003cb\u003eEquipment\u003c\/b\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates next due dates:\u003c\/b\u003e Uses \u003cb\u003eLast Service Date\u003c\/b\u003e and \u003cb\u003eService Interval (months)\u003c\/b\u003e to compute each item’s \u003cb\u003eNext Service Due\u003c\/b\u003e, applying defaults like reminder window and overdue limits (as configured).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSelects the right recipients:\u003c\/b\u003e Filters to \u003cb\u003eactive equipment\u003c\/b\u003e with a valid \u003cb\u003eCustomer Email\u003c\/b\u003e, and targets items due within the reminder window (or recently overdue) while avoiding duplicates for the same service cycle.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends reminder emails via Gmail:\u003c\/b\u003e Sends a personalized HTML email (including your \u003cb\u003ebooking link\u003c\/b\u003e and contact details) through the \u003cb\u003eGmail\u003c\/b\u003e integration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates Google Sheets for tracking:\u003c\/b\u003e Writes back \u003cb\u003eNext Service Due\u003c\/b\u003e and the \u003cb\u003eReminder Sent At\u003c\/b\u003e timestamp to the same row.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators or maintenance teams who manage equipment service intervals in Google Sheets and need automated customer follow-ups.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up reliable n8n reminders to reduce manual scheduling and prevent repeat outreach.\u003c\/li\u003e\n  \u003cli\u003eBusinesses that want due-date logic (including overdue handling and reminder limits) fully tracked in the spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n Schedule Trigger\u003c\/b\u003e (every Monday at 9am)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e node to read and update the \u003cb\u003eEquipment\u003c\/b\u003e tab\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCode\u003c\/b\u003e + configuration for due-date calculation and reminder window logic\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e node to send HTML maintenance reminder emails\u003c\/li\u003e\n  \u003cli\u003eNodes used in the workflow include: \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003esticky note\u003c\/b\u003e, \u003cb\u003egoogle sheets\u003c\/b\u003e, \u003cb\u003eschedule trigger\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eTo set it up, connect your Google Sheets credentials (for the target spreadsheet) and Gmail credentials (for the sending mailbox), then ensure the \u003cb\u003eEquipment\u003c\/b\u003e tab contains the expected headers like Equipment ID, Customer Name, Customer Email, Last Service Date, Service Interval (months), Status, Next Service Due, and Reminder.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172950364339,"sku":"N8N-20569","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1IK5E_Mt6hfpmouzSq2bN_JSIcqJWZ.png?v=1791364796","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-maintenance-reminders-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}