LinkedIn Email Finder with AI Domain Detection using Google Sheets & Hunter.io
Who’s it for This template is designed for recruiters, lead-generation teams, agency owners, and sales professionals who collect LinkedIn profile data and need to automate the process of finding verified company domains and email addresses. It is ideal for teams looking to eliminate manual research and streamline prospect enrichment.
What it does / How it works
This workflow reads contact records from a Google Sheet, including name, position, and description.
An AI agent analyzes each profile to determine the company domain. If the domain is already identifiable from the description, it is used directly.
If no domain is found, the workflow generates an intelligent search term and performs a Google Custom Search to extract the most accurate domain from real web results using another AI agent.
Once the domain is confirmed, the workflow queries Hunter.io to find the best-matching email address for the contact.
Finally, the enriched data—email and company domain—is appended back into the Google Sheet, updating each row automatically.
Requirements
Google Sheets OAuth2 credentials
Google Gemini (PaLM) API credentials
Hunter.io API key
Google Custom Search API key and CSE ID
A Google Sheet with columns for name, position, description, and domain
How to set up
Connect your Google Sheets, Gemini, Hunter.io, and Google Search credentials.
Replace the Google Sheet ID and sheet name with your own.
Add your API keys to the designated nodes.
Ensure column names match your sheet structure.
Execute the workflow to begin enrichment.
How to customize the workflow
Modify AI prompts for better domain inference
Add additional enrichment steps (social profiles, industry tags)
Add fallback email providers (Snov, Apollo, etc.)
Change update logic to support multiple sheets or batch processing
Related Templates
Automate Customer Support & Calendar Bookings with OpenAI GPT and Google Calendar
Website AI Agent with Calendar Integration Categories: AI Agents, Website Integration, Calendar Automation This workfl...
Sync Zendesk tickets to your HubSpot contacts
This workflow automatically syncs your Zendesk tickets to your HubSpot contacts. Every 5 minutes, your HubSpot account c...
Get Qualified Leads in One Click from Apollo to Airtable
You Don’t Need More Tools. You Just Need the Right Leads. Why spend $1,000s on lead gen when your perfect leads are alre...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments