Qualify lead lists and find professional emails with OpenAI and Google Sheets
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 AI workflow has 10 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, Google Sheets and OpenAI.
How it runs
Trigger: On Google Drive events (file created).
- Read Lead Sheet (Google Sheets): uses Google Sheets
- Normalize Lead Data (Edit Fields (Set)): sets 7 fields: fullName, companyName, companyWebsite…
- Batch Leads (Loop Over Items (Split in Batches)): loops over the items in batches
- Has Valid Email? (If): checks a condition and branches into true / false
- Find Email via OpenAI (OpenAI): uses OpenAI
- Save Qualified Lead (Google Sheets): append
- Save Unqualified Lead (Google Sheets): append
- Rate Limit Delay (Wait): waits 1.5 seconds
- Parse Email Results (Edit Fields (Set)): sets 10 fields: fullName, companyName, companyWebsite…
Services it uses
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 (7)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if
From the author
Qualify Lead Lists And Find Professional Emails With OpenAI and Google Sheets Drop a lead list into Google Drive. This workflow reads it, finds professional emails using OpenAI, and splits leads into Qualified and Unqualified sheets fully automated. --- How…