Quick overview
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 alerts and a daily digest to Slack. How it works Runs every morning at 8 AM. Builds a search payload from your niche settings and queries the Apify Hirebase jobs feed for recent job postings. If the job feed fails, sends a Slack message with the error details and stops logging leads. Groups all returned postings by company, summarizing role count, titles, locations, and job links into one lead per company. Skips companies that have already appeared in previous workflow executions and filters out companies below your minimum open-role threshold. Uses OpenAI to generate a two-line cold outreach opener for each remaining company. Appends each lead (company details, roles, links, and AI opener) to Google Sheets and posts either an immediate Slack alert for hot leads or a Slack digest for standard leads. Setup Add an Apify connection and ensure the Apify node @apify/n8n-nodes-apify is installed if it is not available in your instance. In Radar Settings, set at least one of Job Titles or Keywords and adjust optional filters like industries, company sizes, locations, and the min/hot open-role thresholds. Add an OpenAI API credential and select the model you want to use for generating the two-line opener. Add a Google Sheets OAuth2 credential, set the target spreadsheet and sheet name, and ensure your sheet has matching columns (Date Found, Company, Industry, Company Size, Open Roles, Role Titles, Locations, Website, AI Opener, Job Links). Add a Slack OAuth2 credential, choose the channel for hot-lead alerts and the daily digest, and replace the digest channel placeholder value with your real channel. Requirements Apify Account. An n8n automation workflow template by Spencer Rowley.
Spencer Rowley
web
free
Others in the same category, ranked by how often they are opened.
