Negotiate car purchase quotes with Gemini, Gmail, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs when someone submits an n8n form (“Vehicle Inquiry”). Along the way it connects Google Sheets, Gmail, Redis Chat Memory and Google Gemini Chat Model.
How it runs
Trigger: When someone submits an n8n form (“Vehicle Inquiry”).
- Normalize Form Input (Edit Fields (Set)): sets 7 fields: deal_id, car_id, customer_name…
- Set Dealer Configuration (Edit Fields (Set)): sets 3 fields: dealership_name, sales_rep_name, max_discount_percent
- Read Inventory from Sheets (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Prepare Deal Data (Edit Fields (Set)): sets 14 fields: deal_id, car_id, customer_name…
- Send Car Not Found Email (Gmail): uses Gmail
- Car Sales AI Agent (AI Agent): runs an AI agent, with model: Gemini Flash-Lite Model; 2 tools (Calculate Offer Tool, Fetch Vehicle Details Tool); memory: Redis Chat Memory; output parser: Parse Structured Output
- If: checks a condition and branches into true / false
- Append or Update Lead in Sheets (Google Sheets): append or update
- Send Customer Reply Email (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
Quick overview Youtube Video: https://youtu.be/0B5IAirPe5o This workflow captures vehicle inquiries via an n8n Form, looks up inventory details in Google Sheets, uses Google Gemini with Redis chat memory to draft a negotiated email quote, logs the lead to a…