Google Sheets + OpenAI, smarter lead qualification
Leads land in a spreadsheet, and then… nothing. Or worse, you skim half the rows, guess who’s “good,” and follow up too late (or on the wrong people).
Marketing managers feel this when campaigns spike and the sheet fills up fast. Sales reps get it too, because every “maybe” lead still steals attention. Lead scoring automation fixes the triage problem so you can focus on the conversations that actually convert.
This guide walks you through an n8n workflow that watches Google Sheets, asks OpenAI to assess each lead using your rules, then writes “qualified” or “not qualified” back to the same row. Clean. Consistent. Fast.
How This Automation Works
Here’s the complete workflow you’ll be setting up:
n8n Workflow Template: Google Sheets + OpenAI, smarter lead qualification
flowchart LR
subgraph sg0["Monitor New Rows Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Monitor New Rows", pos: "b", h: 48 }
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/openAi.dark.svg' width='40' height='40' /></div><br/>Assess Leads via GPT"]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Parse JSON Output", pos: "b", h: 48 }
n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Combine Streams"]
n4@{ icon: "mdi:database", form: "rounded", label: "Modify Lead Status", pos: "b", h: 48 }
n3 --> n4
n2 --> n3
n0 --> n3
n0 --> n1
n1 --> n2
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n4 database
classDef customIcon fill:none,stroke:none
class n1,n3 customIcon
Why This Matters: Slow follow-up and inconsistent lead triage
Spreadsheet leads look simple until you’re dealing with real volume. You copy a row into an email, check a company site, scan job titles, and try to decide if it’s worth a response. Then you do it again. After about 20 rows, you start cutting corners. You miss details. You follow up late. And because everyone “qualifies” differently, your pipeline turns into a grab bag of opinions instead of something you can trust.
It adds up fast. Here’s where it breaks down in day-to-day work.
- Reviewing new leads one-by-one can easily eat about an hour on busy days.
- Two people will label the same lead differently, which means reporting becomes meaningless.
- Hot leads wait while you chase weak fits, and your response time quietly slips.
- Manual notes and status updates get skipped, so the sheet becomes “almost accurate” at best.
What You’ll Build: Auto-qualify new Google Sheets leads with OpenAI
This workflow starts the moment a new lead is added to your Google Sheets document. n8n grabs the row details (name, email, company, message, and whatever fields you track), then sends that information to OpenAI with a system prompt that contains your qualification rules and a strict response format. OpenAI replies with a small JSON decision, and n8n parses it, combines it with the original lead data, and writes the result back into the same row. The final outcome is simple: every incoming lead gets a consistent label like “qualified” or “not qualified” without anyone needing to open the sheet.
The workflow begins with a “new row” trigger in Google Sheets. Then it runs the lead through OpenAI for a rules-based decision. Finally, it updates your sheet so sorting, filtering, and follow-up become instant.
What You’re Building
| What Gets Automated | What You’ll Achieve |
|---|---|
|
|
Expected Results
Say you collect 25 leads a day into Google Sheets. If manual review takes maybe 4 minutes per lead (skim, decide, update status), that’s about 100 minutes daily. With this workflow, the “work” becomes adding the row like you already do, then waiting a minute or two for OpenAI to return a decision and for n8n to write it back. You get most of that time back, and the labels stay consistent all week.
Before You Start
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for capturing and storing incoming leads
- OpenAI to apply lead qualification rules consistently
- OpenAI API key (get it from your OpenAI dashboard)
Skill level: Beginner. You’ll connect accounts, paste prompts, and map a few fields.
Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).
Step by Step
A new lead row appears in Google Sheets. n8n monitors your chosen spreadsheet and triggers as soon as a new row is added, so nothing gets missed during busy periods.
The lead details are sent to OpenAI for evaluation. The workflow packages the row fields into a prompt: the system message holds your qualification rules and the required JSON response format, while the user message contains the lead’s actual data.
The AI response is converted into structured fields. n8n parses the JSON so you can reliably extract things like “qualified/not qualified” (and any extra fields you decide to capture, such as a reason).
The original spreadsheet row gets updated. The workflow merges the AI output with the lead row context, then writes the qualification result back into a dedicated column for filtering and follow-up.
You can easily modify the qualification rules to match your ideal customer profile based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Google Sheets Trigger
This workflow starts when a new form response is added to a Google Sheet.
- Add and open the Monitor New Rows node.
- Set Event to
rowAdded. - Set Sheet Name to
Form Responses 1. - Set Document ID to the sheet labeled
Join Community (Responses). - Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.
everyMinute for timely lead assessment without exceeding Google API limits.Step 2: Connect Google Sheets
Prepare the output update to write the lead rating back to the same sheet.
- Open Modify Lead Status.
- Set Operation to
update. - Set Sheet Name to
Form Responses 1and Document ID toJoin Community (Responses). - Under Columns, map Rating to
{{ $json.reply.rating }}and Timestamp to{{ $json.Timestamp }}. - Set Matching Columns to
Timestampto update the correct row. - Credential Required: Connect your googleSheetsOAuth2Api credentials.
Step 3: Set Up AI Lead Scoring
The AI evaluates each lead and returns a JSON rating used later in the update step.
- Open Assess Leads via GPT and confirm Resource is
chatand Chat Model isgpt-4-turbo-preview. - Ensure the user message includes the lead fields:
{{ $json['Your name'] }},{{ $json['Email Address'] }},{{ $json['Your business area'] }}, and{{ $json['Your team size'] }}. - Set Temperature to
0.3to keep ratings consistent. - Credential Required: Connect your openAiApi credentials.
- Open Parse JSON Output and set the reply field to
{{ JSON.parse($json.message.content) }}.
Step 4: Combine Data Streams
This workflow merges the original form row data with the AI rating before updating the sheet.
- Open Combine Streams and set Mode to
combine. - Set Combination Mode to
mergeByPosition. - Confirm the flow: Monitor New Rows outputs to both Combine Streams and Assess Leads via GPT in parallel.
- Ensure Parse JSON Output connects into the second input of Combine Streams so both paths merge correctly.
Step 5: Test and Activate Your Workflow
Validate the full flow from form submission to sheet update, then enable it for production use.
- Click Execute Workflow and add a new row to the source sheet to trigger Monitor New Rows.
- Verify that Assess Leads via GPT returns a JSON object and Parse JSON Output creates a
replyobject. - Confirm Modify Lead Status updates the Rating column for the matching Timestamp.
- Once validated, toggle the workflow Active to enable automated lead qualification.
Troubleshooting Tips
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credentials screen and the Google account access settings first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice and clear qualification rules early or you’ll be editing outputs forever.
Quick Answers
About 30 minutes if your sheet and OpenAI key are ready.
No. You will mostly map spreadsheet fields and paste your qualification rules into the OpenAI prompt.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few cents per day at small volumes).
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and you should. Swap the qualification rules inside the “Assess Leads via GPT” OpenAI node, then adjust the “Parse JSON Output” node to match any extra fields you want to store (like a reason, a score, or a suggested next step). Common tweaks include adding an “ICP match” score, flagging free-email domains, and tightening rules by industry or company size.
Usually it’s expired Google authorization in n8n. Reconnect your Google Sheets credentials, then confirm the spreadsheet and worksheet IDs still point to the same file. If someone moved the sheet into a different Google Drive or changed sharing settings, the trigger may stop seeing new rows. Also check if you hit Google API limits when lots of rows are added at once.
In practice, hundreds of leads per day is realistic on a modest setup.
Often, yes, if you care about control. n8n makes it easier to enforce strict JSON parsing, merge the AI output back into the original lead row, and extend the logic later (for example, add a Telegram alert, a webhook to your CRM, or a human-review “If” branch for edge cases). It also gives you a self-hosting route, which can matter when volume grows. Zapier or Make can be quicker for very simple two-step flows, but AI lead qualification usually gets messy without good branching and data handling. Talk to an automation expert if you want help choosing.
You set the rules once, and the workflow applies them every time. That means faster follow-ups, cleaner data, and a spreadsheet you can finally trust.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
