Qualify target accounts from job postings with Apify, OpenAI, Google Sheets and Telegram
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, OpenAI Chat Model, Telegram and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Set your targets (Edit Fields (Set)): sets 13 fields: whatYouSell, problemYouSolve, signalsYouCareAbout…
- Read your account list (Google Sheets): uses Google Sheets
- Collect the domains (Aggregate): combines items into one
- Find who they are hiring (Apify): run actor and get dataset
- Skip postings already read (Remove Duplicates): removes duplicate items
- Group postings by account (Code): runs custom JavaScript code
- Read the hiring signal (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI model; output parser: Signal format
- Format the account row (Edit Fields (Set)): sets 10 fields: Company, Domain, Score…
- Save every account brief (Google Sheets): append
- Keep the accounts worth working (Filter): keeps only the items that match a condition
…plus 3 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 Find who they are hiring).
Nodes used (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Apify
@apify/n8n-nodes-apify.apify - Remove Duplicates
n8n-nodes-base.removeDuplicates - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Filter
n8n-nodes-base.filter - Limit
n8n-nodes-base.limit - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow runs every Monday, reads target account domains from Google Sheets, uses Apify to collect each company’s current job postings, and uses OpenAI to score buying signals and draft short outreach openers, saving all results back to…