Extract Sales Leads from Google Jobs, LinkedIn & Indeed with GPT-4o and Apify

Description

Who is this for?

This template is designed for B2B sales teams, recruiters, and business development professionals who want to identify sales opportunities by monitoring hiring signals from target companies. It's particularly useful for:

Sales teams selling HR tech, recruitment software, or staffing services
Consultancies offering technical talent or project-based work
Any B2B company that uses "intent data" from job postings to time their outreach

What this workflow does

This workflow automates the entire process of monitoring job postings and converting hiring signals into actionable sales leads:

Daily Job Scraping: Automatically scrapes job postings from Google Jobs, LinkedIn, and Indeed for your target companies using Apify actors
Data Normalization: Standardizes job data from multiple sources into a unified format
Keyword Filtering: Filters jobs based on your target keywords to identify relevant opportunities
AI-Powered Analysis: Uses GPT-4o to analyze each qualified job posting and generate:
Inferred pain points from the hiring signal
Strategic sales approach angles
Urgency scoring (1-10)
Ready-to-send cold email drafts
Slack Notifications: Sends real-time alerts with AI insights to your sales channel
Weekly Reports: Generates comprehensive trend analysis reports every Monday with AI-powered insights

Setup

Google Sheets: Create a spreadsheet with 4 sheets:
Target Companies (columns: Company Name, Target Keywords, My Solution)
Raw Jobs (for all scraped jobs)
Qualified Leads (for filtered opportunities)
Weekly Reports (for trend analysis)

Apify: Set up accounts and get Actor IDs for:
Google Jobs Scraper
LinkedIn Jobs Scraper
Indeed Scraper

Credentials: Connect your Google Sheets, Slack, Gmail, OpenAI, and Apify credentials

Configuration: Update the placeholder values in the workflow for your specific IDs and channel names

Requirements

n8n instance (self-hosted or cloud)
Apify account with credits
OpenAI API key (GPT-4o access)
Google Sheets access
Slack workspace (optional, for notifications)
Gmail account (optional, for email reports)

Customization

Adjust maxJobsPerSource and daysToCheck in the Configuration node
Modify AI prompts to match your sales style and language preferences
Add or remove job sources based on your needs
Customize Slack message format and notification triggers