AutomationMart
Home/Browse/Generate & send spare parts price quotes with Gmail, Sheets and Gemini AI
n8n

Generate & send spare parts price quotes with Gmail, Sheets and Gemini AI

n8nn8n11 modulesv1.0
agentgmailgoogleSheetsTooliflmChatGoogleGeminischeduleTriggertoolCalculator

Who's it for This workflow is perfect for sales teams, customer service departments, and businesses that frequently handle spare parts inquiries via email. It's especially valuable for companies managing multiple products with complex pricing structures who want to automate their quotation process while maintaining professional, multilingual communication. --- What it does This workflow: - Monitors your Gmail inbox for incoming spare parts requests - Automatically generates professional HTML pr

At a glance

Generate & send spare parts price quotes with Gmail, Sheets and Gemini AI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, gmail, googleSheetsTool, if. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
agent, gmail, googleSheetsTool, if, lmChatGoogleGemini, scheduleTrigger
Modules
11
Price
Free
Version
v1.0
Generate & send spare parts price quotes with Gmail, Sheets and Gemini AI workflow diagram

About this workflow

Who's it for This workflow is perfect for sales teams, customer service departments, and businesses that frequently handle spare parts inquiries via email. It's especially valuable for companies managing multiple products with complex pricing structures who want to automate their quotation process while maintaining professional, multilingual communication. --- What it does This workflow: - Monitors your Gmail inbox for incoming spare parts requests - Automatically generates professional HTML price quotes in the sender's language - Sends personalized replies - Uses AI to detect the email language (supports Turkish, English, German, and more) - Extracts project or part codes - Fetches pricing data from Google Sheets - Calculates totals accurately - Formats everything into a clean, professional quote that matches your brand --- How it works 1. Schedule Trigger runs every minutes to check for new emails 2. Gmail node fetches the latest unread email 3. Keyword detection filters for spare parts-related terms in multiple languages 4. AI Agent processes the request by: - Detecting the email's language - Extracting project/part codes - Querying three Google Sheets: CRM, Bill of Materials, Pricing - Calculating line totals and grand total - Generating a professional HTML quote in the sender's language 5. Gmail reply sends the quote and marks the original email as read --- Requirements - n8n self-hosted or cloud instance - Gmail account with OAuth2 authentication - Google Sheets with proper structure (3 sheets for CRM, BoM, and Pricing data) - Google Gemini API key for AI processing - Basic understanding of Google Cloud Console for OAuth setup --- How to set up 1. Import the workflow into your n8n instance 2. Create three Google Sheets with the following column structure: - CRM Sheet: Email, ProjectCode, CustomerName - Bill of Materials: ProjectCode, PartCode, PartDescription, Quantity - Pricing Sheet: PartCode, UnitPriceEUR, PartDescription 3. Configure credentials: - Set up Gmail OAuth2 in Google Cloud Console - Configure Google Sheets OAuth2 (can use same project) - Get your Google Gemini API key from Google AI Studio 4. Update the workflow: - Replace placeholder Sheet IDs in the CRM, BoM, and Pricing nodes - Adjust company name in the AI Agent’s system message - Modify keyword detection if needed 5. Test with a sample email before activating --- How to customize the workflow - Add more languages: Update the keyword detection node with additional terms - Modify the quote template: Edit the HTML in the AI Agent's message to match your branding - Change data sources: Replace Google Sheets with PostgreSQL or MySQL nodes - Add approval steps: Insert a manual approval node for quotes above a certain value - Include attachments: Add PDF or product spec file nodes - Enhance notifications: Add Slack or Teams notifications after quote is sent - Implement follow-ups: Create a separate workflow for reminder emails --- This template provides a solid foundation for automating your quotation process, while staying flexible to fit your specific business needs. Feel free to contact me for further implementation guidelines: LinkedIn: Berke

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

AI-powered HR screening automation via Jotform

Who's it for - HR professionals and recruitment teams handling high application volumes - Startup founders and hiring managers seeking to scale hiring efficiently - Companies wanting consistent, objective candidate evaluation - Teams spending 20+ hours per week on manual resume screening What it does - Receives job applications automatically via Jotform webhook - Downloads and parses resume PDFs using LlamaParse AI extraction - Analyzes candidate qualifications with OpenAI GPT-4 (compatibility s

Free

Track Forex Factory news releases with MyFxBook, Telegram & Google Sheets

Get Forex Factory News Release to Telegram, Google Sheets. Record News Data and Live Price from MyFxBook for Affected Currency Pairs. This n8n template demonstrates how to capture Actual Data Releases as quickly as possible for trading decisions. Use cases: 1. Get notified if the actual data release is positive or negative for the relevant currency. 2. Use the Telegram chat message about the news release as a trigger to open a trading position in MetaTrader 4. 3. Record news data and live price

Free

Backup your workflows to GitHub

Based on Jonathan's work. Check out his templates. How it works This workflow will backup your workflows to GitHub. It uses the n8n API node to export all workflows. It then loops over the data, checks in GitHub to see if a file exists that uses the credential's ID. Once checked it will: - update the file on GitHub if it exists; - create a new file if it doesn't exist; - ignore if it's the same. Who is this for? People wanting to backup their workflows outside the server for safety purposes or t

Free

Generate AI videos with Google Veo3, save to Google Drive and upload to YouTube

This workflow allows users to generate AI videos using Google Veo3, save them to Google Drive, generate optimized YouTube titles with GPT-4o, and automatically upload them to YouTube with Upload-Post. The entire process is triggered from a Google Sheet that acts as the central interface for input and output. IT automates video creation, uploading, and tracking, ensuring seamless integrat

Free

Weather forecast email - receive automated weather forecasts daily

Video Introduction []( Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin --- Workflow Overview This workflow automatically delivers a daily weather forecast to your email inbox every morning at 7:00 AM. It demonstrates practical API-to-API integration by connecting the Meteosource weather API directly to Gmail using n8n's HTTP Request node, without requiring a pre-built Meteosource integration. Why This Workflow is Valuable Instead of manually checking we

Free

Centralized n8n error management system with automated email alerts via Gmail

Advanced n8n Error Handling: Automated Email Alerts & Global Error Workflow Configuration In any automated environment, n8n workflows, while powerful, can sometimes encounter unexpected issues or fail during execution. Without a dedicated error handling strategy, these failures might go unnoticed, leading to incomplete processes, data inconsistencies, or critical operational disruptions. Manually monitoring every workflow execution or sifting through logs for error details is inefficient and can

Free

Build production-ready user authentication with Airtable and JWT

This n8n workflow provides a comprehensive solution for user authentication and management, leveraging Airtable as the backend database. It includes flows for user sign-up and login, aswell as the sample crud operations retrieving user details, and updating user information. Youtube Video of me explaining the flow: How it Works User Sign-Up Flow 1. Receives POST request: A webhook listens for POST requests containing new user details (email, first name, last name, password). 2. Checks for exist

Free

Auto-generate AI news commentary with Dumpling AI and GPT-4o

This workflow turns trending news into thoughtful first-person commentary for platforms like LinkedIn. It uses Dumpling AI’s News Search and Scraping APIs to find and extract article content, then feeds the cleaned text to GPT-4o to write personalized insights. The final output is saved back to Google Sheets as a draft for easy review or posting. --- ✅ What this workflow does 1. Triggers daily using a Schedule node. 2. Fetches a list of content topics from a Google Sheet. 3. Uses Dumpling AI to

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free