Qualify lead lists and find professional emails with OpenAI and Google Sheets
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 It Works 1. Watch For New Leads Google Drive trigger monitors a folder. When a new spreadsheet lands, the workflow fires. 2. Read Lead Sheet Pulls every row from the new spreadsheet. 3. Normalize Lead Data Standardizes fields: full name, comp
At a glance
Qualify lead lists and find professional emails with OpenAI and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI, Google Drive, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, OpenAI, Google Drive, LinkedIn
- Modules
- 10
- Price
- Free
- Version
- v1.0

About this workflow
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 It Works 1. Watch For New Leads Google Drive trigger monitors a folder. When a new spreadsheet lands, the workflow fires. 2. Read Lead Sheet Pulls every row from the new spreadsheet. 3. Normalize Lead Data Standardizes fields: full name, company, website, LinkedIn URL, industry, job title, and location. 4. Find Email via OpenAI Each lead is sent to GPT-4o to find a verified professional email. Returns the email, source, and confidence score (high / medium / low). 5. Rate-Limited Batching Leads process in batches of 3 with a 1.5s delay to respect API rate limits. 6. Has Valid Email? If a valid email was found (contains @), the lead goes to the Qualified sheet. Otherwise it goes to Unqualified -- both written back to the same spreadsheet. --- Setup 1. Google Drive / Sheets -- Connect your Google OAuth2 credentials. Update the folder ID in the trigger node. 2. OpenAI -- Connect your OpenAI API credential to the Find Email via OpenAI node. 3. Input Sheet -- Needs columns: first name, last name, company, corporate website, linkedin industry, linkedin url, job title, location 4. Output Tabs -- Create two tabs named Qualified and Unqualified with columns: fullName, companyName, companyWebsite, linkedinUrl, jobTitle, location, email, source, confidence --- Use Cases - Qualify exported Apollo / LinkedIn Sales Nav lead lists before outreach - Enrich scraped conference attendee lists with verified emails - Pre-qualify inbound lead dumps before loading into your CRM or sequencer Built by Devon Toh
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 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
Automated product inquiry responder with GPT-4 and Google Sheets
Generate an HTML/CSS Invoice from new Google Sheets rows
Zoom AI meeting assistant creates mail summary, ClickUp tasks and follow-up call
Create Google Drive folders by path
Add new Acuity Scheduling appointments to a Google Sheets spreadsheet as new rows
Create Barcodes for new Zoho Inventory sales orders
Multi-source news curator with Mistral AI analysis, summaries & custom channels
Auto-generate & distribute LinkedIn posts with GPT-4 to profile & groups
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.
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.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you