Enrich company leads and find HR contacts with Google Sheets, OpenAI and LinkFinder AI
Description
This workflow is Part 2 of the HR Client Acquisition system and builds on the lead discovery pipeline from the previous workflow:
š HR Client Acquisition (Part 1) ā Job Lead Discovery & AI Qualification System
In Part 1, job leads are discovered and qualified using AI.
In this workflow (Part 2), those qualified companies are enriched further by identifying company domains, classifying them as employers or agencies, and extracting decision-maker contacts such as HR and operations leaders.
The workflow uses AI, web scraping, and enrichment APIs to transform raw company data into actionable outreach-ready leads with verified contact information.
Use cases
Recruitment agencies targeting companies actively hiring
Sales teams building high-quality outbound lead lists
Automating employer research and contact discovery
Enriching job-based leads into decision-maker pipelines
Requirements
Google Sheets account
OpenAI API key
Apify account
LinkFinder AI API key
n8n instance with environment variables configured
How to use
Run Part 1 workflow to collect and qualify job leads
Ensure companies are stored in Google Sheets with status = NEW or ENRICHMENT_REQUIRED
Execute this workflow
Workflow enriches companies and extracts key contacts
Contacts are saved into Google Sheets for outreach
Customising this workflow
Modify AI prompts for company classification
Adjust industry filtering logic
Change contact selection priorities (HR, operations, leadership)
Integrate additional enrichment or CRM tools
What this template demonstrates
Multi-step lead enrichment pipeline
AI-powered company classification
Domain extraction and validation
Contact discovery using external APIs
Structured data handling using Google Sheets
How it works
⢠Step 1: Fetch qualified companies from Google Sheets
⢠Step 2: Extract or predict company domain
⢠Step 3: Scrape and analyze website content using AI
⢠Step 4: Classify company as employer or agency
⢠Step 5: Enrich employer data and fetch employee contacts
⢠Step 6: Select top contacts and store results
Setup steps
⢠Estimated setup time: 15ā25 minutes
⢠Configure API keys (OpenAI, Apify, LinkFinder)
⢠Set environment variables for Google Sheets
⢠Connect output of Part 1 workflow
⢠Run test execution with sample data
Related Templates
Extract Named Entities from Web Pages with Google Natural Language API
Who is this for? Content strategists analyzing web page semantic content SEO professionals conducting entity-based anal...
Add product ideas to Notion via a Slack command
Use Case In most companies, employees have a lot of great ideas. That was the same for us at n8n. We wanted to make it a...
Automate Daily Keyword Research with Google Sheets, Suggest API & Custom Search
Who's it for This workflow is perfect for SEO specialists, marketers, bloggers, and content creators who want to automa...
š Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments