Automated AI-Powered Spare Parts Quote Generator
detail.loadingPreview
This n8n workflow revolutionizes spare parts sales by automating the entire quoting process. It monitors Gmail for requests, intelligently generates multi-language HTML quotes using AI, and automatically replies to customers with pricing information, drastically improving response times and operational efficiency.
About This Workflow
Tired of manually creating quotes for spare parts? This powerful n8n workflow streamlines your sales and customer service operations. It intelligently monitors your Gmail inbox for incoming spare parts requests, leveraging keyword detection to identify relevant emails across multiple languages. Once a request is detected, Google Gemini AI dynamically generates a professional, multi-language HTML price quote based on your pre-configured Google Sheets data (CRM, Bill of Materials, Pricing). The workflow then automatically sends this detailed quote as a reply and marks the original email as read, ensuring a seamless, efficient, and professional customer experience while freeing up valuable team resources.
Key Features
- Intelligent Email Monitoring: Automatically scans Gmail for spare parts requests using customizable multi-language keyword detection (Turkish, German, English).
- AI-Powered Quote Generation: Utilizes Google Gemini to dynamically create professional HTML price quotes, adapting to the sender's language for a personalized touch.
- Integrated Data Management: Seamlessly pulls customer, bill of materials (BoM), and pricing data from your Google Sheets.
- Automated Customer Response: Delivers instant, accurate quotes via email replies, significantly reducing response times.
- Efficient Inbox Management: Automatically marks processed emails as read, keeping your inbox organized and ensuring no request is overlooked.
How To Use
- Set up Gmail OAuth2 Credentials:
- Go to Google Cloud Console.
- Create new OAuth2 credentials for a web application.
- Add
https://www.googleapis.com/auth/gmail.readonlyandhttps://www.googleapis.com/auth/gmail.sendscopes. - Configure these credentials within n8n.
- Set up Google Sheets OAuth2 Credentials:
- Use the same Google Cloud project.
- Add
https://www.googleapis.com/auth/spreadsheets.readonlyandhttps://www.googleapis.com/auth/spreadsheetsscopes. - Configure these credentials within n8n.
- Configure Google Gemini API:
- Obtain an API key from Google AI Studio.
- Set up a new Google Gemini API credential in n8n using your API key.
- Prepare Google Sheets:
- Create three separate Google Sheets with the specified columns:
- CRM Data:
Email,ProjectCode,CustomerName, and any other relevant customer info. - Bill of Materials (BoM):
ProjectCode,PartCode,PartDescription,Quantity. - Pricing Data:
PartCode,UnitPriceEUR,PartDescription.
- CRM Data:
- Create three separate Google Sheets with the specified columns:
- Update Sheet IDs in n8n:
- Locate the nodes associated with CRM, BoM, and Pricing data within the workflow.
- Replace the placeholder Sheet IDs (e.g.,
YOUR_CRM_SHEET_ID_HERE) with the actual IDs from your Google Sheet URLs (e.g.,docs.google.com/spreadsheets/d/[SHEET_ID]/edit).
- Customize Keywords (Optional):
- Adjust the "Check Spare Parts Keywords" node to include any additional keywords relevant to your business in various languages.
- Activate the Workflow: Once all configurations are complete, activate the workflow in n8n. It will now automatically monitor your Gmail and generate quotes.
Apps Used
Workflow JSON
{
"id": "e25f22db-4702-4dd6-87c7-1ec77a150a78",
"name": "Automated AI-Powered Spare Parts Quote Generator",
"nodes": 29,
"category": "Sales",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: e25f22db-4702...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered Stack Overflow Lead Generation
Unleash the power of AI to automatically scrape valuable lead data from Stack Overflow user profiles. This workflow intelligently identifies and extracts key information like names, locations, skills, and reputation, then seamlessly organizes it into your Google Sheet for effortless lead management.
Typeform to HubSpot Lead Qualification & Gmail Follow-up
Streamline your lead capture process by automatically syncing Typeform submissions to HubSpot. Qualify leads based on their interest and send personalized follow-up emails instantly. This workflow ensures no lead is missed and interested prospects receive immediate attention.
AI-Powered Upwork Proposal Automation Suite
This n8n workflow leverages AI to automate the entire freelance proposal process, from crafting personalized application text to generating professional Google Doc proposals and visual workflow diagrams. It significantly reduces manual effort, allowing freelancers to scale their client acquisition rapidly and effectively.