Automate Auto Repair Quote Requests with Gmail and AI
detail.loadingPreview
This workflow automates the processing of incoming auto repair quote requests via Gmail. It uses AI to analyze emails, gather missing information, and log details to Google Sheets, streamlining communication.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to automate the handling of incoming emails for an auto repair shop, specifically focusing on quote requests. It triggers when a new email arrives in Gmail, then uses an AI model (Gemini) to analyze the content. The AI determines if the email is a genuine quote request and checks if all necessary information (vehicle make, model, year, and issue description) is present. If information is missing, it crafts a follow-up email to the customer. If all details are complete, it notifies the shop owner. Finally, all interactions are logged to a Google Sheet for record-keeping and analysis. This workflow solves the problem of manual email sorting, repetitive follow-ups, and ensures that no quote requests are missed or delayed.
Key Features
- Trigger emails from Gmail automatically.
- AI-powered analysis of email content for quote request relevance.
- Identification and request for missing essential information (vehicle details, issue description).
- Automatic sending of follow-up emails to customers.
- Notification to shop owner upon receiving complete quote requests.
- Comprehensive logging of all email interactions to Google Sheets.
How To Use
- Connect Gmail Account: Set up Gmail OAuth2 credentials in n8n to allow the workflow to read and send emails.
- Set up Google Sheets: Configure Google Sheets OAuth2 credentials and ensure your target spreadsheet and sheet are accessible. Update the Google Sheets node with the correct document URL and sheet name.
- Configure AI Model: Set up your Google Gemini (PaLM) API credentials in n8n.
- Review and Customize AI Prompt: Adjust the system prompt in the
gemini-2.5-pro-agentnode to refine how the AI analyzes emails and what information it considers essential. - Adjust Google Sheet Columns: Ensure the column names in the
log_messagenode's parameters match your Google Sheet headers (Timestamp, Sender, Subject, Message Preview, Action Taken). - Test the Workflow: Send test emails to your connected Gmail account to verify that the workflow triggers, analyzes, and logs as expected.
Apps Used
Workflow JSON
{
"id": "13e01c33-b6ec-43d7-be13-9bd6d395a9ae",
"name": "Automate Auto Repair Quote Requests with Gmail and AI",
"nodes": 0,
"category": "Email Automation",
"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: 13e01c33-b6ec...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Automated Phishing Email Detection and Jira Ticket Creation
This workflow automatically detects phishing emails via Gmail, analyzes them with ChatGPT, and creates detailed Jira tickets with screenshots for investigation.
Automate Gmail PDF Attachments to Google Drive with OpenAI
Automatically send specific PDF attachments from Gmail to Google Drive, leveraging OpenAI for content filtering. This workflow uses the 'On email received' node to trigger, 'OpenAI' to analyze PDF content, and 'Google Drive' to store matched files.
Automated Email Phishing Detection and Jira Ticketing
Detect potential phishing emails using Gmail or Outlook triggers and OpenAI analysis, then automatically create Jira tickets with detailed findings. This workflow enhances security by streamlining the reporting and investigation of suspicious emails.