Workflow Templates

Automate AI News Filtering with Keywords to Telegram This n8n template helps you stay up-to-date by automatically filtering news and sending relevant articles to Telegram using an AI Agent. This workflow is perfect for content marketers, journalists, or researchers who need to find specific articles without manually sifting through countless news feeds. Steps to Take Create BrowserAct Workflow:* Set up the *News Content Marketing Automation** template in your BrowserAct account. Add BrowserAct Token:* Connect your BrowserAct account credentials to the *HTTP Request* inside *Run Node**. Update Workflow ID:* Change the workflow_id value in the *HTTP Request* inside *Run Node** to match the one from your BrowserAct workflow. Connect Gemini:* Add your Google Gemini credentials to the *AI Agent** node. Configure Telegram:* Connect your Telegram account and add your Channel ID to the *Send a News Photo To Telegram** node. How it works The workflow is triggered automatically on a schedule, but you can also manually run it. It uses an HTTP Request node to start a web scraping task via the BrowserAct API to collect the latest news. A series of If and Wait nodes monitor the scraping job until the full data is ready. An AI Agent node, powered by Google Gemini, processes the headlines and filters the news based on a list of keywords you define. A Code node then formats the AI's output into a clean, readable format. Finally, the filtered news articles are sent as rich media messages to Telegram, including the headline, a picture, and a link. Requirements BrowserAct** API account BrowserAct* *“News Content Marketing Automation”** Template Gemini** account Telegram** credentials Need Help ? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates

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

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).

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.

Who’s it for Teams that collect product feedback with Jotform and want automated triage: instant alerts for urgent issues, knowledge-based replies to questions, and a clean backlog for suggestions. How it works / What it does New Jotform submissions are classified by Feedback Type (comments, questions, suggestions) and analyzed for sentiment. Angry or negative messages trigger a Telegram alert to your support channel. Questions are answered automatically using an agent that consults your internal Google Sheet “Q&A” database, then replies via Gmail with a styled HTML email. Suggestions are summarized, sent to a team chat, and appended to a Google Sheets backlog with name, email, summary, and date. All comments are logged to a structured sheet for reporting. How to set up Connect your Jotform form and map fields (Name, E-mail, feedback text). Add credentials for Google Sheets, Gmail, Telegram, and LLM. Point the agent to your “Q&A” sheet/tab. Test each branch (comments, questions, suggestions) with sample entries. Requirements Jotform account and live form n8n (self-hosted recommended if using community/LLM nodes) Google Sheets, Gmail, Telegram bot, and LLM API keys How to customize the workflow Adjust sentiment thresholds or add new categories in the Switch node. Edit the Gmail HTML template and subject line. Change backlog columns or target sheets/tabs. Add rate-limits, SLA timers, or different alert channels. Best practice: rename all nodes, add a yellow Sticky Note with this description and per-step notes, and group user-config variables in a Set node. Remove any hard-coded IDs before sharing Knowledge base table Suggestions database Sentiment database

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.

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

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.**

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

This workflow automates plant care reminders and records using Google Sheets, Telegram, and OpenWeather API. It checks when each plant needs watering or fertilizing, sends a personalized reminder, and lets you confirm the task with a single button. When confirmed, it updates your Google Sheet and shows a confirmation HTML page. Who is it for? Home gardeners who want to automate watering and fertilizing schedules. Anyone managing a plant collection, greenhouse, or garden and wanting a lightweight, no-code reminder system. How it works Schedule Trigger starts the workflow once per day. Read Settings (Google Sheets) checks if vacation_mode is active. Read Plants (Google Sheets) retrieves all plants with columns such as id, plant, last_water, water_freq, etc. DecideDue (Code Node) compares today’s date with the last watering/fertilizing date and marks which plants are due. OpenWeather Request (optional) fetches local forecast for plants with coordinates and weather_delay = true. WeatherGate (Code Node) skips or delays watering if it recently rained or if rain is expected soon. Telegram Send Message sends a reminder for each due task. The message contains an inline button “Mark as done” linking to your webhook URL (opens confirmation window). Webhook – Confirm Done receives the click, update dates on Google Sheets, appends an optional log entry, and returns an HTML confirmation page. Setup steps Principal Workflow Spreadsheet- Create a Google Sheets document with: plants sheet: (id, plant, last_water, water_freq, last_fert, fert_freq, lat, lon, weather_delay , indoor, thirst_level) settings sheet: (vacation_mode, timezone) log sheet: (ts, plant_id, action message_id) Connect your Google account Configure the Schedule Trigger Enable weather integration (Get a free OpenWeather API key) and add it to the HTTP Request node parameters appid. https://openweathermap.org/api Configure Telegram with your credential and your chat id on {YOUR_CHAT_ID}. Configure "Send Dues" node with your custom url https://{YOUR_PROJECT_URL}.app.n8n... Setup steps Sub-Workflow (Webhook) Trigger: Configure your custom Path. Google Sheets: Connect your Google Account and Map sheets and columns. Requirements · A Google account with access to Google Sheets. . A spreadsheet containing three sheets with headers matching the field names used in the workflow. . A telegram bot. . OpenWeather API key for climate-aware watering. How to customise it Add plant photos: Include a photo URL column and show it in the Telegram message. Extend actions: Add pruning, repotting or any other periodic task by duplicating the existing logic.

WhatsApp customer service bot (with voice note transcription) handling FAQ, service enquiries and schedule appointments Who’s it for This template is designed for businesses that provide customer support and appointment-based services over WhatsApp. It’s ideal for service providers (e.g., clinics, salons, repair shops, consultants) that want to automate FAQs, share service information, handle voice note inquiries, and schedule appointments without manual effort. How it works / What it does This workflow creates a WhatsApp customer service assistant that: Transcribes voice notes** sent by customers into text for further processing. Answers customer FAQs by looking up a Google Sheet knowledge base. Provides service information (name, description, price) from a Google Sheet. Schedules appointments by: Asking the customer which service they want. Collecting their preferred day and time. Checking Google Calendar for available slots. Offering 3 options and letting the customer choose. Collecting name, email, and phone number. Creating the confirmed appointment in Google Calendar. Sends all customer-facing messages via a WhatsApp integration node. How to set up Connect your tools Link your Google Sheets for FAQs and Services. Connect your Google Calendar account. Configure your WhatsApp integration. Connect a transcription service (e.g., Whisper, Google Speech-to-Text, or another transcription API). Prepare your data FAQs Google Sheet → must contain columns: id | question | answer Services Google Sheet → must contain columns: id | service_name | service_description | price Adjust the flow Update the service names and questions to match your business. Set the correct time zone in the Google Calendar node. Update the WhatsApp integration node with your business account. Configure the transcription node with your chosen API credentials. Requirements Google Sheets (for FAQs and Services) Google Calendar WhatsApp integration in n8n Speech-to-Text API (for transcribing voice notes) How to customize the workflow Adding new FAQs**: Update the Google Sheet with new rows. Changing services**: Modify the Services Google Sheet to reflect updated offerings or prices. Custom messages**: Update the agent_reply node text to reflect your brand tone. Advanced logic**: Add routing for voice-note-only customers, VIP handling, or multilingual support. Notes This template uses multiple external integrations (Google Sheets, Google Calendar, WhatsApp, Speech-to-Text).

📸🍽️ Telegram Food Photo → 🤖 Gemini Vision AI → 📊 Nutrition Data → 📄 Google Sheets + 🗂️ Drive What this workflow does 📸 Snap and send a photo of your meal via Telegram 🧠 Gemini Vision AI analyzes the image and estimates calories, protein, carbs, and fats 🤖 AI Agent structures the data with meal name, description, and timestamp 📄 Auto-logs nutrition data to Google Sheets for tracking 🗂️ Saves original meal photos to Google Drive with timestamped filenames 💬 Sends instant Telegram reply with full nutrition breakdown Why it's useful ⚡ Track nutrition in seconds—no manual entry or food databases 📊 Build a complete meal history with photos and macros in one place 🎯 AI estimates portion sizes and hidden ingredients (oils, sauces) 🏋️ Perfect for fitness tracking, meal prep, or health monitoring 📱 Works entirely through Telegram—no extra apps needed How it works 📲 Telegram Trigger → receives meal photo 🗂️ Google Drive → saves image with timestamp 🔎 Gemini Vision → analyzes food, estimates portions and macros 🤖 AI Agent → structures output (meal name, calories, protein, carbs, fats) 📄 Google Sheets → appends row with all nutrition data 💬 Telegram Reply → confirms with full breakdown What you'll need 🤖 Telegram Bot token 🧠 Google Gemini API key (includes Vision capabilities) 🔐 Google OAuth for Sheets + Drive 📊 Google Sheet with columns: Meal_Name, Date, Meal_description, Calories, Proteins, Carbs, Fats Setup steps 🔗 Connect credentials: Telegram, Google Gemini, Google Sheets, Google Drive 📄 Create Google Sheet with nutrition columns (see format above) 🗂️ Create Google Drive folder for meal photos 🧭 Update sheet ID and Drive folder ID in workflow 🧪 Test: send a meal photo via Telegram and check Sheet + Drive Customization ideas 📈 Daily summary: add scheduled workflow to calculate daily totals 🎯 Goal tracking: set IF conditions to alert when over/under calorie targets 📊 Charts: connect to Data Studio/Looker for visual progress tracking 🏃 Fitness integration: sync with MyFitnessPal or fitness apps Who it's for 🏋️ Fitness enthusiasts tracking macros without manual logging 🥗 Meal preppers analyzing portion sizes and nutrition 💪 Athletes monitoring calorie and protein intake 🩺 Health-conscious individuals building meal history 👨‍🍳 Nutritionists collecting client food data Quick Setup Guide - Before You Start - What You Need: 🔗 Telegram Bot (create via @BotFather) 🧠 Google Gemini API key with Vision enabled (get it here) 🔐 Google account for Sheets and Drive access 📊 Basic spreadsheet to track your meals Want help customizing? 📧 anirpoke@gmail.com 🔗 LinkedIn