{"product_id":"gmail-spare-parts-quote-automation-with-n8n-sheets-gemini-ai","title":"Gmail Spare Parts Quote Automation with n8n, Sheets \u0026 Gemini AI","description":"\u003ch3\u003eAutomate spare parts quotes from Gmail—automatically, accurately, and in the customer’s language\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail Spare Parts Quote Automation with n8n, Sheets \u0026amp; Gemini AI\u003c\/strong\u003e workflow monitors your inbox for spare parts requests, extracts the relevant part\/project codes, pulls pricing from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates totals, and sends back a \u003cstrong\u003eprofessional HTML quote\u003c\/strong\u003e—all while using AI to detect the email’s language and respond accordingly.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors your Gmail inbox\u003c\/strong\u003e for incoming spare parts inquiries by checking for new\/unread emails on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters messages by keywords\u003c\/strong\u003e related to spare parts requests across multiple languages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses an AI Agent to handle the request\u003c\/strong\u003e by:\n    \u003cul\u003e\n      \u003cli\u003eDetecting the sender email’s language (supports \u003cstrong\u003eTurkish\u003c\/strong\u003e, \u003cstrong\u003eEnglish\u003c\/strong\u003e, \u003cstrong\u003eGerman\u003c\/strong\u003e, and more).\u003c\/li\u003e\n      \u003cli\u003eExtracting \u003cstrong\u003eproject or part codes\u003c\/strong\u003e from the email.\u003c\/li\u003e\n      \u003cli\u003eQuerying \u003cstrong\u003ethree Google Sheets\u003c\/strong\u003e (CRM, Bill of Materials, Pricing) to find the correct items and rates.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCalculating line totals and the grand total\u003c\/strong\u003e accurately.\u003c\/li\u003e\n      \u003cli\u003eGenerating a clean \u003cstrong\u003eprofessional HTML quote\u003c\/strong\u003e formatted to match your brand style.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends personalized replies\u003c\/strong\u003e directly to the email sender.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSales teams responding to frequent spare parts email requests with complex pricing structures.\u003c\/li\u003e\n  \u003cli\u003eCustomer service departments needing fast, consistent quotation turnaround.\u003c\/li\u003e\n  \u003cli\u003eBusinesses managing multiple products where quotes must be calculated from structured spreadsheet data.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n workflow)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e to run periodically and check for new emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail node\u003c\/strong\u003e to fetch the latest unread email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeyword detection\u003c\/strong\u003e using \u003cstrong\u003eif\u003c\/strong\u003e logic to identify spare parts-related messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8nn8n-nodes-langchainagent (AI Agent)\u003c\/strong\u003e powered by \u003cstrong\u003eGemini AI\u003c\/strong\u003e for language detection, code extraction, and quote generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets tools\u003c\/strong\u003e to read from CRM, Bill of Materials, and Pricing and compute totals.\u003c\/li\u003e\n  \u003cli\u003eQuote output formatted as \u003cstrong\u003eHTML\u003c\/strong\u003e and sent as a personalized email reply.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764340809907,"sku":"N8N-5492","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9htd-nTMWsNb_nSXwqxMJ_gHkaafe1.png?v=1786007877","url":"https:\/\/buyflowscripts.com\/products\/gmail-spare-parts-quote-automation-with-n8n-sheets-gemini-ai","provider":"N8N Commerce","version":"1.0","type":"link"}