Hiring-Intent Lead Finder: n8n + Apify to Google Sheets

Automatically find hiring-intent companies and enrich contacts in your Google Sheet (n8n + Apify)

This n8n workflow runs every Monday to identify companies currently hiring (based on your criteria) using Apify, logs only new domains to Google Sheets to prevent duplicates, and optionally enriches contact names with verified work email addresses—then posts a weekly summary to Slack.

What this workflow does

• Runs on a schedule: automatically executes every Monday at 8:00.
• Loads your criteria + deduplication ledger: reads search inputs and pulls existing company domains from Google Sheets to avoid re-adding the same companies.
• Email enrichment (optional, sheet-driven): collects rows where you entered contact first/last name and domain but no work email, then sends them to Apify Work Email Finder.
• Writes results back to Google Sheets: matches on company domain and records any found work emails, or saves a “not found” status with the last-checked date.
• Hiring-intent company discovery: calls the Apify Hiring Intent Contacts actor to fetch companies hiring in your selected locations and time window, including public-site emails and sample job details.
• Filters and appends: excludes companies already present in Google Sheets, flags whether only generic inbox emails were found, and appends new companies as new rows.
• Weekly visibility: builds a run summary and (if enabled) posts it to Slack. It also sends a Slack alert and fails the run if the Apify company search fails.

Use cases

• Weekly lead sourcing for B2B outbound using hiring intent signals.
• Maintaining an up-to-date Google Sheets CRM with verified work emails.
• SaaS teams monitoring target companies and job-related hiring changes.

Technical details (n8n + tools used)

• Apify HTTP requests using an API token via Authorization: Bearer <YOUR_APIFY_TOKEN>
• Google Sheets for storing domains, contacts, enriched emails, statuses, and “last-checked” timestamps
• n8n nodes: if, set, code, http request, slack, plus a sticky note