Enrich company leads and find HR contacts with Google Sheets, OpenAI and LinkFinder AI Workflow Solution

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building.

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

Best fit

Need another direction?