Workflow Templates

Who’s it for This template is designed for individuals who want to gain full control over their personal finances without the hassle of manual tracking. Ideal for freelancers, small business owners, or anyone who wants a simple, automated way to monitor income and expenses. How it works / What it does Using n8n, Telegram, and Google Sheets, this workflow allows you to log, edit, and query your financial transactions through simple Telegram messages. The AI interprets your input—whether text or audio—and automatically categorizes your income and expenses. Responses are delivered fully formatted in Telegram HTML, giving you clean, readable summaries and insights. Features include: Add, edit, and delete transactions automatically Query totals and category-specific expenses, e.g., “How much did I spend on food this month?” Generate financial summaries and monthly reports Automatic ID assignment and date handling How to set up Deploy this workflow on your self-hosted n8n instance. Connect your Telegram Bot and Google Sheets account. Configure the Google Gemini AI node for message interpretation. Update sheet headers and categories if needed. Start sending messages to your Telegram bot to track expenses instantly. How to Set Up the Google Sheet To use this workflow, you’ll need a Google Sheet with the following structure: | Column Name | Description | | ------------------- | ----------------------------------------------- | | id | Unique sequential identifier (auto-incremented) | | type | "income" or "expense" | | value | Monetary value (format: 1234.56) | | category | Classification of the transaction | | payment\_method | Payment method used (e.g., card, cash, PIX) | | description | Details about the transaction | | date | Transaction date (format: yyyy-MM-dd) | Make sure the column headers match exactly as shown above, and leave the rows empty for the bot to fill automatically. Requirements n8n (self-hosted or cloud instance) Telegram Bot API Google Sheets Google Gemini AI or equivalent AI node

Why I built this? (The Problem) Most expense tracker apps (like Money Lover, Spendee, or Wallet) have a common friction point: Data Entry. You have to unlock your phone, find the app, wait for it to load, navigate menus, and manually select categories. It’s tedious, so we often forget to log small expenses. I wanted a solution that lives where I already spend my time: Telegram. This workflow allows you to log expenses in seconds—just by sending a text, a voice note while driving, or a photo of a receipt. No UI navigation required. Comparison: This Workflow vs. Traditional Apps |Feature|Traditional Expense Apps|This n8n Workflow| |-|-|-| |Data Ownership|Data is locked in their proprietary database.|100% Yours. It lives in your Google Sheet. You can export, pivot, or connect it to Looker Studio.| |Input Speed|Slow. Requires multiple taps/clicks.|Instant. Send a text/voice/photo to a Telegram bot.| |Flexibility|Rigid categories & logic.|Infinite. You can customize the AI prompt, categories, and currency logic.| |Cost|Often requires monthly subscriptions for premium features.|Low Cost. Runs on your n8n instance + Gemini Flash API (which is currently free/very cheap).| |UI/UX|Beautiful, pre-built mobile dashboards.|Raw Data. You view data in Google Sheets (though you can build a dashboard there)| Key Features Multi-Modal Input:** Just send what you have. -- Text: "Lunch 50k, Taxi 30k" (Splits into 2 rows). -- Voice: Speak naturally, AI transcribes and extracts data. -- Photo: OCRs receipts and parses details. Global Currency Support:** Uses Gemini AI to intelligently detect currency. You can set a default currency (e.g., USD, VND) in the Config node. Smart Extraction & Categorization:** Automatically splits* multiple items in one message (e.g., "Lunch 20k and Grab 50k" → 2 separate rows). AI automatically* assigns categories (Food, Transport, Bills, etc.) based on the item name. Budget Management:** Use the command /add budget 500 to instantly top up your monthly budget. "Quiet" Reporting:* Instead of spamming you after every message, the system waits for *30 minutes of inactivity** before sending a daily summary report (Debounce logic). Setup Instructions 1. Prerequisites Google Sheet:* You *MUST* make a copy of this template: *[[Google Sheet Template here]](https://docs.google.com/spreadsheets/d/1bVdxslvMkTA1DDQv6kQ5j-COC8ZOH8AfEWmn31Rq6l4/edit?usp=sharing)** n8n Data Table:* This workflow requires a Data Table named ReportTokens for the reporting feature. Please read the setup guide below. *Setup Guide: AI Expense Tracker** 2. Configure the Workflow Credentials:* Connect *Telegram, **Google Sheets, and Google Gemini (PaLM). Config Node:** Open the CONFIG - User Settings node and update these fields. -- spreadsheet_id: The ID of your copied Google Sheet -- sheet_gid_dashboard: The ID of your sheet Dashboard -- sheet_gid_budget: he ID of your sheet Budget_Topups -- currency_code: Your currency code (e.g., USD, EUR, VND). -- currency_symbol: Your currency symbol (e.g., $, €, ₫). -- locale: Your locale for number formatting (e.g., en-US, vi-VN). Data Table**: Create a table in n8n with columns: chat_id, report_token, updated_at (All type: String). Link this table to the relevant nodes in the workflow. 3. Usage Log Expense*: Send *"Coffee $5" or a photo. Add Budget**: Send command /add budget 1000 Need Help or Want to Customize This? Contact me for consulting and support: Email: cuongnguyen@aiops.vn

Description Ever wanted to share the beauty of space with a unique, artistic touch? This workflow automatically generates a stunning "space postcard" and shares it in your Slack channel. It fetches a random image from NASA's Astronomy Picture of the Day (APOD) archive, uses an AI to write a short, poetic message inspired by the image, and overlays this text directly onto the picture before posting. Who’s it for Space lovers who want a daily dose of cosmic beauty in their Slack channels. Community managers looking for engaging, automated content to keep their workspace active. Creative teams who appreciate the fusion of technology, art, and science. Anyone looking for a fun, impressive demonstration of AI-powered image manipulation. What it does / How it works Fetches a Random Image: The workflow triggers and fetches a random image from the last 10 years of NASA's 'Astronomy Picture of the Day' (APOD) collection. It checks to ensure the content is an image, not a video. Engages AI for Creativity: It sends the image's title and official explanation to an AI model. The AI is prompted to generate a short, poetic message (under 50 characters) and to calculate the precise coordinates to place this text in the bottom-left corner of the image. Creates the Postcard: The workflow then takes the poetic text and coordinates from the AI and dynamically writes the message onto the NASA image, creating a unique digital postcard. Shares to Slack: Finally, it uploads the newly created postcard image to your specified Slack channel and posts a follow-up message. Requirements An n8n instance. A NASA API Key. An OpenAI API Key (or credentials for another compatible AI model). A Slack workspace and the permissions to connect an app. How to set up NASA Credentials: Add your NASA API key credentials to the Get NASA APOD node. OpenAI Credentials: Add your OpenAI API key credentials to the OpenAI Chat Model node. Slack Configuration: Add your Slack credentials to both the Upload a file and Send a message nodes. IMPORTANT: In both Slack nodes, you must select the channel where you want the postcard to be posted. How to customize the workflow Automate It: Replace the Manual Trigger with a Schedule Trigger to have a new postcard sent automatically every day. Change the AI's Personality: Edit the prompt in the AI Agent node. You can ask it to generate a funny caption, a haiku, or place the text in a different corner—the possibilities are endless! Use a Different Platform: Swap the Slack nodes for Discord, Telegram, or Email nodes to share the postcard on your platform of choice.

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

Stay ahead of the curve with this smart Hacker News monitor. Unlike simple RSS feeds, this workflow uses a custom "Gravity Score" algorithm to identify rising trends and filter out noise, pushing a clean, summarized digest to your Telegram. ✨ Key Features 🧠 Smart Algorithms: Gravity Score: Calculates popularity based on points, comments, and time (velocity), ensuring you see trending stories, not just old ones. Noise Filtering: Automatically discards "infancy" posts (new posts with zero engagement) to keep your feed high-quality. 🤖 Optional AI Translation: Includes an AI Agent (via OpenRouter/LLM) to translate titles and summaries into your local language (e.g., Chinese, Spanish, French). > Don't need translation? Simply delete the Translate node and connect the Filter node directly to the Combine message templates node. 📱 Beautiful Telegram Format: Delivers a clean HTML-formatted digest with clickable links, stats (Points/Comments), and story previews. ⚙️ How It Works Schedule: Runs every 4 hours (configurable) to fetch data from the past 24 hours via the Algolia API. Analyze: Calculates the velocity score for each post and filters out low-quality entries. Translate (Optional): Uses an LLM to translate the content. You can customize the target language in the AI Agent's system prompt. Format & Send: Combines the data into a structured message and pushes it to your Telegram Chat/Channel. 📝 Setup Instructions Telegram Credentials: Create a bot via @BotFather. Add the Bot Token to the Telegram node credentials. Get Chat ID. AI Configuration (Optional): Configure your LLM credentials (e.g., OpenRouter, OpenAI). In the "Translate" (AI Agent) node, edit the System Prompt to change the target language (Default is set to translate to Chinese). 👀 Output Example 🚨 Hacker News 24H Trending Alert 📉 Top stories captured: 5 🔥 Ask HN: How can we solve the loneliness epidemic? 📈 16.39 | 💬 796 | ⭐️ 482 🕒 Posted 12.7 hours ago > Countless voiceless people sit alone every day... 🔥 Show HN: Gambit, an open-source agent harness 📈 2.20 | 💬 11 | ⭐️ 58 🕒 Posted 5.3 hours ago > Wanted to show our open source agent harness... `

Template Overview This workflow demonstrates how to build a simple Telegram bot that can schedule events, check service prices, and query company documents using AI integrated with MCP and RAG. It’s designed to show how n8n can connect conversational interfaces with internal tools in a clear and scalable way. Key Concepts (explained simply): MCP (Multi‑Channel Processing): A framework that lets the AI agent connect to external services (like Google Calendar, Docs, Sheets) through MCP Clients and Servers. Think of it as the “bridge” between the bot and your tools. RAG (Retrieval‑Augmented Generation): A method where the AI retrieves information from documents before generating a response. This ensures answers are accurate and based on your actual data, not just the AI’s memory. ⚙️ Setup Instructions (step‑by‑step) Create a Telegram Bot Use BotFather to generate a bot and get the API token. Configure Google Services Make sure you have access to Google Calendar, Docs, and Sheets. Connect them via MCP Server so the agent can call these tools. Set up Redis Memory Create an Upstash Redis account. Configure it in the workflow to store conversation history. Import the Template into n8n Load the workflow and update credentials (Telegram, Google, Redis). Test the Bot Send a message like “Schedule laptop maintenance tomorrow” and check if it creates an event in Google Calendar. 🛠 Troubleshooting Section Bot not responding? Verify your Telegram API token is correct. Google services not working? Check that your MCP Server is running and properly connected to Calendar, Docs, and Sheets. Conversation context lost? Ensure Redis memory is configured and accessible. Wrong date/time? Confirm that relative dates (“tomorrow”, “next week”) are being converted into ISO format correctly. Customization Examples This template is flexible and can be adapted to different scenarios. Here are some ideas: Change the communication channel Replace the Telegram Trigger with WhatsApp, Slack, or a Webhook to fit your preferred platform. Expand document sources Connect additional Google Docs or Sheets, or integrate with other storage (e.g., Notion, Confluence, or internal databases) to broaden the bot’s knowledge base. Add new services Extend the workflow to handle more requests, such as booking meeting rooms, checking inventory, or creating support tickets. Personalize responses Customize the AI Agent’s tone and style to match your company’s branding (formal, friendly, or technical). Segment agents by role Create specialized agents (e.g., one for scheduling, one for pricing, one for troubleshooting) to keep the workflow modular and scalable. Integrate external APIs Connect to services like Google Calendar, CRM systems, or helpdesk platforms to automate more complex tasks.

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

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.

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.

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.