{ "edges": [ { "to": "e4a986d2-4146-46bc-9ca8-d4acc07c9e52", "from": "4f0c0edc-ac12-41ff-9733-71df7f1ed66f", "toPort": "0", "fromPort": "0" }, { "to": "c7442722-6a28-4e0e-b8bd-09fc95cd6a2f", "from": "e4a986d2-4146-46bc-9ca8-d4acc07c9e52", "toPort": "0", "fromPort": "0" }, { "to": "b522f688-3201-468f-878c-96575adeef55", "from": "e4a986d2-4146-46bc-9ca8-d4acc07c9e52", "toPort": "0", "fromPort": "0" }, { "to": "ad8fa0da-5452-4de7-849c-56920740d38d", "from": "d8ed862b-a231-46ea-ba29-eeddb19a6b1e", "toPort": "0", "fromPort": "0" }, { "to": "4f0c0edc-ac12-41ff-9733-71df7f1ed66f", "from": "0745d915-2372-4ae4-af55-10f659327f68", "toPort": "0", "fromPort": "0" }, { "to": "0745d915-2372-4ae4-af55-10f659327f68", "from": "92929cdf-2771-4e86-bd78-9d1cd7c8c4ba", "toPort": "0", "fromPort": "0" }, { "to": "92929cdf-2771-4e86-bd78-9d1cd7c8c4ba", "from": "ad8fa0da-5452-4de7-849c-56920740d38d", "toPort": "0", "fromPort": "0" }, { "to": "0745d915-2372-4ae4-af55-10f659327f68", "from": "beae3b6b-780b-4fa8-836b-c17e9d1bfa73", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "0745d915-2372-4ae4-af55-10f659327f68", "from": "ff6f42d3-893c-453f-bf85-db69c094ad46", "toPort": "0", "fromPort": "ai_tool" } ], "nodes": [ { "id": "b522f688-3201-468f-878c-96575adeef55", "name": "Append or update row in sheet1", "type": "integration", "params": { "columns": { "value": { "url": "={{ $json.url }}", "text": "={{ $json.text }}", "author": "={{ $json.author.userName }}", "location": "={{ $json.author.location }}", "url author": "={{ $json.author.url }}" }, "schema": [ { "id": "url", "type": "string", "display": true, "removed": false, "required": false, "displayName": "url", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "text", "type": "string", "display": true, "required": false, "displayName": "text", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "author", "type": "string", "display": true, "removed": false, "required": false, "displayName": "author", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "url author", "type": "string", "display": true, "removed": false, "required": false, "displayName": "url author", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "location", "type": "string", "display": true, "removed": false, "required": false, "displayName": "location", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "url" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1b87NBYctXlv5e-cfjF8XrGgtfLElgnELyDBcumoM2bE/edit#gid=0", "cachedResultName": "X" }, "documentId": { "__rl": true, "mode": "list", "value": "1b87NBYctXlv5e-cfjF8XrGgtfLElgnELyDBcumoM2bE", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1b87NBYctXlv5e-cfjF8XrGgtfLElgnELyDBcumoM2bE/edit?usp=drivesdk", "cachedResultName": "X and threads" } }, "position": [ -832, 1584 ] }, { "id": "92929cdf-2771-4e86-bd78-9d1cd7c8c4ba", "name": "Edit Fields", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "946aeca1-2f8e-418d-9970-45a0c3c768c0", "name": "url", "type": "string", "value": "={{ $json.url }}" }, { "id": "9c6a1f7e-5975-47bf-bebd-42eab220ccf1", "name": "text", "type": "string", "value": "={{ $json.text }}" }, { "id": "1796f734-f0d9-430b-bce9-2c7fe9fa50c6", "name": "author.userName", "type": "string", "value": "={{ $json.author.userName }}" }, { "id": "dcbda70c-ce37-4c6e-971b-d25a0cc1ef59", "name": "author.url", "type": "string", "value": "={{ $json.author.url }}" }, { "id": "edaa24fe-eb31-4caa-a67f-2bfd6649752f", "name": "author.location", "type": "string", "value": "={{ $json.author.location }}" } ] } }, "position": [ -1888, 1680 ] }, { "id": "d8ed862b-a231-46ea-ba29-eeddb19a6b1e", "name": "6 hours", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "hours", "hoursInterval": 12 } ] } }, "position": [ -2336, 1680 ] }, { "id": "ad8fa0da-5452-4de7-849c-56920740d38d", "name": "HTTP Request", "type": "http", "params": { "url": "https://api.apify.com/v2/acts/apidojo~tweet-scraper/run-sync-get-dataset-items?", "method": "POST", "options": { "redirect": { "redirect": {} } }, "jsonBody": "{\n \"maxItems\": 50,\n \"searchTerms\": [\n \"n8n developer\", \n \"looking for n8n\",\n \"n8n expert\",\n \"hire AI automation\", \n \"looking for AI automation\"\n ],\n \"sort\": \"Latest\"\n}", "sendBody": true, "sendHeaders": true, "specifyBody": "json", "headerParameters": { "parameters": [ { "name": "Accept", "value": "application/json" }, { "name": "Authorization", "value": "Bearer " } ] } }, "position": [ -2112, 1680 ] }, { "id": "c7442722-6a28-4e0e-b8bd-09fc95cd6a2f", "name": "Send a text message1", "type": "integration", "params": { "text": "=Tweet URL: {{ $json.url }} \nAuthor:{{ $json.author.userName }}\nAuthor URL: {{ $json.author.url }}\nLocation:{{ $json.author.location }}\nText: {{ $json.text }}", "service": "telegram", "operation": "read", "additionalFields": {} }, "position": [ -832, 1744 ] }, { "id": "0745d915-2372-4ae4-af55-10f659327f68", "name": "AI Agent1", "type": "llm", "params": { "text": "=This is the text that you have to check {{ $json.text }}{{ $json.url }}{{ $json.author }}\n", "prompt": "=This is the text that you have to check {{ $json.text }}{{ $json.url }}{{ $json.author }}\n", "options": { "systemMessage": "= You are **Hiring Post Classifier & Extractor**. Read short social posts (Twitter/Threads), plus author bio and any link-preview text, and return **only** posts where the **author is hiring an n8n/AI automation engineer** in allowed geographies. Deduplicate against Google Sheets by `url`. If non-passing or duplicate → **output nothing**. \n\n\n\nInput (exact shape):\n\n{\n \"url\": \"https://twitter.com/... or https://www.threads.net/...\",\n \"text\": \"raw post text\",\n \"author\": {\n \"userName\": \"handle or display name\",\n \"url\": \"author profile url\",\n \"location\": \"free-text location from bio (optional)\"\n }\n}\n\n\nOutput: strict JSON (see ) for passing, non-duplicate posts; otherwise no output (empty response).\n\nNo extra fields, arrays, prose, or explanations.\n\n\n\n\n\nReduce tokens where ever possible\n\nHire-only by the author (no replies/retweets unless the author restates as the hirer).\nAccept only if text clearly signals an open n8n/AI automation engineer role.\nStrong hire cues (any): hiring, we’re hiring, opening, role, position, join our team, bring on an automation engineer, seeking n8n engineer, need an AI automation engineer, apply, send your portfolio/resume, email to, link to job.\nHelpful (not required): full-time, part-time, contract, paid, salary, compensation.\nRole scope (accept): n8n engineer, AI automation engineer, workflow automation engineer, automation developer (explicit n8n/AI automation duties), no-code/low-code automation engineer (with n8n/AI explicitly mentioned).\nExclude: generic software roles without automation focus; RPA-only if n8n/AI automation isn’t explicit; “consultant available” language (see self-promo).\n\nExclude self-promotion / service ads / bait.\nReject if the author markets themselves/services (e.g., “hire me,” “available for projects,” “my rates,” “portfolio/reel,” “DMs open to hire me,” “book me,” “client work,” “commissions,” “services”).\nIf the bio indicates the author is a freelancer for hire and the post is ambiguous → treat as self-promo → exclude.\n\nDeduplication (Google Sheets).\nAfter passing 1–3, query the sheet for the url. If found → no output. If not found → output JSON.\n\n\n\n\n\nmethod: find(url) → returns a match if the post url already exists\n\n\n\n\n\nConfirm author hiring signal for an n8n/AI automation engineer (not self-promo; not a reply/retweet unless restated).\n\nApply geo rules using post text, bio location, and link-preview text.\n\nIf pass, dedupe via Google Sheets on url.\n\nIf unique, emit strict JSON with minimal pass-through fields.\n\n\n For passing, non-duplicate posts, return **only**: ```json { \"url\": \"{{ $json.url }}\", \"text\": \"{{ $json.text }}\", \"username\": \"{{ $json.author.userName }}\", \"profile_url\": \"{{ $json.author.url }}\", \"location\": \"{{ $json.author.location }}\" } ``` Otherwise, **return nothing**. \n\n" }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "= You are **Hiring Post Classifier & Extractor**. Read short social posts (Twitter/Threads), plus author bio and any link-preview text, and return **only** posts where the **author is hiring an n8n/AI automation engineer** in allowed geographies. Deduplicate against Google Sheets by `url`. If non-passing or duplicate → **output nothing**. \n\n\n\nInput (exact shape):\n\n{\n \"url\": \"https://twitter.com/... or https://www.threads.net/...\",\n \"text\": \"raw post text\",\n \"author\": {\n \"userName\": \"handle or display name\",\n \"url\": \"author profile url\",\n \"location\": \"free-text location from bio (optional)\"\n }\n}\n\n\nOutput: strict JSON (see ) for passing, non-duplicate posts; otherwise no output (empty response).\n\nNo extra fields, arrays, prose, or explanations.\n\n\n\n\n\nReduce tokens where ever possible\n\nHire-only by the author (no replies/retweets unless the author restates as the hirer).\nAccept only if text clearly signals an open n8n/AI automation engineer role.\nStrong hire cues (any): hiring, we’re hiring, opening, role, position, join our team, bring on an automation engineer, seeking n8n engineer, need an AI automation engineer, apply, send your portfolio/resume, email to, link to job.\nHelpful (not required): full-time, part-time, contract, paid, salary, compensation.\nRole scope (accept): n8n engineer, AI automation engineer, workflow automation engineer, automation developer (explicit n8n/AI automation duties), no-code/low-code automation engineer (with n8n/AI explicitly mentioned).\nExclude: generic software roles without automation focus; RPA-only if n8n/AI automation isn’t explicit; “consultant available” language (see self-promo).\n\nExclude self-promotion / service ads / bait.\nReject if the author markets themselves/services (e.g., “hire me,” “available for projects,” “my rates,” “portfolio/reel,” “DMs open to hire me,” “book me,” “client work,” “commissions,” “services”).\nIf the bio indicates the author is a freelancer for hire and the post is ambiguous → treat as self-promo → exclude.\n\nDeduplication (Google Sheets).\nAfter passing 1–3, query the sheet for the url. If found → no output. If not found → output JSON.\n\n\n\n\n\nmethod: find(url) → returns a match if the post url already exists\n\n\n\n\n\nConfirm author hiring signal for an n8n/AI automation engineer (not self-promo; not a reply/retweet unless restated).\n\nApply geo rules using post text, bio location, and link-preview text.\n\nIf pass, dedupe via Google Sheets on url.\n\nIf unique, emit strict JSON with minimal pass-through fields.\n\n\n For passing, non-duplicate posts, return **only**: ```json { \"url\": \"{{ $json.url }}\", \"text\": \"{{ $json.text }}\", \"username\": \"{{ $json.author.userName }}\", \"profile_url\": \"{{ $json.author.url }}\", \"location\": \"{{ $json.author.location }}\" } ``` Otherwise, **return nothing**. \n\n", "hasOutputParser": true }, "position": [ -1664, 1680 ] }, { "id": "beae3b6b-780b-4fa8-836b-c17e9d1bfa73", "name": "OpenAI Chat Model1", "type": "llm", "params": { "model": "gpt-4.1-mini", "options": {}, "provider": "openai" }, "position": [ -1664, 1904 ] }, { "id": "ff6f42d3-893c-453f-bf85-db69c094ad46", "name": "Get row(s) in sheet in Google Sheets1", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1b87NBYctXlv5e-cfjF8XrGgtfLElgnELyDBcumoM2bE/edit#gid=0", "cachedResultName": "X" }, "documentId": { "__rl": true, "mode": "list", "value": "1b87NBYctXlv5e-cfjF8XrGgtfLElgnELyDBcumoM2bE", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1b87NBYctXlv5e-cfjF8XrGgtfLElgnELyDBcumoM2bE/edit?usp=drivesdk", "cachedResultName": "X and threads" } }, "position": [ -1536, 1904 ] }, { "id": "e4a986d2-4146-46bc-9ca8-d4acc07c9e52", "name": "Code1", "type": "code", "params": { "jsCode": "const results = [];\n\nfor (const item of $input.all()) {\n try {\n const rawData = item.json.output; // The raw string from the LLM\n\n // --- FIX IS HERE ---\n // Find the first opening curly brace '{'\n const firstBrace = rawData.indexOf('{');\n // Find the last closing curly brace '}'\n const lastBrace = rawData.lastIndexOf('}');\n\n // If both braces are found, extract the content between them\n if (firstBrace !== -1 && lastBrace !== -1) {\n const jsonString = rawData.substring(firstBrace, lastBrace + 1);\n\n // Now, parse the cleaned string\n const obj = JSON.parse(jsonString);\n\n results.push({ json: obj });\n }\n // --- END OF FIX ---\n\n } catch (error) {\n // This will catch any items that still fail to parse,\n // so the whole workflow doesn't stop for one bad item.\n console.error(\"Failed to parse an item:\", error);\n }\n}\n\nreturn results;\n" }, "position": [ -1088, 1680 ] }, { "id": "4f0c0edc-ac12-41ff-9733-71df7f1ed66f", "name": "If", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "d6b35f7a-4b86-4aa0-a826-c6992ad15da2", "operator": { "type": "string", "operation": "notEmpty", "singleValue": true }, "leftValue": "={{ $json.output }}", "rightValue": "={}" } ] } }, "position": [ -1312, 1680 ] } ] }

Monitor X/Twitter for hiring posts with Apify, AI filtering & Telegram alerts