AutomationMart
Home/Browse/Score and auto-reply to new leads with OpenAI and Gmail
n8n

Score and auto-reply to new leads with OpenAI and Gmail

n8nn8n9 modulesv1.0
GmailGoogle SheetsOpenAI

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
Score and auto-reply to new leads with OpenAI and Gmail workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

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

Organize Feedly articles into local or national, give them a rating, categorize into specific industries using ChatGPT and save them easily in Google Sheets for better content management. Here is template [1/2.](www.make.com/en/integration/12189-create-a-newsletter-with-chatgpt-and-mailchimp-2-2?templatePublicId=12189) The template is part of this [Webinar.](https://www.youtube.com/watch?v=EwfCfoVpLgQ)

Free

Create a MantisBT Issue from Gmail

Every time you get an email in the watched folder, a new Issue in MantisBT is created.

Free

Manage construction projects with tasks, photo reports, Telegram & Google Sheets

How it works This template helps project managers collect task updates and photo reports from field workers via Telegram and stores everything in a Google Sheet. It enables daily project reporting without paper or back-office overhead. High-level flow: Workers receive daily tasks via Telegram They respond with photo reports Bot auto-saves replies (photos + status) to a Google Sheet The system tracks task completion, adds timestamps, and maintains report history Set up steps 🕒 Estimated setup tim

Free

Send custom email notifications to ChatGPT and log results in Google Sheets

Send personalized email notifications and log responses in Google Sheets using ChatGPT. Enhance communication and data tracking effortlessly.

Free

Send CommCare form data to Google Sheets

Every time you receive a new response in the CommCare account, Make will automatically add selected data from the response to a new row in a Google Sheets spreadsheet. The template uses [this example spreadsheet.](https://docs.google.com/spreadsheets/d/1dsSBXgcPdeQgUNWUEnvTbcZIziufyF-Sbn0MIYsUSE0/edit?usp=sharing)

Free

Create AI-powered SEO audit reports with DataForSEO and Claude

Automated SEO Intelligence Platform with DataForSEO and Claude Transform any company website into a detailed SEO audit report in minutes! This workflow combines real-time web scraping, comprehensive SEO data analysis, and advanced AI reasoning to deliver client-ready reports automatically. Perfect for digital agencies scaling their audit services, freelance SEO consultants automating research, or SaaS teams analyzing competitor strategies before sales calls. The Process Discovery Phase: Input a

Free

Sap service layer login

This minimal utility workflow connects to the SAP Business One Service Layer API to verify login credentials and return the session ID. It's ideal for testing access or using as a sub-workflow to retrieve the B1SESSION token for other operations. ++⚙️ HOW IT WORKS:++ 🔹 1. Trigger Manually The workflow is initiated using a Manual Trigger. Ideal for testing or debugging credentials before automation. 🔹 2. Set SAP Login Data The Set Login Data node defines four key input variables: sapurl: Base URL

Free

Voice Creation, TTS, Sound Effects, Voicechanger & more! 🎧 Elevenlabs MCP Server

Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community This workflow provides a complete set of tools for interacting with the ElevenLabs voice API, enabling AI-powered text-to-speech, voice management, and audio processing capabilities. Features 🚀 Text-to-Speech Operations - Convert text to speech with customizable voice settings - Generate speech with timestamps for precise audio control - Stream text-to-speech

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free