by Ninja - Abbas
Overview This workflow automates quiz delivery from a Google Sheet directly into a Telegram group. It ensures that quizzes are posted one by one as polls, and once a quiz is sent, its status in the sheet is automatically updated to prevent duplication. If no pending quiz is available, the workflow notifies a separate Telegram channel to refill the sheet. Target Audience This template is designed for teachers, community managers, and Telegram group admins who want an easy way to run quizzes, trivia games, or knowledge checks without manual posting. Problem It Solves Manually sending quizzes is repetitive and prone to mistakes (like re-posting the same question). This template ensures quizzes are sent in order, tracked, and managed automatically with minimal human effort. Requirements An active Google account with Google Sheets enabled A Telegram bot token (via BotFather) Chat IDs for both the quiz group and the notification group Google Sheet Structure Create a sheet with the following columns: quiz_number | question | option_a | option_b | option_c | option_d | status status**: Use 🟨 for pending quizzes, ✅ once completed Setup Instructions Copy the workflow into your n8n instance. Add your Google Sheets credentials. Replace the YOUR_SHEET_ID placeholder with your sheet ID. Set environment variables: TELEGRAM_BOT_TOKEN TELEGRAM_CHAT_ID (for the group) TELEGRAM_NOTIFY_CHAT_ID (for refill notifications) Run the workflow. Customization Options Adjust the sheet name if not using “Sheet1” Change emoji markers (🟨 / ✅) to your preferred system Modify the Telegram notification message
by Vasyl Pavlyuchok
What this template does This workflow turns the arXiv AI feed into a daily research assistant. Every morning it fetches the latest Artificial Intelligence papers from arXiv.org, deduplicates them, stores one page per paper in Notion (with metadata + PDF link), generates a Deep Research Summary of each PDF using Gemini, and finally posts a short update to a Telegram channel with links to both the paper and the Notion summary. Who is this for & what problem it solves This template is designed for founders, researchers, builders and curious professionals who want to stay up-to-date with AI research without reading every paper in full. It solves the “information overload” problem: instead of manually checking arXiv and skimming PDFs, you get a curated daily feed with human-style explanations stored in your own Notion database. Use Cases Daily AI research digest for solo founders or small teams. Private “AI research hub” in Notion for your company or lab. Telegram channel that shares the latest AI papers plus plain-English summaries. Personal learning pipeline: track, tag and revisit important papers over time. How it works (workflow overview) Scheduled trigger runs every day at 08:00. HTTP Request pulls the latest AI papers from arXiv’s API. Results are converted from XML to JSON and cleaned. A time-window filter keeps only recent papers and removes duplicates. For each paper, a Notion page is created (metadata + PDF URL). Gemini reads the PDF and returns a structured, multi-chunk summary. Each chunk is appended to the same Notion page as rich-text blocks. A Telegram message is sent with title, short abstract, PDF link and Notion link. Setup (step-by-step) Create a Notion database and connect your Notion integration. Map the properties in the Register to Notion Database node (title, arxiv_id, abstract, authors, categories/tags, published date, pdf URL). Add your Gemini API key and model in the Analyze doc (Prompt Ultra-Pro) node. Add your Telegram bot token and chat_id in the Send a text message node. (Optional) Adjust the arXiv query in HTTP Request to focus on your preferred AI categories or keywords. Enable the Scheduled Daily Trigger when you’re ready to run it in production. Customization options Change the arXiv search query (keywords, categories, max_results). Modify the time window logic (e.g. 24h, 48h, or no filter). Adapt the Notion properties to your own schema (status, tags, priority, etc.). Switch the messaging channel (Telegram, Discord, Slack) using similar nodes.
by Yves Tkaczyk
Automated image processing for e-commerce product catalog Use cases Monitor a Google Drive folder, process each image based on the prompt defined in Workflow Configuration and save the new image to the specified output Google Drive folder. Maintain a processing log in Google Sheets. 👍 This use case can be extended to any scenario requiring batch image processing, for example, unifying the look and feel of team photos on a company website. How it works Trigger: Watches a Google Drive folder for new or updated files. Downloads the image, processes it using Google Gemini (Nano Banana), and uploads the new image to the specified output folder. How to use Google Drive and Google Sheets nodes: Create Google credentials with access to Google Drive and Google Sheets. Read more about Google Credentials. Update all Google Drive and Google Sheets nodes (6 nodes total) to use these credentials Gemini AI node: Create Google Gemini(PaLM) Api credentials. Read more about Google Gemini(PaLM) credentials. Update the Edit Image node to use the Gemini Api credentials. Create a Google Sheets spreadsheet following the steps in Google Sheets Configuration (see right ➡️). Ensure the spreadsheet can be accessed as Editor by the account used for the Google Credentials. Create input and output directories in Google Drive. Ensure these directories are accessible by the account used for the credentials. Update the File Created, File Updated and Workflow Configuration node following the steps in the green Notes (see right ➡️). Requirements Google account with Google API access Google AI Studio account with ability to create a Google Gemini API key. Basic n8n knowledge: understanding of triggers, expressions, and credential management Who’s it for Anyone wanting to batch process images for product catalog. Other use cases are applicable. Please reach out reach out if you need help customizing this workflow. 🔒 Security All credentials are stored securely using n8n's credential system. The only potentially sensitive information stored in the workflow is the Google Drive folder and Sheet IDs. These should be secured according to your organization’s needs. Need Help? Reach out on LinkedIn or Ask in the Forum!
by Patrick Jennings
Sleeper NFL Team Chatbot Starter A Telegram chatbot built to look up your fantasy football team in the Sleeper app and return your roster details, player names, positions, and team info. This starter workflow is perfect for users who want a simple, conversational way to view their Sleeper team in-season or pre-draft. What It Does When a user types their Sleeper username into Telegram, this workflow: Extracts the username from Telegram Pulls their Sleeper User ID Retrieves their Leagues and selects the first one (by default) Pulls the full league Rosters Finds the matching roster owned by that user Uses player_ids to look up full player info from a connected database (e.g. Airtable or Google Sheets) Returns a clean list of player names, positions, and teams via Telegram Requirements To get this running, you’ll need: A Telegram bot (set up through BotFather) A Sleeper Fantasy Football account A synced player database that matches player_id to full player details (we recommend using the companion template: Sleeper NFL Players Daily Sync) Setup Instructions Import the workflow into your n8n instance Add the required credentials: Telegram (API Key from BotFather) Airtable (or replace with another database method like Google Sheets or HTTP request to a hosted JSON file) Trigger the workflow by sending your exact Sleeper username to the bot Your full team roster will return as a formatted message > If the user is in multiple Sleeper leagues, the current logic returns the first league found. Example Output You have 19 players on your roster: Cam Akers (RB - NO), Jared Goff (QB - DET), ... Customization Notes Replace Telegram Trigger with any other input method (webhook, form input, etc.) Replace Airtable node with Google Sheets, SQL DB, or even a local file if preferred You can hardcode a Sleeper username if you're using this for a single user Related Templates Sleeper NFL Players Daily Sync (syncs player_id to player name, position, team) -Create Player Sync first then either integrate it to this template or reate a subworkflow from it & use most recent data set. Difficulty Rating & Comment (from the author) 3 out of 10 if this ain't you're first rodeo, respectfully. Just a little bit more work on adding the Players Sync as your data table & knowing how to GET from Sleeper. If you use Sleeper for fantasy football, lets go win some games!
by Harry Gunadi Permana
Get Forex Factory News Release to Telegram, Google Sheets. Record News Data and Live Price from MyFxBook for Affected Currency Pairs. This n8n template demonstrates how to capture Actual Data Releases as quickly as possible for trading decisions. Use cases: Get notified if the actual data release is positive or negative for the relevant currency. Use the Telegram chat message about the news release as a trigger to open a trading position in MetaTrader 4. Record news data and live price to google sheets for analysis. Currency Pairs EURUSD, GBPUSD, AUDUSD, NZDUSD, USDJPY, USDCHF, USDCAD, XAUUSD How it works A news release event acts as the trigger. Only news with a numerical Forecast value will be processed. Events that cannot be measured numerically (e.g., speeches) are ignored. Extract news details: currency, impact level (high/medium), release date, and news link. Wait 10 seconds to ensure the Actual value is available on the news page. Scrape the Actual value from the news link using Airtop. If the Actual value is not available, wait another 5 seconds and retry scraping. Extract both Actual and Forecast values from the scraped content. Remove non-numeric characters (%, K, M, B, T) and convert values to numbers. Determine the effect: If the Actual value is lower than the Forecast value (and lower is better), send it to the True branch. Otherwise, send it to the False branch. Record news data and live price from MyFxBook to Google Sheets. How to use Enter all required credentials. Create or Download Google Sheets file like this in your Google Drive: https://docs.google.com/spreadsheets/d/1OhrbUQEc_lGegk5pRWWKz5nrnMbTZGT0lxK9aJqqId4/edit?usp=drive_link Run the workflow. Requirements Google Calendar credentials Airtop API key Telegram Chat ID Telegram Bot API token Enable Google Drive API in Google Cloud Console Google Sheets credentials Need Help? Join the Discord or ask in the Forum! Thank you! Update Sept 26, 2025: Add new edit node
by Femi Ad
Transform your daily business inspiration routine by automatically receiving curated business ideas from IdeaBrowser directly in Telegram. This workflow scrapes the "Idea of the Day" content and delivers it to your Telegram chat with beautiful formatting and smart content handling. Description This n8n workflow template automates the process of fetching and delivering daily business ideas from IdeaBrowser's "Idea of the Day" page to your Telegram chat. Perfect for entrepreneurs, business analysts, and innovation teams who want to stay updated with fresh business concepts without manual checking. Key Features: Automated Daily Delivery: Runs every day at 9:00 AM to fetch the latest business idea Smart Content Extraction: Uses advanced HTML parsing to extract title, description, pricing model, target market, and key features Intelligent Message Formatting: Creates beautifully formatted Telegram messages with emojis and structured content Message Length Handling: Automatically truncates long content to fit Telegram's character limits Manual Testing: Includes a manual trigger for testing before scheduling Error Resilience: Built-in error handling to ensure reliable operation What Gets Delivered: 🚀 Daily business idea title with date 💡 Business description and concept 💰 Revenue model and pricing strategy 🎯 Target market analysis ⚡ Key features and benefits 🔗 Direct link to full details Prerequisites Before using this template, ensure you have: Telegram Bot: Create a bot using @BotFather on Telegram Chat ID: Obtain your Telegram chat ID (use @userinfobot) n8n Instance: Running n8n installation (cloud or self-hosted) Setup Instructions Import the Workflow: Copy the JSON below and import it into your n8n instance Configure Telegram Credentials: Add your Telegram bot token in n8n credentials Update the chat ID in both Telegram nodes Test the Workflow: Use the "Manual Test Trigger" to verify everything works Activate: Enable the workflow to start receiving daily ideas at 9:00 AM
by Pavlo Hurhu
Problem This Solves Content creators, digital marketers, and website owners struggle with the time-consuming process of creating fresh, SEO-optimized blog content consistently. Manually writing articles, researching keywords, and maintaining a regular publishing schedule can take hours per piece of content. Target Audience This workflow is perfect for: Bloggers and Content Creators** who want to repurpose video content into written articles Content Marketing Agencies** managing multiple client websites Digital Marketing Teams** looking to scale their content production Small Business Owners* who need *regular blog content** but lack time or writing resources SEO Specialists** seeking to maximize content output while maintaining quality YouTube Channel Owners** who want to expand their content reach across different platforms What This Workflow Does This n8n automation transforms popular YouTube videos into high-quality, SEO-optimized articles that appear completely human-written. The workflow intelligently selects trending content from your chosen YouTube channels, transcribes the videos, and uses advanced AI to craft engaging articles optimized for search engines. How it works The user selects YouTube channels from which the workflow retrieves the most popular videos. The videos are transcribed and converted into SEO-optimized articles. Generated articles are automatically published to your WordPress website. Set up steps Connect your Google Account to all YouTube nodes. Integrate your Supadata account. Customize White-labeled prompt in the 'Compose Article' node according to your brand. Configure the 'Create WordPress Post' node with your WordPress website API. Set your target YouTube channels and activate the workflow. Detailed instructions and tutorials can be found in the workflow's sticky notes. Requirements Google account. supadata.ai account (used for video transcription). Anthropic subscription (GPT models are also supported, but I personally recommend using Anthropic Claude Sonnet 4 for text generation).
by Hermon
Trello Task-Sync Assistant Description This n8n workflow automates task management by integrating Trello, Supabase, and Telegram to streamline card creation, user assignment, and due date notifications. It ensures seamless synchronization of Trello card data with a Supabase database and sends timely Telegram notifications to keep team members informed about task assignments and deadlines. Key Features Trello Card Syncing**: Automatically registers new Trello cards in Supabase and keeps card details (e.g., due dates, URLs) updated. User Management**: Tracks Trello user assignments in Supabase, creating new user entries and linking them to cards as needed. Real-Time Notifications**: Sends Telegram messages when users are added to or removed from Trello cards, using dynamic, engaging message templates. Due Date Reminders**: Schedules daily checks to notify users via Telegram about tasks due on the current day. Workflow Structure Trello Trigger Flow: Trigger: Activates when a new Trello card is created. Actions: Registers the card in Supabase (cards table) with details like ID, name, and board. Sets up a Trello webhook for real-time updates on the card. Syncs due date changes to Supabase. Detects member additions/removals, checks for existing users in Supabase, creates new user entries if needed, and links users to cards in the card_user table. Webhook Event Flow: Trigger: Processes Trello webhook events (e.g., member changes, due date updates). Actions: Validates event types (add/remove member). Maps Trello usernames to Telegram handles. Sends formatted Telegram notifications with card details and playful, randomized messages for engagement. Due-Date Notification Flow: Trigger: Runs twice daily (every 12 hours) via a scheduled trigger. Actions: Fetches cards due on the current day from Supabase. Retrieves assigned users for each card. Sends Telegram reminders with urgent, formatted messages including card name, board, URL, and due date. Technical Details Tools Used**: Trello: Triggers on card creation and updates via webhooks. Supabase: Stores card, user, and card-user relationship data in cards, users, and card_user tables. Telegram: Sends notifications using a bot. Credentials Required**: Trello API key and token. Supabase URL and key. Telegram bot token and chat ID. Scheduling**: Due date checks run every 12 hours (adjustable). Error Handling**: Includes checks for user existence and conditional logic to manage add/remove events. Use Case Ideal for teams using Trello for project management, this workflow ensures real-time data syncing with Supabase and keeps members informed via Telegram, reducing manual oversight and improving task accountability. It’s particularly useful for remote or distributed teams needing automated task tracking and reminders. Setup Requirements Configure Trello webhooks to point to the n8n webhook URL. Set up Supabase with the required tables (cards, users, card_user). Provide Telegram bot token and chat IDs Test the workflow by creating a Trello card, assigning a member, and setting a due date to verify Supabase entries and Telegram notifications. This workflow enhances productivity by automating task synchronization and communication, ensuring no deadline is missed.
by Sarry
This workflow acts as an AI assistant for your Telegram groups, automatically creating a "Daily Digest" of all conversations so you can catch up without scrolling through hundreds of messages. It's perfect for community managers, project teams, or groups of friends who want to stay updated without the noise. How it works This workflow runs on a simple, high-level process: Fetches Messages: Once every 24 hours, it automatically fetches all new messages from any group your bot is a member of. Generates AI Summary: It sends the chat transcript to Google's Gemini 1.5 Flash AI, which intelligently creates a structured summary including key topics, shared links, and unanswered questions. Posts the Digest: The clean, formatted summary is posted back into the correct Telegram group for everyone to see. For more detailed explanations of each specific node, please refer to the sticky notes included on the workflow canvas. Set up steps Setup should take about 5-10 minutes. Prerequisites Telegram Bot Token:** You can get this by talking to the @BotFather on Telegram. Google Gemini API Key:** You can get a free API key from the Google AI Studio. Configuration Add Credentials & Token In the Get Telegram Updates node, paste your Telegram bot token into the URL. In the Generate Summary with Gemini and Post Digest to Telegram nodes, select your Google Gemini and Telegram credentials from the dropdown menus. Configure Your Telegram Bot Using @BotFather in Telegram, make sure Group Privacy Mode is turned OFF for your bot. This is required for the bot to read messages. Add your bot as a member to any group you want it to summarize. Activate the Workflow In the n8n editor, click the "Inactive" toggle at the top of the screen to set the workflow to Active.
by Aziz dev
Description This workflow automates the daily reporting of Google Ads campaign performance. It pulls click and conversion data from the Google Ads API, merges both datasets, and stores the results into Notion databases and Google Sheets. It includes a campaign-level log and a daily performance summary. The workflow is triggered automatically every day at 08:00 AM, helping marketing teams maintain a consistent and centralized reporting system without manual effort. How It Works Scheduled Trigger at 08:00 AM The workflow begins with a Schedule Trigger node that runs once per day at 08:00. Set Yesterday’s Date The Set node defines a variable for the target date (yesterday), which is used in the API queries. Query Google Ads API – Clicks & Cost The first HTTP request pulls campaign-level metrics: campaign.id, campaign.name metrics.clicks, metrics.impressions, metrics.cost_micros Query Google Ads API – Conversions The second HTTP request pulls conversion-related data: metrics.conversions, segments.conversion_action_name Split and Merge Both responses are split into individual campaign rows and merged using: campaign.id segments.date Store Campaign-Level Data Stored in Notion database: "Google Ads Campaign Tracker" Appended to Google Sheets tab: "Campaign Daily Report" Generate Daily Summary A code node calculates daily totals across all campaigns: Total impressions, clicks, conversions, cost Unique conversion types The summary is stored in: Notion database: "Google Ads Daily Summary" Google Sheets tab: "Summary Report" Setup Steps 1. Schedule the Workflow The workflow is triggered using a Schedule Trigger node Set the schedule to run every day at 08:00 AM Connect it to the Set Yesterday Date node 2. Google Ads API Access Create a Google Ads developer account and obtain a developer token Set up OAuth2 credentials with Google Ads scope In n8n, configure the Google Ads OAuth2 API credential Ensure HTTP request headers include: developer-token login-customer-id Content-Type: application/json 3. Notion Database Setup Create two databases in Notion: Google Ads Campaign Tracker** Fields: Campaign Name, Campaign ID, Impressions, Clicks, Cost, Conversion Type, Conversions, Date Google Ads Daily Summary** Fields: Date, Total Impressions, Total Clicks, Total Conversions, Total Cost, Conversion Types Share both databases with your Notion integration 4. Google Sheets Setup Create a spreadsheet with two tabs: Campaign Daily Report → for campaign-level rows Summary Report → for daily aggregated metrics Match all column headers to the workflow fields Connect your Google account to n8n using Google Sheets OAuth2 Output Summary Notion Databases: Google Ads Campaign Tracker: stores individual campaign metrics Google Ads Daily Summary: stores daily totals and conversion types Google Sheets Tabs: Campaign Daily Report: per-campaign data Summary Report: aggregated daily performance
by TheStock
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.**
by Budi SJ
Smart POS System with Live Updates to Telegram & Sheets This Smart POS (Point of Sale) System template provides a lightweight yet powerful sales management solution. It features a modern web based interface for placing orders, with real time integration to Google Sheets and instant Telegram notifications, enhanced by AI-generated reports. Ideal for small businesses, mobile vendors, or anyone who needs a quick and smart POS system. ✨ Key Features 🖥️ Modern web interface with product catalog and search 🛒 Cart system with quantity, price, and discount handling 🆔 Unique Sales ID generation for every transaction 📊 Google Sheets integration to store product and sales data 🤖 AI-generated sales summary via OpenRouter 🚀 Instant Telegram notifications for new orders 🔧 Requirements A Google Sheet to store products and sales data 👉 Use this Google Sheets template to get started Telegram Bot Token and User ID (Create a bot via @BotFather) OpenRouter API Key (Sign up at openrouter.ai and use the LLM model) ⚙️ Setup Instructions Set Up Your Google Sheets Use the template and fill in product details in the products tab Configure Telegram Bot Create a bot via BotFather Obtain your Bot Token and Chat ID (message the bot once to get ID) Set Up AI Agent In the AI agent node, replace the placeholder with your actual OpenRouter API Key 🚀 Deploy the Workflow Activate the workflow in n8n Open the webhook URL to access the POS interface Enter product orders and customer details Submit the order Receive an instant Telegram notification with AI-generated sales summary Data is automatically saved to Google Sheets for tracking and analysis