{"product_id":"gmail-repair-quote-triage-with-openai-google-sheets-n8n","title":"Gmail Repair Quote Triage with OpenAI + Google Sheets (n8n)","description":"\u003ch3\u003eStop Guessing, Start Quoting: Gmail Repair Quote Triage with OpenAI + Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eWhen your shop inbox fills with repair and estimate requests—and half are missing the one detail you need—this n8n workflow automatically triages the emails, logs every request to Google Sheets, replies for missing information, and emails you a morning summary of what’s still waiting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on unread Gmail messages\u003c\/strong\u003e matching your quote\/estimate\/repair\/service subject query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks messages as read\u003c\/strong\u003e (via \u003cem\u003eMark Email Read\u003c\/em\u003e) and normalizes the content (sender, subject, body) using \u003cem\u003eNormalize Email\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI (GPT-6.1-sol)\u003c\/strong\u003e through the \u003cem\u003eClassify Quote Request\u003c\/em\u003e agent to determine whether the message is a real repair\/quote request and extract key fields: \u003cstrong\u003eyear, make, model, customer concern\u003c\/strong\u003e, and whether enough information exists to price.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes outcomes\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSkip Non Request\u003c\/strong\u003e drops non-request messages.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eReply lane\u003c\/strong\u003e handles requests without sufficient detail.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLogging lane\u003c\/strong\u003e handles fully detailed requests.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLog Awaiting Info\u003c\/strong\u003e appends thin requests to the \u003cstrong\u003e“Quotes”\u003c\/strong\u003e tab.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSend Missing Info Reply\u003c\/strong\u003e emails the customer a short, targeted ask for only the missing fields.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLog Ready Quote\u003c\/strong\u003e appends complete requests as ready.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eNotify Shop Owner\u003c\/strong\u003e emails you a summary of what’s ready.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMorning follow-ups\u003c\/strong\u003e: a dedicated lane reads the \u003cstrong\u003e“Quotes”\u003c\/strong\u003e log, finds requests open for about a day, and sends the owner an \u003cstrong\u003eOpen Quotes Summary\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eYour shop receives quote requests for repairs but routinely lacks model year or vehicle details.\u003c\/li\u003e\n  \u003cli\u003eYou want automatic customer follow-up emails instead of manual inbox checks.\u003c\/li\u003e\n  \u003cli\u003eYou need an always-current Google Sheets “Quotes” pipeline and daily status visibility.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes used:\u003c\/strong\u003e code, no op, \u003cstrong\u003eGmail\u003c\/strong\u003e trigger, switch, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI via Shop Model chat model (GPT-6.1-sol) for classification + extraction\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData logging:\u003c\/strong\u003e Google Sheets (writes to the \u003cstrong\u003e“Quotes”\u003c\/strong\u003e tab)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eLast updated: October 2026.\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326519988403,"sku":"N8N-21835","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/px5LUdQrYrGKMvVTjlRut_cAXR8jaP.png?v=1793351205","url":"https:\/\/buyflowscripts.com\/products\/gmail-repair-quote-triage-with-openai-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}