Quote and dispatch home-service jobs from forms with OpenAI, Google Sheets and Slack
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 17 nodes and runs when someone submits an n8n form. Along the way it connects Google Sheets, OpenAI Chat Model, Slack and Gmail.
How it runs
Trigger: When someone submits an n8n form.
- Dispatch Settings (Edit Fields (Set)): sets or maps fields
- Read The Price Book (Google Sheets): uses Google Sheets
- Estimate The Job (Information Extractor): extracts structured fields from text with AI, with model: Estimate Model
- Read The Servicemen (Google Sheets): uses Google Sheets
- Ask A Human To Quote It (Slack): uses Slack
- Pick The Best Serviceman (Code): runs custom JavaScript code
- Build The Log Row (Code): runs custom JavaScript code
- Was Someone Found? (If): checks a condition and branches into true / false
- Log The Job (Google Sheets): uses Google Sheets
- Send The Job To The Serviceman (Slack): uses Slack
…plus 4 more steps. See the full node list below.
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)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Slack
n8n-nodes-base.slack - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow collects home-service quote requests via an n8n Form, uses OpenAI and a Google Sheets price book to estimate effort and a price range, then dispatches the job to the best matching serviceman in Slack and logs every request back to…