Generate & Send Spare Parts Price Quotes with Gmail, Sheets & Gemini AI

This n8n workflow revolutionizes spare parts sales automation by monitoring your Gmail inbox for incoming inquiries. It uses Gemini AI to detect the email's language (e.g., Turkish, English, German), extract project or part codes, query three Google Sheets (CRM, Bill of Materials, Pricing), calculate line items and totals, and generate professional, branded HTML price quotes tailored to the sender's language.

The process starts with a Schedule Trigger checking for new unread emails every few minutes. Gmail fetches the latest messages, keyword detection filters for spare parts-related terms across languages, and the AI Agent handles complex processing including data lookups and computations. Finally, it sends a personalized reply with the quote and marks the original email as read, ensuring efficient follow-up without manual intervention.

Ideal for sales teams and customer service in businesses with complex pricing, it saves hours on quote generation, reduces errors, supports multilingual communication, and scales for high-volume inquiries. Benefits include faster response times, consistent branding, accurate pricing, and seamless integration of email, spreadsheets, and AI for end-to-end automation.

Requirements: n8n instance, Gmail OAuth2, structured Google Sheets. Perfect for manufacturing, automotive, or any spare parts operation.