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 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