Oussama
Workflows by Oussama
Capture and organize ideas via Telegram with GPT-4 & Google Sheets
This n8n template creates an intelligent **Ideation Agent** 🤖 that captures your ideas from text and voice notes sent via Telegram. The assistant automatically transcribes your voice memos, analyzes the content with a powerful AI, and organizes it into a structured Google Sheet database. It's the perfect workflow for capturing inspiration whenever it strikes, just by talking or typing 💡. ### **Use Cases:** * 🗣️ **Text-Based Capture:** Send any idea as a simple text message to your Telegram bot for instant processing. * 🎙️ **Voice-to-Idea:** Record voice notes on the go. The workflow transcribes them into text and categorizes them automatically. * 📂 **Automated Organization:** The AI agent intelligently structures each idea with a title, description, score, category, and priority level without any manual effort. * 📊 **Centralized Database:** Build a comprehensive and well-organized library of all your ideas in Google Sheets, making it easy to search, review, and act upon them. ### **How it works:** 1. **Multi-Modal Input:** The workflow starts with a `Telegram Trigger` that listens for incoming text messages and voice notes. 2. **Content-Based Routing:** A `Switch` node detects the message type. Text messages are sent directly for processing, while audio files are routed for transcription. 3. **Voice Transcription:** Voice messages are sent to the **ElevenLabs API**, which accurately converts the speech into text. 4. **Unified Input:** Both the original text and the transcribed audio are passed to the AI Agent in a consistent format. 5. **AI Analysis & Structuring:** An `AI Agent`, receives the text. It follows a detailed system prompt to analyze the idea and structure it into predefined fields: Idea, Idea Description, Idea Type, Score, Category, Priority, Status, and Complexity. 6. **Data Storage:** The agent uses the **Google Sheets Tool** (`add_row_tool`) to seamlessly add the fully structured idea as a new row in your designated spreadsheet. 7. **Instant Confirmation:** Once the idea is saved, the workflow sends a confirmation message back to you on Telegram, summarizing the captured idea. ### **Requirements:** * 🌐 A **Telegram Bot API** token. * 🤖 An **AI provider** with API access (the template uses Azure OpenAI, but can be adapted). * 🗣️ An **ElevenLabs API** key for voice-to-text transcription. * 📝 **Google Sheets API** credentials to connect to your database. ### **Good to know:** * ⚠️ Before you start, make sure your Google Sheet has columns that exactly match the fields defined in the Agent's system prompt (e.g., `"Idea "`, `"Idea Description "`, `"Idea Type"`, etc.). Note that some have a trailing space in the template. * 🎤 The quality of the voice transcription is dependent on the clarity of your recorded audio. * ✅ You can completely customize the AI's behavior, including all the categories, types, and scoring logic, by editing the system prompt in the `Agent` node. ### **Customizing this workflow:** * ✏️ **Modify Categories:** To change the available `Idea Type`, `Category/Domain`, or `Priority Level` options, simply edit the list within the `Agent` node's system prompt. * 🔄 **Swap LLM:** You can easily change the AI model by replacing the `Azure OpenAI Chat Model` node with another one, such as the standard OpenAI node or a local AI model. * 🔗 **Change Database:** To save ideas to a different platform, just replace the `add_row_tool1` (Google Sheets Tool) with a tool for another service like Notion, Airtable, or a database.
Multi-modal expense tracking with GPT-4, Gemini OCR, and voice via Telegram
This n8n template creates an **intelligent expense tracking system** 🤖 that processes text, voice, and receipt images through Telegram. The assistant automatically **categorizes expenses**, **handles currency conversions** 🌍, and **maintains financial records** in Google Sheets while **providing smart spending insights** 💡. ### Use Cases: - 🗣️ Personal expense tracking via Telegram chat - 🧾 Receipt scanning and data extraction - 💱 Multi-currency expense management - 📂 Automated financial categorization - 🎙️ Voice-to-expense logging - 📊 Daily/weekly/monthly spending analysis ### How it works: 1. **Multi-Input Processing**: Telegram trigger captures text messages, voice notes, and receipt images. 2. **Content Analysis**: A Switch node routes different input types (text, audio, images) to appropriate processors. 3. **Voice Processing**: ElevenLabs converts voice messages to text for expense extraction. 4. **Receipt OCR**: Google Gemini analyzes receipt images to extract amounts and descriptions. 5. **Expense Classification**: An LLM determines if the input is an expense or a general query. 6. **Expense Parsing**: For multiple expenses, the AI splits and normalizes each item. 7. **Currency Conversion**: An exchange rate API converts foreign currencies to USD. 8. **Smart Categorization**: The AI agent assigns expenses to predefined categories with emojis. 9. **Data Storage**: Google Sheets stores all expense records with automatic totals. 10. **Intelligent Responses**: The agent provides spending summaries, alerts, and financial insights. ### Requirements: - 🌐 Telegram Bot API access - 🤖 OpenAI, Gemini, or any other AI model - 🗣️ ElevenLabs API for voice processing - 📝 Google Sheets API access - 💹 Exchange rate API access ### Good to know: - ⚠️ Daily spending alerts trigger when expenses exceed 100 USD. - 🏷️ Supports 12 predefined expense categories with emoji indicators. - 🔄 Automatic currency detection and conversion to USD. - 🎤 Voice messages are processed through speech-to-text. - 📸 Receipt images are analyzed using computer vision. ### Customizing this workflow: - ✏️ Modify expense categories in the system prompt. - 📈 Adjust spending alert thresholds. - 💵 Change the base currency from USD to your preferred currency. - ✅ Add additional expense validation rules. - 🔗 Integrate with other financial platforms.
Telegram AI assistant with rate limiting and auto-reset using Google Sheets
Production-ready solution for controlling AI agent usage and preventing abuse while managing costs. 🎯 **Problem Solved** Unlimited AI interactions → Excessive API costs Service abuse → Uncontrolled resource consumption No built-in limits → Need for usage quotas ✅ **Solution Overview** *Two-Part System:* **Main Flow:** User interaction tracking + AI responses **Reset Flow:** Automated counter resets 🔄 **How It Works** **User Message → Track Counter → Check Limit → Allow/Block → AI Response** 🛠️ **Core Components** *Main Workflow* 📱 Telegram Trigger - Receives user messages 📊 Google Sheets Counter - Tracks messages per user 🔀 Switch Logic - Checks limits (default: 3 messages) 🤖 AI Agent - Processes allowed interactions 💬 Smart Responses - Delivers AI answers or limit warnings *Auto-Reset System* ⏰ Schedule Trigger - Runs every configurable interval 🔄 Bulk Counter Reset - Resets all users to 0 ⚙️ **Configuration** *Message Limits* Modify Switch Node conditions: > 3 messages → Block silently = 3 messages → Send limit warning < 3 messages → Allow AI response *Reset Schedules* Testing: Every 1 minute Hourly: 0 * * * * Daily: 0 0 * * * Weekly: 0 0 * * 0 📋 **Setup Requirements** Credentials Needed: 🤖 Telegram Bot Token 📊 Google Sheets API 🧠 AI Model *Google Sheets Structure: *Column A: User ID (Telegram chat.id) Column B: Message Counter 🎯 **Perfect For** 💰 Cost Control - Prevent runaway API costs 🛡️ Demo/Trial Bots - Limited interactions 🏢 Customer Service - Usage quotas 🎓 Educational Bots - Daily limits 🚫 Anti-Abuse - Fair usage policies 🚀 **Key Benefits** ✅ Cost Management - Control AI API expenses ✅ Fair Access - Equal usage for all users ✅ Production Ready - Robust error handling ✅ Flexible Limits - Easy adjustment ✅ Auto-Reset - No manual intervention ✅ User-Friendly - Clear limit messages 📝 **Quick Customization** **Adjust Limits**: Change Switch node values **Reset Timing**: Modify Schedule Trigger **Custom Messages**: Edit Telegram response nodes **User Tiers**: Add columns to Google Sheets