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

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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
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.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.