Gmail Repair Quote Triage with OpenAI + Google Sheets (n8n)

Stop Guessing, Start Quoting: Gmail Repair Quote Triage with OpenAI + Google Sheets (n8n)

When your shop inbox fills with repair and estimate requests—and half are missing the one detail you need—this n8n workflow automatically triages the emails, logs every request to Google Sheets, replies for missing information, and emails you a morning summary of what’s still waiting.

What this workflow does

• Triggers on unread Gmail messages matching your quote/estimate/repair/service subject query.
• Marks messages as read (via Mark Email Read) and normalizes the content (sender, subject, body) using Normalize Email.
• Uses OpenAI (GPT-6.1-sol) through the Classify Quote Request agent to determine whether the message is a real repair/quote request and extract key fields: year, make, model, customer concern, and whether enough information exists to price.
• Routes outcomes:
  • Skip Non Request drops non-request messages.
  • Reply lane handles requests without sufficient detail.
  • Logging lane handles fully detailed requests.
• Logs to Google Sheets:
  • Log Awaiting Info appends thin requests to the “Quotes” tab.
  • Send Missing Info Reply emails the customer a short, targeted ask for only the missing fields.
  • Log Ready Quote appends complete requests as ready.
  • Notify Shop Owner emails you a summary of what’s ready.
• Morning follow-ups: a dedicated lane reads the “Quotes” log, finds requests open for about a day, and sends the owner an Open Quotes Summary.

Use cases

• Your shop receives quote requests for repairs but routinely lacks model year or vehicle details.
• You want automatic customer follow-up emails instead of manual inbox checks.
• You need an always-current Google Sheets “Quotes” pipeline and daily status visibility.

Technical details

• n8n workflow category: n8n automation workflow
• Tech stack / nodes used: code, no op, Gmail trigger, switch, sticky note
• AI: OpenAI via Shop Model chat model (GPT-6.1-sol) for classification + extraction
• Data logging: Google Sheets (writes to the “Quotes” tab)

Last updated: October 2026.