Score and auto-reply to new leads with OpenAI and Gmail
Who is this for++ Small business owners, freelancers, and agencies who receive inbound leads through a web form and want instant, personalized follow-up — without manually reading every submission. ++What it does++ When someone fills out your lead intake form, this workflow instantly: Scores the lead 1-100 using OpenAI based on budget, project fit, and clarity Classifies them as Hot, Warm, or Cold Sends a personalized email reply that references what they actually wrote Logs everything to Google
At a glance
Score and auto-reply to new leads with OpenAI and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, OpenAI
- Modules
- 9
- Price
- Free
- Version
- v1.0

About this workflow
Who is this for++ Small business owners, freelancers, and agencies who receive inbound leads through a web form and want instant, personalized follow-up — without manually reading every submission. ++What it does++ When someone fills out your lead intake form, this workflow instantly: Scores the lead 1-100 using OpenAI based on budget, project fit, and clarity Classifies them as Hot, Warm, or Cold Sends a personalized email reply that references what they actually wrote Logs everything to Google Sheets with the score and AI reasoning Hot leads get an enthusiastic reply with a calendar booking link. Warm leads get a helpful response with suggested next steps. Cold leads get a polite acknowledgment. Every lead gets a response within seconds. ++How to set up++ Fill in the "Configure Your Settings" node with your business name, email, calendar link, and description Connect your Gmail and Google Sheets credentials Add your OpenAI API key Create a Google Sheet with the column headers listed in the workflow's sticky notes Paste your Sheet URL into the "Log Lead with Score" node Activate the workflow and share the form URL Requirements n8n account (cloud or self-hosted) OpenAI API key Gmail account (OAuth2) Google Sheets (one blank sheet) How to customize Edit the OpenAI system prompt to adjust scoring criteria for your industry Modify the tier thresholds (currently Hot 70+, Warm 40-69, Cold 0-39) Customize the email tone by editing each Gmail node Add or remove form fields to match your intake need
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Organize Feedly articles by local/national with ChatGPT and add to Google Sheets 1/2
Create a MantisBT Issue from Gmail
Manage construction projects with tasks, photo reports, Telegram & Google Sheets
Send custom email notifications to ChatGPT and log results in Google Sheets
Send CommCare form data to Google Sheets
Create AI-powered SEO audit reports with DataForSEO and Claude
Sap service layer login
Voice Creation, TTS, Sound Effects, Voicechanger & more! 🎧 Elevenlabs MCP Server
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you