AutomationMart
Home/Browse/Qualify lead lists and find professional emails with OpenAI and Google Sheets
n8n

Qualify lead lists and find professional emails with OpenAI and Google Sheets

n8nn8n10 modulesv1.0
Google SheetsOpenAIGoogle DriveLinkedIn

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
Qualify lead lists and find professional emails with OpenAI and Google Sheets workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

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

AI-Powered Product Assistant for E-commerce Transform your online store customer service with an intelligent AI assistant that automatically processes customer inquiries, searches your product database, and provides personalized responses about product availability, pricing, and specifications. Perfect for shoe stores, fashion retailers, and any business with extensive product catalogs - this workflow eliminates manual customer service while increasing response speed and accuracy. How

Free

Generate an HTML/CSS Invoice from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Integromat will automatically generate an invoice with HTML/CSS to Image and upload it to Google Drive.

Free

Zoom AI meeting assistant creates mail summary, ClickUp tasks and follow-up call

Update 19-04-2025 ## - Change from OpenAI to Claude 3.7 Sonnet module - Adding the Think Tool The update enables significantly better results to be achieved. This is particularly noticeable during longer meetings! What this workflow does This workflow retrieves the Zoom meeting data from the last 24 hours. The transcript of the last meeting is then retrieved, processed, a summary is created using AI and sent to all participants by email. AI is then used to create tasks and follow-up appointments

Free

Create Google Drive folders by path

This workflow creates nested Google Drive folders from a path string (like Projects/Clients/Reports). It automatically handles the necessary folder lookups and creation steps required by Google Drive, then outputs the final folder's ID for immediate use. How it works This workflow streamlines the creation of nested folders in Google Drive: 1. Input: Provide a rootfolderid and a path (e.g., Projects/Clients/Reports) as input. 2. Path Parsing: The workflow splits the path into individual folder na

Free

Add new Acuity Scheduling appointments to a Google Sheets spreadsheet as new rows

Every time a new appointment is scheduled in Acuity Scheduling, Make will automatically add the appointment's info to a new row in your Google Sheets spreadsheet. The template uses this [example spreadsheet](http://bit.ly/2Zfcdoj).

Free

Create Barcodes for new Zoho Inventory sales orders

Every time a sales order is added to your Zoho Inventory organization, Make will automatically generate a Barcode for it. Then, the Barcode will be saved in a specified Google Drive folder, as a ready-to-print document.

Free

Multi-source news curator with Mistral AI analysis, summaries & custom channels

Flexible News Curator - Multi-Sources, AI Analysis, Summaries, Translation, and Settable Channels 🎬 Overview The Flexible News Curator workflow can automate the collection, filtering, AI-driven analysis, and summarization of news from diverse sources of your interest. Using customizable search themes, RSS feeds, and (optional) video descriptions, it delivers concise, quality news summaries via configurable channels. This workflow is designed to help reduce information overload and keep you updat

Free

Auto-generate & distribute LinkedIn posts with GPT-4 to profile & groups

LinkedIn AI Agent: Auto-Post Creator & Multi-Group Distributor Transform simple topic ideas into engaging LinkedIn posts and automatically distribute them across your profile and multiple LinkedIn groups. This powerful n8n workflow combines AI content generation with intelligent distribution, helping you maintain a consistent professional presence while maximizing your reach across relevant communities. 🚀 How It Works This sophisticated 6-step automation turns content ideas into LinkedIn success

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free