Log new hiring leads from Apify to Sheets with GPT-4o-mini and Slack alerts
UnknownWhat this workflow does
This AI workflow has 17 nodes and runs on a schedule (every day at 08:00). Along the way it connects Slack, OpenAI Chat Model, Google Sheets and Apify (community).
How it runs
Trigger: On a schedule (every day at 08:00).
- Radar Settings (Edit Fields (Set)): sets 10 fields: jobTitles, keywords, industries…
- Build Actor Request (Code): runs custom JavaScript code
- Fetch Fresh Job Postings (Apify): run actor and get dataset
- Group Postings by Company (Code): runs custom JavaScript code
- Alert on Feed Failure (Slack): uses Slack
- Skip Companies Already Pitched (Remove Duplicates): removes duplicate items
- Enough Open Roles to Count (If): checks a condition and branches into true / false
- Draft Outreach Opener (AI Agent): runs an AI agent, with model: GPT Model
- Combine Lead Record (Edit Fields (Set)): sets 9 fields: companyName, companyWebsite, industry…
- Route by Signal Strength (Switch): routes items into 2 branches
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Fetch Fresh Job Postings).
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Apify
@apify/n8n-nodes-apify.apify - Slack
n8n-nodes-base.slack - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch
From the author
Quick overview This workflow runs every morning to pull the last 24 hours of job postings from Apify, groups them by company, deduplicates companies across runs, uses OpenAI to draft two-line outreach openers, logs leads to Google Sheets, and posts hot-lead…