Workflow Templates

How it works This workflow automates the curation and publishing of AI news to a Telegram channel. It follows a four-stage process: Aggregation: Monitors RSS feeds from VentureBeat and The AI Blog on a daily schedule. Filtering: Merges the feeds and uses a code snippet to select only the single most recent, high-quality article. Summarization: Sends the article data to Google Gemini, which generates a professional, emoji-rich summary formatted for social media. Human-in-the-loop Approval: Instead of auto-posting, it sends the draft to a private Telegram chat. The post is only published to the public channel once a human clicks "Approve." Set up steps Time estimate: 10–15 minutes. Credentials: You will need to connect your Google Gemini (PaLM) API key and your Telegram Bot API token. Telegram IDs: Ensure you have the Chat ID for both your private approval chat and your public destination channel. Schedule: The trigger is currently set to 3:56 PM daily; adjust this in the "Schedule Trigger" node to fit your preferred posting time.

Extract the audio from video for generate the description. Request to OpenAi for generate description with the audio extracted from the video. Generate in upload-post.com the token and add to the cred...

Who is this for This workflow is perfect for job seekers, recruiters, freelancers, and anyone actively monitoring job boards who wants to automate their search — getting instant Telegram alerts for new matching jobs without manually refreshing pages or missing time-sensitive postings. What this workflow does It automatically scrapes job posts from RSS feeds or job board APIs on a schedule, filters them by your target roles, locations, and keywords, deduplicates results against previously seen jobs stored in Google Sheets, and sends formatted Telegram alerts with job details and direct apply links for every new matching position. How it works Schedule Trigger runs every 6 hours (configurable) to check for new job posts. HTTP Request fetches job data from an RSS feed or job board API (default: RemoteOK). Parse & Extract normalizes raw data into clean job objects with title, company, location, URL, salary, tags, and posting date. Keyword Filter matches jobs against your configurable target roles, locations, and exclude terms — only relevant jobs pass through. Deduplication checks each job against a Google Sheet of previously seen jobs. Only truly new jobs continue. Log to Sheet saves every new job to Google Sheets for tracking and history. Telegram Alert sends a formatted message with job details, tags, salary, and a direct apply link. Setup steps Schedule — Adjust the interval in the Schedule Trigger node (default: every 6 hours). Set to every 1 hour for active searches. Job Source URL — Replace the URL in the HTTP Request node with your target job board RSS feed or API endpoint. Examples: RemoteOK (https://remoteok.com/api), Arbeitnow (https://www.arbeitnow.com/api/job-board-api), or any RSS feed from LinkedIn, Indeed, etc. Keywords — Edit the arrays in the Keyword Filter node: targetRoles, targetLocations, and excludeTerms. Google Sheets — Connect your Google Sheets OAuth credential. Create a spreadsheet with columns: Title, Company name, Location, Url, Description, Posted date, Salary, Matched Role, Scraped date. Set the spreadsheet ID in both Sheet nodes. Telegram — Create a bot via @BotFather, get your Chat ID, connect the Telegram credential, and set your Chat ID in the alert node. Test — Run the workflow manually once to verify jobs flow through correctly. Requirements Google Sheets account with OAuth credentials Telegram bot (created via @BotFather) with bot token and chat ID n8n instance (cloud or self-hosted) A job board with an RSS feed or public API How to customize Add multiple HTTP Request nodes for different job boards and merge results with a Merge node. Change the cron to every 1 hour for high-priority searches. Add salary range filtering in the keyword filter code. Replace Telegram with Slack, Discord, WhatsApp, or email alerts. Add an AI node (Ollama, OpenAI) to score and rank jobs by relevance before alerting. Adjust the Parse & Extract node field mappings when switching to a different job board API.

This workflow prevents your AI support bot from responding to every single message by intelligently aggregating rapid-fire messages from users before generating a comprehensive response. Who's it for Support teams and bot developers who want to provide better AI responses by letting users fully explain their issue before the bot responds, reducing unnecessary back-and-forth and improving response quality. How it works When a user sends a message to your Telegram bot, the workflow: Checks if the user has an active session within the last 60 seconds If no session exists, creates a new one and starts a 60-second timer If a session is active, appends the new message to the existing conversation After 60 seconds of the first message, fetches all aggregated messages Sends the complete conversation to OpenAI for a comprehensive response Delivers the AI-generated answer back to the user via Telegram Clears the session for the next interaction Requirements Telegram bot token (set up via BotFather) OpenAI API key PostgreSQL database with a user_sessions table containing columns: user_id, session_id, messages (jsonb array), first_message_at, wait_expires_at, status, and resume_url n8n instance (self-hosted or cloud) How to set up Configure your Telegram credentials in the Telegram Trigger node Add your OpenAI API key to the OpenAI Chat Model node Set up PostgreSQL credentials and create the required database table Adjust the wait time (default 60 seconds) in the Wait node if needed Activate the workflow and test with your Telegram bot How to customize Modify the aggregation window by changing the wait duration Customize the AI prompt in the AI Agent node for different response styles Add additional logic to handle specific keywords or commands Integrate other AI models or add context from external sources

Meet your new automated Sales Manager. This workflow acts as a relentless but helpful AI Sales Coach that lives inside your n8n. It wakes up every morning, scans your Notion CRM for deals that have been neglected, and uses OpenAI to send personalized, context-aware "nudges" directly to the specific sales agent responsible via Telegram. 💡 Why use this? Stop Generic Spam:* Unlike dumb bots that blast the whole channel, this workflow maps Notion Users to Telegram Handles to tag the *exact person responsible (e.g., "@alex, wake up!"). Context-Aware AI:** The AI reads the deal details. It gets "greedy" for high-value deals and "sarcastic" for long silences. Zero Management:** It runs on autopilot, ensuring no lead slips through the cracks. ⚙️ How it works Data Sync: Fetches your "Agents" database (Notion User ↔ Telegram ID) and "Active Deals". Logic Core: Calculates exactly how many days a lead has been untouched. Smart Routing: Matches the Assigned Manager in Notion to their Telegram ID. AI Generation: Generates a punchy message based on the deal's value and stage. Delivery: Sends the notification to Telegram with a direct link to the Notion deal. 🛠 Setup Steps Get the Notion System This workflow requires a specific database structure to map Agents and Deals. 👉 Click here to duplicate the Notion Template Connect Databases In the "Get Agents" node, select your duplicated Agents Configuration database. In the "Get Active Leads" node, select your duplicated Active Deals database. Configure Settings Open the 📝 CONFIGURATION node to set: DAYS_INACTIVE_LIMIT: How many days of silence before alerting? (default: 7). COACH_PERSONA: Customize the AI's personality (e.g., "Tough Boss" or "Friendly Helper"). TELEGRAM_CHAT_ID: A fallback chat for unassigned leads. Connect Accounts Add your credentials for Notion, OpenAI, and Telegram.

🤖 This n8n workflow automatically posts new articles from an RSS feed to your Telegram channel. It enhances article text using AI, adds a branded watermark to the article image, and keeps your channel updated with fresh and consistent content. Use Cases Automatically publish RSS feed updates to Telegram. Use AI to rewrite, summarize, or stylize text. Add watermarked visuals to keep your content on-brand. Perfect for news aggregators, media channels, and content creators. How It Works RSS Trigger: Monitors an RSS feed for new articles. Check Google Sheet: Compares links to avoid reposting. Fetch Article: Retrieves the full article content for new links. AI Enhancement: Uses an AI agent to improve readability and engagement. Image Watermarking: Fetches the main image and adds a watermark. Telegram Publishing: Sends the final AI-enhanced post to your Telegram channel. Setup Steps Google Sheet:** Create and share a sheet to store processed links. RSS Source:** Add your feed URL to the RSS Trigger node. AI Agent:** Configure a prompt and model (e.g., OpenRouter or Gemini). Telegram Bot:** Add your bot token and chat ID for message delivery. Test & Automate:** Run once manually, then let it update automatically. Tips You can tweak the AI prompt to match your tone (e.g., newsy, casual, concise). Adjust watermark placement, font, and color for brand consistency. AI models may have usage costs or regional restrictions. ✅ Key Advantage: Fully automated — from RSS feed detection to AI-enhanced publishing with branded visuals.

Auto-post curated remote jobs to Telegram with BrowserAct & Gemini This workflow acts as an intelligent job board curator for your Telegram community. It scrapes multiple sources (Remotive, SimplyHired), uses AI to filter out spam and low-quality listings, formats the best jobs into professional posts, and publishes them automatically on a schedule. Target Audience Community managers running job boards, recruiters, and developers building niche job aggregators. How it works Scheduled Fetch: Every 12 hours, the workflow triggers BrowserAct to scrape the latest job listings from Remotive and SimplyHired in parallel. Merge & Aggregate: The raw job data from both sources is combined into a single list. AI Curation: An AI Agent (using Google Gemini) reviews each job. It removes duplicates, filters out gigs paying less than $20/hr, and discards low-quality descriptions. Format Content: The AI rewrites the remaining jobs into clean, engaging HTML summaries suitable for Telegram. Publish: The workflow loops through the curated list and sends each job to your Telegram channel, pausing between messages to avoid rate limits. How to set up Configure Credentials: Connect your Telegram, BrowserAct, and Google Gemini accounts in n8n. Prepare BrowserAct: Ensure you have the Automated Remote Job Fetching & Filtering for Telegram Feed templates (for Remotive and SimplyHired) saved in your BrowserAct account. Configure Telegram: Ensure your bot is an admin in the target channel and add the Chat ID to the Send a text message node. Activate: Turn on the workflow. Requirements BrowserAct* account with the *Automated Remote Job Fetching & Filtering for Telegram Feed** templates. Telegram** account (Bot Token). Google Gemini** account. How to customize the workflow Add More Sources: Duplicate the BrowserAct nodes to scrape additional sites like We Work Remotely or LinkedIn. Refine Filters: Update the system prompt in the AI Agent node to filter by specific keywords (e.g., "Python", "Senior") or locations. Change Frequency: Adjust the Schedule Trigger to run more or less frequently depending on your needs. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video Build an AI-Powered Remote Job Aggregator (Remotive & SimplyHired)

📉 Buy the Dip Alert (Telegram/Slack/SMS) 📌 Overview This workflow automatically notifies you when Bitcoin or Ethereum drops more than a set percentage in the last 24 hours. It’s ideal for traders who want to stay ready for buy-the-dip opportunities without constantly refreshing charts. ⚙️ How it works Schedule Trigger — runs every 30 minutes (adjustable). HTTP Request (CoinGecko) — fetches BTC & ETH prices and 24h % change. Code Node (“Dip Check”) — compares changes against your dip threshold. IF Node — continues only if dip condition is true. Notification Node — sends alert via Telegram, Slack, or SMS (Twilio). Example Output: Dip Alert — BTC –3.2%, ETH –2.8% Not financial advice. 🛠 Setup Guide 1) Dip threshold Open the Code node. Change the line: const DIP = -2.5; // trigger if 24h drop <= -2.5% Set your preferred dip value (e.g., –5 for a 5% drop). 2) Choose your alert channel Telegram: add your bot token & chat ID. Slack: connect Slack API & set channel name. Twilio: configure SID, token, from/to numbers. 3) Test Temporarily set DIP to 0 to force an alert. Run once from the Code node → confirm alert message text. Execute the Notification node → confirm delivery to your channel. 🎛 Customization Cadence: change Schedule Trigger (every 5m, 15m, hourly, etc.). Coins: extend the CoinGecko call (add solana, bnb) and update Code node logic. Multiple alerts: duplicate IF → Notification branch for different thresholds (minor vs major dip). Combine with “Threshold Alerts” workflow to cover both upside breakouts and downside dips. Storage: log alerts into Google Sheets for tracking dip history. 🧩 Troubleshooting No alerts firing: check CoinGecko API response in Execution Data. Wrong %: CoinGecko returns usd_24h_change directly — no math needed. Duplicate alerts: add a debounce using a Sheet/DB to store last fired time. Telegram not posting: confirm bot has access to your channel/group.

GiggleGPTBot — Witty Telegram Bot with AI & Postgres 📝 Overview GiggleGPTBot is a witty Telegram bot built with n8n, OpenRouter, and Postgres. It delivers short jokes, motivational one-liners, and playful roasts, responds to mentions, and posts scheduled witty content. The workflow also tracks user activity and provides lightweight statistics and leaderboards. ✨ Features 🤖 AI-powered humor engine — replies with jokes, motivation, random witty lines, or sarcastic roasts. 💬 Command support — /joke, /inspire, /random, /roast, /help, /stats, /top. 🎯 Mention detection — replies when users tag @GiggleGPTBot. ⏰ Scheduled posts — morning jokes, daily motivation, and random wisdom at configured times. 📊 User analytics — counts messages, commands, reactions, and generates leaderboards. 🗄️ Postgres persistence — robust schema with tables for messages, responses, stats, and schedules. 🛠️ How It Works Triggers Telegram Trigger — receives all messages and commands from a chat. Schedule Trigger — runs hourly to check for planned posts. Processing Switch routes commands (/joke, /inspire, /random, /roast, /help, /stats, /top). Chat history fetches the latest context. Mention Analysis determines if the bot was mentioned. Generating an information response builds replies for /help, /stats, /top. AI nodes (AI response to command, AI response to mention, AI post generation) craft witty content via OpenRouter. Persistence Init Database ensures tables exist (user_messages, bot_responses, bot_commands, message_reactions, scheduled_posts, user_stats). Logging nodes update stats and store every bot/user interaction. Delivery Replies are sent back via Telegram Send nodes (Send AI response, Send info reply, Reply to Mention, Submit scheduled post). ⚙️ Setup Instructions Create a Telegram Bot with @BotFather and get your API token. Add credentials in n8n: Telegram API (your bot token) OpenRouter (API key from openrouter.ai) Postgres (use your DB, Supabase works well). Run the Init Database node once to create all required tables. (Optional) Seed schedule with the Adding a schedule node — it inserts: Morning joke at 06:00 Daily motivation at 09:00 Random wisdom at 17:00 (Adjust chat_id to your group/channel ID.) Activate workflow and connect Telegram Webhook or Polling. 📊 Database Schema user\_messages** — stores user chat messages. bot\_responses** — saves bot replies. bot\_commands** — logs command usage. message\_reactions** — tracks reactions. scheduled\_posts** — holds scheduled jokes/wisdom/motivation. user\_stats** — aggregates per-user message/command counts and activity. 🔑 Example Commands /joke → witty one-liner with light irony. /inspire → short motivational phrase. /random → unexpected witty remark. /roast → sarcastic roast (no offensive targeting). /stats → shows your personal stats. /top → displays leaderboard. /help → lists available commands. @GiggleGPTBot + message → bot replies in context. 🚀 Customization Ideas Add new command categories (/quote, /fact, /news). Expand analytics with reaction counts or streaks. Localize prompts into multiple languages. Adjust CRON schedules for posts. ✅ Requirements Telegram Bot token OpenRouter API key Postgres database 📦 Import this workflow, configure credentials, run the DB initializer — and your witty AI-powered Telegram companion is ready!

How It Works Telegram Trigger → Sub-Workflow (Separate Text/Files) → IF (Is PDF?) ├── True: Extract PDF → Set Text → Code (Clean) → Done! └── False: NoOp (Ignore) 9 nodes**: Lightweight, efficient (no loops). Key Steps**: Triggers on Telegram messages - downloads files. Sub-workflow splits text/files. (Optional but recommended) IF node checks MIME type/extension for PDFs. Extracts text via "Extract From File" node. AI writes summary. Responds to user. Setup Instructions IMPORTANT* : Requiring an n8n instance to be configured with public/production webhook ! Recommendation: Ngrok or Cloudflare Tunnel Add the Telegram credential Go to Credentials → New Credential → Telegram API. Paste your Bot Token. Configure the Trigger Open the Telegram Trigger node. Ensure Trigger On contains Message. Enable Download under Additional Fields so file payloads are attached to the node output. (Optional) Enable the sub‑workflow Automate Telegram Message Processing - Separate Text and Files 💬📁 If you need both message text and attachments, enable the Automate Telegram Message Processing – Separate Text and Files node and import the referenced workflow into your workspace. Deploy the workflow and activate it. Testing Send a message with a PDF attachment to your Telegram bot. There will be a response from the chat that summarizes the PDF content. Nodes Used Telegram Trigger**: Listens for incoming messages and downloads attachments. Execute Workflow**: Calls a sub-workflow to separate text and file data (recommended for reliable file handling). If**: Checks MIME type to ensure the file is a PDF. Extract From File**: Converts the PDF binary into text. Set**: Assignments to organize the text data. Code**: Cleans the text (removes excess newlines) to prepare it for the LLM. Basic LLM Chain**: Orchestrates the AI prompt and processing. AI Chat Model**: The specific LLM provider used for high-speed inference. Telegram**: Sends the final summary back to the user. Output Example The bot will reply with a message formatted like this: > Title: Q3 Financial Report > Type: Financial Report > Exec Summary: Revenue increased by 15% due to new product lines... > Key Insights: > • Growth in APAC region. > • Reduced operational costs by 5%. 🙏 Thank You for Trying This Workflow! Your time and trust mean a lot! I truly appreciate you using this template. Your feedback shapes future updates: 💡 Suggestions for improvement 🆕 Ideas for new features 📝 Requests for other automation workflows Please share your thoughts! Every idea helps shape the next update. 🙋‍♂️ Join & Follow For More Free Templates! Discord Community: We Work Together Get help, share builds, collaborate! Daily tips, tutorials, and updates Thank you again for being part of this journey! 🚀 Together, we automate better! 🤖✨

This workflow automates the process of monitoring Twitter accounts for intelligence gathering. It fetches new tweets from specified accounts via RSS, uses a powerful AI model (Google Gemini) to analyze the content based on your custom prompts, and sends formatted alerts to a Telegram chat for high-priority findings. Key Features: Scheduled Execution: Runs automatically at your desired interval. Dynamic Configuration: Manage which Twitter accounts to follow and what AI prompts to use directly from a Postgres database. AI-Powered Analysis: Leverages Google Gemini to extract summaries, keywords, and assign an importance level to each tweet. Duplicate Prevention: Keeps track of the last processed tweet to ensure you only get new updates. Customizable Alerts: Sends well-structured and easy-to-read notifications to Telegram. Setup Required: Postgres Database: Set up a table to store your configuration (see the Sticky Note in the workflow for the required schema). RSSHub: You need access to an RSSHub instance to convert Twitter user timelines into RSS feeds. Credentials: Add your credentials for Postgres, Google AI (Gemini), and your Telegram Bot in n8n. Configuration: Update the placeholder values in the RSS and Telegram nodes (e.g., your RSSHub URL, your Telegram Chat ID).

MLB "Hits" Workflow — Overview • Pulls today's MLB schedule incl. probablePitcher + lineups (statsapi.mlb.com) • Batches season stats for all involved players • Builds pitcher vs. batter matchup rows Setup Steps: 1) Google Sheets OAuth2 → point to your Google Sheet → Tab name 2) Create Telegram Bot cred + chatId 3) Optional: tweak ERA/OPS thresholds or Top N in nodes 6 or 8. Optional Setup: Conditional Formatting in the Sheet for ColorScale on best stat in the column, as well as Lefty vs Right highlighting. COMING SOON! Results Tracker tab and Apps Scripts and formulas.**