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, 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