{"product_id":"n8n-customer-support-automation-gmail-sheets-gemini","title":"n8n Customer Support Automation: Gmail, Sheets \u0026 Gemini","description":"\u003ch3\u003eTurn customer emails into automated, categorized support—instantly\u003c\/h3\u003e\n\u003cp\u003eThis n8n Customer Support Automation workflow receives customer messages via a webhook, classifies them with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, pulls order details from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e when needed, and sends replies or escalations through \u003cstrong\u003eGmail\u003c\/strong\u003e. It also uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to draft concise responses for general inquiries—so your support team spends less time triaging and more time resolving.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives support requests\u003c\/strong\u003e via a POST webhook (customer name, email, message, and source).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e into consistent fields for reliable processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the message with Google Gemini\u003c\/strong\u003e into one of: \u003cem\u003ecomplaint\u003c\/em\u003e, \u003cem\u003eorder_status\u003c\/em\u003e, \u003cem\u003egeneral_inquiry\u003c\/em\u003e, or \u003cem\u003espam\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates complaints\u003c\/strong\u003e by sending an escalation email via \u003cstrong\u003eGmail\u003c\/strong\u003e including customer details and the complaint text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles order status\u003c\/strong\u003e by extracting an order number, searching the Google Sheets \u003cstrong\u003e“Customer Orders”\u003c\/strong\u003e spreadsheet (matching columns like “Order Number”, “Status”, and “Tracking Number”), and emailing the customer with the found status—or an “order not found” message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResponds to general inquiries\u003c\/strong\u003e using \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to generate a concise support reply, then sends it back to the customer through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS support inbox triage: automatically route complaints, order questions, and general inquiries.\u003c\/li\u003e\n  \u003cli\u003eOrder tracking automation: reply with status and tracking details from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eReducing support turnaround time by drafting replies while keeping escalation paths for complaints.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e (POST) to receive customer messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e nodes for routing and parsing (including order number extraction).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e for classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 for order lookup using configurable spreadsheet ID\/tab and column names.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter\u003c\/strong\u003e for drafting concise responses to general inquiries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e with OAuth2 to send customer replies and complaint notifications.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46157943898291,"sku":"N8N-20332","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YHjZs2dJ7-RtecbfU7JqD_wzs87J04.png?v=1791019226","url":"https:\/\/buyflowscripts.com\/products\/n8n-customer-support-automation-gmail-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}