Block 1 - Append or update row in sheet1
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.7
This workflow is provided as-is. Please review and test before using in production.
Automatically scrape X (Twitter) for posts hiring specific roles (e.g., automation engineers, video editors, graphic designers), filter true hiring intent with AI, deduplicate in Google Sheets, and...
n8n-nodes-base.googlesheets, n8n-nodes-base.set, n8n-nodes-base.scheduletrigger, n8n-nodes-base.httprequest, n8n-nodes-base.telegram, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenai, n8n-nodes-base.googlesheetstool
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by A Z.
Original n8n.io sourceAutomatically scrape X (Twitter) for posts hiring specific roles (e.g., automation engineers, video editors, graphic designers), filter true hiring intent with AI, deduplicate in Google Sheets, and alert via Telegram.
Pulls recent X/Twitter posts for multiple role keywords via Apify.
Normalizes each post (text, author, links, location).
Uses an AI Agent to keep only posts where the author is hiring (not self-promo).
Checks Google Sheets for duplicates by URL before saving.
Writes qualified posts to a sheet and sends a Telegram notification.
We are using n8n automation roles as the example here
Schedule Trigger – Runs on an interval (currently every 12 hours).
Scrape X/Twitter – Apify tweet-scraper fetches up to 50 latest posts for keywords like: n8n developer, looking for n8n, n8n expert, hire AI automation, looking for AI automation.
Normalize Fields – Set node maps to: url, text, author.userName, author.url, author.location.
AI Filter & Dedupe Check
Gate – IF node passes only non-empty AI outputs.
Parse JSON Safely – Code node extracts/validates JSON from the AI output.
Save to Google Sheets – Appends/updates a row (matching on url).
Telegram Alert – Sends a message with the tweet URL, author, location, and text.
Freelancers, agencies, and job seekers who want a steady radar of real hiring posts for their target roles.
Swap keywords to track other roles (video editors, designers, copywriters, etc.).
Add Slack/Discord notifications.
Extend the AI rules (e.g., different geographies or role scopes).
Treat the sheet as a mini-CRM (status, outreach date, notes).
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
| Workflow | Monitor X/Twitter for hiring posts with Apify, AI filtering & Telegram alerts |
|---|---|
| Complexity | intermediate |
| Nodes | 13 |
| Categories | Lead Generation, AI Summarization |
| Author | A Z |
| Published | 27 Sept 2025 |
Use the JSON export at /data/workflows/9005/9005.json as the source template for this automation.
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Automatically scrape X (Twitter) for posts hiring specific roles (e.g., automation engineers, video editors, graphic designers), filter true hiring intent with AI, deduplicate in Google Sheets, and...
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation, AI Summarization use case.