Negotiate Car Quotes with Gemini, Gmail & Google Sheets (n8n)

Instant, negotiable car quote emails from your n8n Form—powered by Gemini + Gmail + Google Sheets

This n8n workflow automatically captures vehicle inquiries, checks inventory in Google Sheets, drafts a negotiation-ready quote using Google Gemini (with Redis chat memory), logs the lead in a second spreadsheet, and sends the response to the customer via Gmail.

What this workflow does

• Receives a car inquiry from an n8n Form, including the selected car, customer contact details, and the customer’s message.
• Normalizes and prepares deal data by generating a unique deal ID, extracting the car ID, and standardizing contact fields.
• Looks up vehicle inventory in a Google Sheets inventory spreadsheet using the car ID.
• Handles missing/invalid vehicles: if the car ID is missing or not found, the workflow sends a “vehicle not found” email through Gmail.
• Generates an official negotiated quote when the vehicle is found: it builds a deal context (vehicle details, pricing fields, availability) and sends the customer message to a Google Gemini–powered agent using Redis-based conversation memory.
• Negotiation logic with tool calls: the agent uses tools to return official vehicle details and calculate an acceptable price outcome (accept/counter/unavailable/invalid) before producing structured `HTML` email output.
• Logs the lead into the Car Inquiry Leads Google Sheets tab by matching the customer email, then emails the generated response via Gmail.

Use cases

• Car dealerships automating negotiated quote replies to inbound web form inquiries.
• SaaS operators deploying an AI-assisted sales email flow with audit-friendly lead logging.
• n8n users who need a reliable Gemini + Google Sheets + Gmail customer communication pipeline.

Technical details

• n8n nodes: Form Trigger, if, set, Google Sheets, Gmail, and supporting nodes (e.g., Sticky Note for workflow guidance).
• Google integration: Google Sheets via Google Service Account (configure document IDs and sheet tabs for inventory and leads).
• AI integration: Google Gemini with Redis chat memory for conversational context.

Includes end-to-end lead capture, inventory lookup, Gemini-based negotiation email drafting, lead upsert to Google Sheets, and customer delivery through Gmail.