Score and qualify Google Sheets leads with OpenAI gpt-4o-mini
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 workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.openai.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- ⭐ Configure Your Run (Edit Fields (Set)): sets 4 fields: max_per_run, openai_model, icp_description…
- Read Leads (Google Sheets): uses Google Sheets
- Select Pending (Code): runs custom JavaScript code
- Build Scoring Prompt (Code): runs custom JavaScript code
- Score Lead (OpenAI) (HTTP Request): calls api.openai.com (POST)
- Parse Score (Code): runs custom JavaScript code
- Write Score (Google Sheets): update
- Qualified Leads (≥ min score) (Code): runs custom JavaScript code
Services it uses
HTTP calls to: api.openai.com
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 (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow reads leads from a Google Sheets spreadsheet, scores each pending lead against your Ideal Customer Profile using the OpenAI Chat Completions API, writes the results back to the sheet, and outputs only leads that meet your minimum…