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).