{"product_id":"auto-repair-reminder-n8n-workflow-sheets-gemini-gmail","title":"Auto Repair Reminder n8n Workflow: Sheets + Gemini + Gmail","description":"\u003ch3\u003eAuto Repair Reminder n8n Workflow: Sheets + Gemini + Gmail (with logging back to Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eAutomate next-step auto repair service reminders: this n8n workflow runs every morning, pulls due customers from Google Sheets, uses Google Gemini to draft plain-text reminder emails, sends via Gmail (or a test copy), and logs each reminder back to the sheet.\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 AM\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your customer data\u003c\/strong\u003e from the \u003cem\u003eCustomers\u003c\/em\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates the next service due date\u003c\/strong\u003e from \u003cem\u003elast_service_date\u003c\/em\u003e and \u003cem\u003eservice_interval_days\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters which customers to contact\u003c\/strong\u003e based on a configured reminder window, skipping \u003cem\u003eopt_out\u003c\/em\u003e, invalid emails, customers already reminded for the same due date, and enforcing a \u003cstrong\u003edaily send cap\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates personalized reminders\u003c\/strong\u003e using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, producing a short plain-text email per customer; if generation fails, it falls back to a default message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends emails through Gmail\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cem\u003eLive mode enabled:\u003c\/em\u003e send to the customer email.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cem\u003eLive mode disabled:\u003c\/em\u003e send a \u003cstrong\u003etest copy\u003c\/strong\u003e to the shop owner email.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the Google Sheets row\u003c\/strong\u003e with \u003cem\u003ereminder_sent_at\u003c\/em\u003e and the due date that was reminded, then \u003cstrong\u003ewaits 7 seconds\u003c\/strong\u003e before the next customer.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep maintenance reminders consistent for an auto repair shop without manual outreach.\u003c\/li\u003e\n  \u003cli\u003eSend due-date follow-ups based on customer history (last service + interval).\u003c\/li\u003e\n  \u003cli\u003eSafely test messaging in Gmail before enabling live sends.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n integrations:\u003c\/strong\u003e Google Sheets, Gmail, Google Gemini\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e schedule trigger, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotes:\u003c\/strong\u003e uses a \u003cem\u003eSticky Note\u003c\/em\u003e for operator guidance\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146402779315,"sku":"N8N-20225","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yV-ZjeuzXN32U6-Slto7r_NhNQlcTz.png?v=1790846649","url":"https:\/\/buyflowscripts.com\/products\/auto-repair-reminder-n8n-workflow-sheets-gemini-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}