Telegram Automation Workflows
1,649 ready-made Telegram workflows for n8n, Make, Zapier, Activepieces, and Pipedream. Bots, alerts, and AI assistants delivered straight to Telegram chats and channels.
Automate Real-Time Cryptocurrency Price Updates in Telegram
This workflow integrates CoinMarketCap with Telegram to provide real-time cryptocurrency prices. Users can request live prices by messaging a Telegram bot, ideal for traders and enthusiasts needing quick market data.
n8n$4.99Automate AI-Driven Customer Support on Telegram and WhatsApp
Leverage AI to deliver seamless customer support on Telegram and WhatsApp using n8n. This workflow integrates with Google Sheets and OpenAI to provide personalized responses and smart routing.
n8n$14.99Flight Data Visualization with Chart.js, QuickChart API & Telegram Bot
# Real-time Flight Data Analytics Bot with Dynamic Chart Generation via Telegram ## Template Overview This advanced n8n workflow creates an intelligent Telegram bot that transforms raw CSV flight data into stunning, interactive visualizations. Users can generate professional charts on-demand through a conversational interface, making data analytics accessible to anyone via messaging. **Key Innovation**: Combines real-time data processing, Chart.js visualization engine, and Telegram's messaging platform to deliver instant business intelligence insights. ## What This Template Does Transform your flight booking data into actionable insights with four powerful visualization types: - **Bar Charts**: Top 10 busiest airlines by flight volume - **Pie Charts**: Flight duration distribution (Short/Medium/Long-haul) - **Doughnut Charts**: Price range segmentation with average pricing - **Line Charts**: Price trend analysis across flight durations Each chart includes auto-generated insights, percentages, and key business metrics delivered instantly to users' phones. ## Technical Architecture ### Core Components 1. **Telegram Webhook Trigger**: Captures user interactions and button clicks 2. **Smart Routing Engine**: Conditional logic for command detection and chart selection 3. **CSV Data Pipeline**: File reading → parsing → JSON transformation 4. **Chart Generation Engine**: JavaScript-powered data processing with Chart.js 5. **Image Rendering Service**: QuickChart API for high-quality PNG generation 6. **Response Delivery**: Binary image transmission back to Telegram ### Data Flow Architecture ``` User Input → Command Detection → CSV Processing → Data Aggregation → Chart Configuration → Image Generation → Telegram Delivery ``` ## Setup Requirements ### Prerequisites - **n8n instance** (self-hosted or cloud) - **Telegram Bot Token** from @BotFather - **CSV dataset** with flight information - **Internet connectivity** for QuickChart API ### Dataset Source This template uses the **Airlines Flights Data** dataset from GitHub: **Dataset**: [Airlines Flights Data by Rohit Grewal](https://github.com/dataminexcode/n8n-workflow/blob/main/Real-time%20Flight%20Data%20Analytics%20Bot%20with%20Dynamic%20Chart%20Generation%20via%20Telegram/data) ### Required Data Schema Your CSV file should contain these columns: ```csv airline,flight,source_city,departure_time,arrival_time,duration,price,class,destination_city,stops ``` ### File Structure ``` /data/ → flights.csv (download from GitHub dataset above) ``` ## Configuration Steps ### 1. Telegram Bot Setup 1. Create a new bot via @BotFather on Telegram 2. Copy your bot token 3. Configure the Telegram Trigger node with your token 4. Set webhook URL in your n8n instance ### 2. Data Preparation 1. Download the dataset from [Airlines Flights Data](https://github.com/dataminexcode/n8n-workflow/blob/main/Real-time%20Flight%20Data%20Analytics%20Bot%20with%20Dynamic%20Chart%20Generation%20via%20Telegram/data) 2. Upload the CSV file to `/data/flights.csv` in your n8n instance 3. Ensure UTF-8 encoding 4. Verify column headers match the dataset schema 5. Test file accessibility from n8n ### 3. Workflow Activation 1. Import the workflow JSON 2. Configure all Telegram nodes with your bot token 3. Test the `/start` command 4. Activate the workflow ## Technical Implementation Details ### Chart Generation Process **Bar Chart Logic**: ```javascript // Aggregate airline counts const airlineCounts = {}; flights.forEach(flight => { const airline = flight.airline || "Unknown"; airlineCounts[airline] = (airlineCounts[airline] || 0) + 1; }); // Generate Chart.js configuration const chartConfig = { type: 'bar', data: { labels, datasets }, options: { responsive: true, plugins: {...} } }; ``` **Dynamic Color Schemes**: - Bar Charts: Professional blue gradient palette - Pie Charts: Duration-based color coding (light to dark blue) - Doughnut Charts: Price-tier specific colors (green to purple) - Line Charts: Trend-focused red gradient with smooth curves ### Performance Optimizations 1. **Efficient Data Processing**: Single-pass aggregations with O(n) complexity 2. **Smart Caching**: QuickChart handles image caching automatically 3. **Minimal Memory Usage**: Stream processing for large datasets 4. **Error Handling**: Graceful fallbacks for missing data fields ### Advanced Features **Auto-Generated Insights**: - Statistical calculations (percentages, averages, totals) - Trend analysis and pattern detection - Business intelligence summaries - Contextual recommendations **User Experience Enhancements**: - Reply keyboards for easy navigation - Visual progress indicators - Error recovery mechanisms - Mobile-optimized chart dimensions (800x600px) ## Use Cases & Business Applications ### Airlines & Travel Companies - **Fleet Analysis**: Monitor airline performance and market share - **Pricing Strategy**: Analyze competitor pricing across
n8n$14.99Automate AI News Summaries to Telegram with Gemini and n8n
Streamline your AI news updates by automatically generating and sending concise summaries to Telegram using n8n, Jina AI, and Google Gemini.
n8n$9.99Create a Telegram Echo Bot for Debugging and Learning
This workflow sets up a Telegram echo bot that returns the JSON content of any message it receives, aiding in debugging and learning about Telegram's API.
n8n$3.99Ultimate AI Assistant: Email, Calendar, Web, Notion, RAG & X via Telegram
AI-powered Telegram bot automates emails, calendars, web searches, Notion notes, RAG queries, and X posts using text, voice, or images for seamless productivity.
n8n$29.99Automate Hourly Crypto Market Analysis and Alerts from Binance to Telegram
This workflow automates the process of fetching hourly crypto market data from Binance, analyzing key metrics, and sending a detailed market summary to Telegram.
n8n$9.99Automate Notion Task Creation from Telegram Messages Using GPT-3.5
Effortlessly create tasks in your Notion database by sending text or audio messages to a Telegram bot, which are transcribed and processed using GPT-3.5.
n8n$9.99Telegram Bot Starter Template Setup & AI Agent Chatbot
## Telegram Bot Starter Template Workflow + n8n AI Agent Chatbot Provides a foundational setup for creating powerful Telegram bots with n8n. It handles incoming messages, photos, files, and voice notes, making it an excellent starting point for developers looking to create bots for customer engagement, support, or interactive services. [Sign up to n8n now](https://n8n.partnerlinks.io/u4hgi2j8tqnr) and try it! ## Key Features: - Dynamic Message Handling: Respond to text messages, photos, files, and more. - Modular Design: Easily integrate additional workflows such as user registration, payment modules, or custom commands. - Error Handling: Ensure the bot gracefully manages errors and user inputs. ## Extensibility: This workflow is the base for building any Telegram bot. Additional modules, such as a user registration module, payment integration, and user profile management, are available for easy connection to expand the bot's functionality. - [Use the Telegram user registration workflow](https://viktorgubanov.gumroad.com/l/n8n-telegram-payment-workflow-stars) - [Use the Telegram Payment, Invoicing and Refund Workflow for Stars](https://viktorgubanov.gumroad.com/l/n8n-telegram-payment-workflow-stars) ## Who Can Use This Workflow? - Developers looking for a quick way to build and customize Telegram bots. - Businesses and service providers who need customer interaction automation. ## Setup Instructions: 1. Replace Telegram credentials with your own API credentials. 2. Customize responses for different message types (text, photo, file). 3. If integrating with external services (like Google Sheets), update the necessary credentials and links. ## UPDATES: [Get the most up-to-date and expanded version](https://viktorgubanov.gumroad.com/l/telegram-bot-starter-template) **June 25**: - New! AI Agent + Setup Instructions - Simple setup instructions and examples are included inside the workflow as sticky notes. **Sep 24**: - Improved message handler: Updated logic to handle various types of messages using Switch (text, photo, file, voice, and callback). - Payment processing: Added new nodes for sending invoices and handling payments via Telegram **Aug 24**: - Changed processing of system events: "new user" and "user who blocked bot" events Please reach out to [Victor](https://www.linkedin.com/in/gubanovvictor/) if you need further assistance with your n8n workflows and automations! [Sign up to n8n](https://n8n.partnerlinks.io/u4hgi2j8tqnr), you have to try it!
n8n$24.99Self-Learning AI Assistant with Permanent Memory | GPT, Telegram & Pinecone RAG
## Your AI secretary that self-learns every day and remembers everything you said (text, audio, image). **Imagine having a personal AI secretary accessible right from your Telegram, ready to assist you with information and remember everything you discuss.** This n8n workflow transforms Telegram into your intelligent assistant, capable of understanding text, audio, and images, and continuously learning from your interactions. **It integrates RAG's offline data ingestion and online querying functionalities, letting you save inspiration and key information permanently in real-time, and giving you an AI assistant that remembers all your dialogues and information.** It builds and queries a powerful vector database in real-time, ensuring relevant and accurate responses. **Video guidance on how to set up Telegram integration is also included.** **Who is this for?** This template is ideal for: - Individuals seeking a personal AI assistant for quick information retrieval and note-taking. - Professionals who need to keep track of important conversations and insights. - Anyone interested in leveraging the power of Retrieval-Augmented Generation (RAG) and vector databases for personal knowledge management. - Users who want a self-learning AI that improves over time based on their interactions. **What problem is this workflow solving?** **This workflow integrates RAG's offline data ingestion and online querying functionalities, letting you save inspiration and key information permanently in real-time, and giving you an AI assistant that remembers all your dialogues and information.** This workflow addresses the challenge of information overload and the need for an easily accessible, personalized knowledge base. It eliminates the need to manually organize notes and search through past conversations. By automatically storing and retrieving information from a vector database, this workflow makes it effortless to access the knowledge you need, when you need it. It also provides a way to retain information from various media types like voice notes and images. **What this workflow does:** This workflow automates the following steps: - **Instant Information Capture:** Receives text messages, audio notes (transcribed), and images (with content analysis) directly from your Telegram. - **Intelligent Question Answering:** When you ask a question, the AI searches its knowledge base (Pinecone vector store) for relevant information and provides a comprehensive answer. It even considers your recent conversations for context. - **Automatic Knowledge Storage:** When you make a statement or provide information, the AI extracts key details and saves them in a Google Docs memory palace. - **Daily Self-Learning:** Every day, the workflow automatically takes all the information stored in the Google Docs, converts it into a vector representation, and adds it to its knowledge base (Pinecone vector store). This ensures the AI continuously learns and remembers everything you've shared. - **Image Understanding:** Extracts text and information from images you send. - **Audio Transcription:** Automatically transcribes your voice notes into text for processing and storage. - **Short-term Memory:** Remembers recent interactions within a session for more context-aware conversations. **Setup:** To get started, you'll need to connect the following services to your n8n instance: 1. **Telegram:** Connect your Telegram bot API credentials. A video guidance is included for Telegram integration setup. 2. **OpenAI:** Provide your OpenAI API key for audio transcription and image analysis. 3. **Pinecone:** Set up a Pinecone account and provide your API key and environment. Create a namespace in Pinecone. 4. **Google Docs:** Connect your Google account with access to Google Docs. You'll need to create a Google Doc that will serve as the daily memory palace and provide its ID in the workflow. **How to customize this workflow:** - **Adjust the AI Agent's Personality:** Modify the system prompt in the AI Agent node to tailor the AI's tone and behavior. - **Expand Knowledge Sources:** Integrate other data sources into the daily learning process, such as emails or other documents, by adding more nodes to the scheduled trigger workflow. - **Add More Tools for the AI Agent:** Integrate additional tools into the AI Agent, such as web search or other APIs, to further enhance its capabilities. - **Modify the Daily Schedule:** Adjust the schedule trigger to run at a different time or interval.
n8n$24.99AI-Powered Credit Card Recommendation System with OpenAI GPT, Telegram & Google Sheets
Overview Confused about which credit card to actually get or swipe? With 100+ cards on the market, hidden caps, and milestone rules, most people end up leaving rewards, perks, and cashback on the table. This workflow uses n8n + GPT + Google Sheets + Telegram to recommend the best credit card for each user's lifestyle in under 3 seconds, while keeping the logic transparent with a value breakdown. What does this workflow do? This workflow: - Captures User Inputs - Users answer a 7-question lifestyle quiz via Telegram. - Stores Responses - Google Sheets logs all answers for resumption & deduplication. - Scores Answers - n8n Function nodes map single & multi-select inputs into scores. - Generates Recommendations - GPT analyses profile vs. 30+ card dataset. - Breaks Down Value - Outputs a transparent table of rewards, milestones, lounge value. - Delivers Results - Top 3 card picks returned instantly on Telegram. Why is this useful? Most card comparison tools only list features; they don't personalize or calculate actual value. This workflow builds a decision engine: - Personalized – matches lifestyle to best-fit cards - Transparent – shows value in real currency (rewards, milestones, lounges) - Fast – answers in under 3 seconds - Organized – Google Sheets keeps an audit trail of every user + dedupe Tools used - n8n (Orchestrator): Orchestration + logic branching - Telegram: User-facing quiz bot - Google Sheets: Database of credit cards + logs of user answers - OpenAI (GPT): Analyses user profile & generates recommendations Who is this for? - Fintech product builders – see how AI can power recommendation engines - Cardholders – understand which card fits their lifestyle best - n8n makers – learn how to combine Sheets + GPT + chat interface into one workflow How to adapt it for your country/location This workflow uses a credit card dataset stored in Google Sheets. To make it work for your country: - Build your dataset – scrape or collect card details from banks, comparison sites, or official portals - Fields to include: Fees, Reward rate, Lounge access, Forex markup, Reward caps, Milestones, Eligibility. - You can use web crawlers (e.g., Apify, PhantomBuster) to automate data collection. - Update the Google Sheet – replace the India dataset with your country's cards. - Adjust scoring logic – modify Function nodes if your cards use different reward structures (e.g., cashback %, miles, points value). - Run the workflow – GPT will analyse against the new dataset and generate recommendations specific to your country. This makes the workflow flexible for any geography. Workflow Highlights - End-to-end credit card recommendation pipeline (quiz → scoring → GPT → result) - Handles single + multi-select inputs fairly with % match scoring - Transparent value breakdown in local currency (rewards, milestones, lounge access) - Google Sheets for persistence, dedupe & audit trail - Delivers top 3 cards in <3 seconds on Telegram - Fully customizable for any country by swapping the dataset
n8n$24.99Automate Product Recommendations on Telegram with AI and Amazon Scraping
Transform your Telegram channel into a smart shopping assistant that automatically provides product recommendations using AI and real-time Amazon data.
n8n$14.99Build a Multi-Model AI Chatbot with Telegram, AIMLAPI, and Google Sheets
This n8n workflow allows Telegram users to interact with multiple AI models dynamically. Users can select models using #model_id commands and track their daily usage via Google Sheets.
n8n$14.99Health Check Websites with Google Sheets & Telegram Alerts
## What does this template do? This workflow performs scheduled health checks on a list of URLs stored in a Google Sheet. Every X minutes, it retrieves the URLs, sends HTTP requests to check their availability, and notifies a Telegram chat if any request fails. You can easily replace Telegram with any other notification service supported by n8n, such as Slack, Discord, Email, or Microsoft Teams. ## Use Case Ideal for monitoring internal or external services, ensuring uptime and responsiveness. Integrate with your preferred messaging platform for real-time failure notifications without setting up complex infrastructure. ## What the Workflow Does - Triggers at regular intervals using **Schedule Trigger** - Reads URLs from a **Google Sheet** - Sends HTTP requests to check URL health - Sends failure alerts (including error code and URL) to **Telegram (or any service of your choice)** ## Apps & Services Used - Google Sheets - Telegram (or alternative notification service) - HTTP Request ## Pre-requisites - Telegram bot and chat ID (if using Telegram) - Connected Google Sheet with a `URLS` column ([template](https://docs.google.com/spreadsheets/d/17-tY9_wn-D2FV627Sx3-Z3abqFYvz794edej7es5J6w/edit?usp=sharing)) ## Customization Tips - Adjust the schedule interval in the trigger node - Replace Telegram with Slack, Email, Discord, or any other notification node - Customize alert messages with more context or formatting - Add filters, retries, or logging as needed
n8n$4.99Automate Appointment Scheduling via Telegram and Google Calendar
Streamline your appointment management by automating booking and cancellations through Telegram, powered by AI and Google Calendar integration.
n8n$9.99AI Sales Agent: Telegram Approvals & Google Sheets Sync
AI-powered Telegram chatbot for sales/orders with payment approvals and Google Sheets sync. Handles conversations, verification, and tracking with human oversight.
n8n$24.99TechCrunch AI Article Scraper & Classifier with GPT-4.1-nano to Sheets & Telegram
## How it works This workflow scrapes the latest Artificial Intelligence articles from TechCrunch, then processes and classifies the content using OpenAI and LangChain nodes. The final result is saved to Google Sheets and sent as a summary to a Telegram group. Workflow Logic: - Trigger: Schedules daily at 6 AM Bangkok time. - Scraper: Extracts URLs and publish dates from TechCrunch's AI category. - Filter: Only continues if the article is from yesterday (to avoid duplication). - Content Fetch: Downloads and extracts article body text. - AI Agent: - Summarizes the article in Thai. - Scores it using strict journalism criteria (max 100). - Categorizes the news into one of 9 predefined categories. - Output: - Saves all structured data to Google Sheets. - Sends a summary to a Telegram group. ## Set up steps **Estimated setup time:** 10-15 minutes Connect your credentials: - Google Sheets (OAuth2) - Telegram - OpenAI account (via LangChain model) Update the Telegram chatId and Google Sheets documentId/sheetName values. Deploy and activate the workflow. It runs daily without manual intervention.
n8n$14.99Multi-service Terminal: Access Gmail, IRC, Telegram & News with Gemini AI
This workflow receives plain English instructions from a retro console via a webhook. Using an AI agent, it can combine multiple tools to read general RSS news headlines, stock market updates, emails, calendar events, search X, send Telegram messages, and run Linux commands. The idea is to avoid using smartphones or regular laptops in the morning, and instead use a retro console installed on an old notebook or netbook. You will need to copy a Python script onto the notebook, configure the webhook URL, and set up all the required credentials. Steps: 1. Set up Gemini API key, Google Gmail, and Calendar credentials from console.google.com. 2. Set up X credentials, RSS URL, etc. 3. Obtain the webhook URL and paste it into the Python code to be executed on the Linux machine. 4. Run the python script with `python3 console.py`. Note: If you ask for a Linux command, the command will not only be returned but also executed.
n8n$9.99Extract & Categorize Receipt Data with Google OCR, OpenRouter AI & Telegram
Effortlessly track your expenses with **MoneyMate**, an n8n workflow that transforms receipts into organized financial insights. Upload a photo or text via **Telegram**, and let **MoneyMate** extract key details—store info, transaction dates, items, and totals—using **Google Vision OCR** and **AI-powered** parsing via **OpenRouter**. It categorizes expenses (e.g., **Food & Beverages**, **Transport**, **Household**) and delivers a clean, emoji-rich summary back to your **Telegram** chat. Handles zero-total errors with a friendly nudge to double-check inputs. Perfect for freelancers, small business owners, or anyone seeking hassle-free expense management. No database required, ensuring **privacy** and simplicity. Deploy **MoneyMate** and take control of your finances today! ## Key Features - **Telegram Integration:** Input via photo or text, receive summaries instantly. - **Receipt Scanning:** Converts receipt images to text using **Google Vision API**. - **AI Parsing:** Categorizes transactions with **OpenRouter's AI** analysis. - **Privacy-First:** Processes data on-the-fly without storage. - **Smart Error Handling:** Catches zero totals with user-friendly prompts. - **Flexible Categories:** Supports **Income/Expense** and custom expense types. ## Ideal For - **Budget-conscious individuals** managing personal finances. - **Entrepreneurs** tracking business expenses. - **Teams** needing quick, automated expense reporting. ## Pre-Requirements - **[n8n Instance](https://n8n.partnerlinks.io/khaisastudio):** A running n8n instance (cloud or self-hosted). - **Credentials:** - **Telegram:** A bot token and webhook setup (obtained via BotFather). For more information, please refer to [Telegram bots creation](https://core.telegram.org/bots/tutorial). - **Google Cloud:** A service account with **Google Vision API** enabled and API key. For more information, please refer to [Google Cloud Vision](https://cloud.google.com/use-cases/ocr). - **OpenRouter:** An account with API access for AI language model usage. - **Telegram Bot:** A configured **Telegram** bot to receive inputs and send summaries. ## Setup Instructions - **Import Workflow:** Copy the **MoneyMate** workflow JSON and import it into your n8n instance using the Import Workflow option. - **Set Up Telegram Bot:** Create a bot via BotFather on **Telegram** to get a token and set up a webhook. For detailed steps, refer to [n8n's Telegram setup guide](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.telegram/). - **Configure Credentials:** - In the **Telegram Trigger**, **Send Error Message**, and **Send Expense Summary** nodes, add **Telegram API** credentials with your bot token. - In the **Get Telegram File** and **Download Image** nodes, ensure **Telegram API** credentials are linked. - In the **Google Vision OCR** node, add **Google Cloud** credentials with **Google Vision API** access. - In the **OpenRouter AI Model** node, set up **OpenRouter API** credentials. - **Test the Workflow:** Send a test receipt photo or text (e.g., Lunch 50,000 IDR) via **Telegram** and verify the summary in your chat. - **Activate:** Enable the workflow in n8n to run automatically for each input. ## Customization Options - **Add Categories:** Modify the **AI Categorizer** node to include new expense types (e.g., **Entertainment**). - **Change Output Format:** Adjust the **Format Summary Message** node to include more details like taxes or payment methods. - **Switch AI Model:** In the **OpenRouter AI Model** node, select a different **OpenRouter** model for better parsing. - **Store Data:** Add a **Google Sheets** node after **Parse Receipt Data** to save expense records. - **Enhance Errors:** Include an email notification node after **Check Invalid Input** for failed inputs. ## Why Choose MoneyMate? Save time, reduce manual entry, and gain clarity on your spending with **MoneyMate's AI-driven** workflow. Ready to streamline your finances? Get **MoneyMate** now! *Made by: [khmuhtadin](khmuhtadin.com)* Need a custom? Contact me on **[LinkedIn](https://www.linkedin.com/in/khmuhtadin/)** or **[Web](khmuhtadin.com)**
n8n$14.99Automate Telegram Channel Content Translation and Republishing with OpenAI
This n8n workflow automatically fetches content from a Telegram channel, translates it using OpenAI, and republishes it to another channel. It supports text, images, and videos, and operates without requiring admin privileges in the source channel.
n8n$14.99Automate Gmail Cleanup with AI Validation and Telegram Alerts
Effortlessly manage your Gmail inbox by automatically deleting unwanted emails using AI validation, with real-time notifications via Telegram.
n8n$14.99AI Sales Agent for Telegram with Google Sheets Integration
Automate your sales process using a Telegram bot and sync with Google Sheets for efficient order management.
n8n$19.99Telegram Automation for Google Tasks Management
This workflow integrates Telegram with Google Tasks to streamline appointment management and reminders for a clinical setting. It allows professionals to efficiently reschedule patient appointments and add items to a shopping list directly through...
n8n$11.99Track Expenses by Parsing Telegram Transaction Messages to Google Sheets
**Overview** This n8n workflow template automatically parses incoming Telegram transaction messages and logs structured data into a Google Sheet. It's designed to help individuals and small businesses track and record transactions shared via Telegram without manual data entry. **Target Audience** This template is ideal for: - Individuals, freelancers, and small businesses who receive transaction or payment notifications through Telegram and want to organize them in Google Sheets. - Anyone using self-hosted n8n (required due to custom community nodes). **Problem Solved** Manually copying transaction details from Telegram to Google Sheets is error-prone and time-consuming. This workflow automates the process by: - Monitoring a Telegram bot/chat for new messages. - Parsing transaction details (amount, sender, date, etc.). - Logging them in real-time into a Google Sheet for easy tracking. **Setup Instructions** 1. **Telegram Bot Setup** - Create a Telegram bot using BotFather. - Add the bot to the desired group/channel and grant admin permissions if needed. - Note down the bot token. 2. **Google Sheets Setup** - Create a Google Sheet with relevant columns (e.g., Date, Amount, Sender, Transaction ID). - Set up Google Sheets credentials in n8n for access. 3. **n8n Workflow Configuration** - Import this template into your self-hosted n8n instance. - Update the Telegram node: Add your bot token and specify the chat/group ID. - Update the Google Sheets node: Link it to your created sheet and ensure column mapping matches your sheet structure. - Adjust parsing logic if your message format varies (see next section for examples). 4. **Community Nodes** - This workflow uses custom community nodes. Ensure these are installed via the n8n settings or CLI: - [List your required community nodes here, e.g., n8n-nodes-telegram, n8n-nodes-gsheet, etc.] 5. **Activate the Workflow** - Save and activate your workflow. Send a test transaction message to your Telegram group/chat and verify data appears in your Google Sheet. 6. **Troubleshooting** - If messages are not being picked up, check bot permissions and the chat ID. - Ensure Google Sheets credentials are correct and the sheet is accessible. - Double-check that custom nodes are properly installed and up-to-date. **Example Telegram Message Formats** - Received: $75 from @john_doe on 2024-05-29. Transaction ID: 12345XYZ. - Paid $120 to @vendor on 2024-05-28. Ref: 67890ABC. - You received ₹5,000 from @amit. ID: 54321PQR. Date: 29/05/2024 The workflow parses messages in the above formats and logs the following columns: - Date - Amount - Sender/Receiver - Transaction/Reference ID If your message format differs, update the regex in the parsing node. **Disclaimer** This n8n workflow template uses custom community nodes and is only compatible with the self-hosted version of n8n. **Workflow Changes (For n8n Canvas)** Rename the Nodes: - If node → "Is Transaction Message?" - Google Sheets node → "Log to Google Sheet" (Rename other generic nodes for clarity, e.g., Telegram → "Listen for Telegram Messages", Function → "Parse Transaction Details") Sticky Note Improvement: (Edit the sticky note or add one if missing) **Workflow Steps:** - Listen for Telegram Messages: This node receives new messages from the Telegram bot. - Is Transaction Message? Checks if the message matches known transaction patterns. - Parse Transaction Details: Extracts amount, sender, date, and transaction ID using regex. - Log to Google Sheet: Records the parsed transaction in the linked Google Sheet for easy tracking.
n8n$4.99
More integrations
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work