One-way sync between Telegram, Notion, Google Drive, and Google Sheets
One-way sync between Telegram, Notion, Google Drive, and Google Sheets Who is this for? This workflow is perfect for productivity-focused teams, remote workers, virtual assistants, and digital knowledge managers who receive documents, images, or notes through Telegram and want to automatically organize and store them in Notion, Google Drive, and Google Sheets—without any manual work. What problem is this workflow solving? Managing Telegram messages and media manually across different tools like Notion, Drive, and Sheets can be tedious. This workflow automates the classification and storage of incoming Telegram content, whether it’s a text note, an image, or a document. It saves time, reduces human error, and ensures that media is stored in the right place with metadata tracking. What this workflow does Triggers on a new Telegram message using the Telegram Trigger node. Classifies the message type using a Switch node: Text messages are appended to a Notion block. Images are converted to base64, uploaded to imgbb, and then added to Notion as toggle-image blocks. Documents are downloaded, uploaded to Google Drive, and the metadata is logged in Google Sheets. Sends a completion confirmation back to the original Telegram chat. Setup Telegram Bot: Set up a bot and get the API token. Notion Integration: Share access to your target Notion page/block. Use the Notion API credentials and block ID where content should be appended. Google Drive & Sheets: Connect the relevant accounts. Select the destination folder and spreadsheet. imgbb API: Obtain a free API key from imgbb. Replace placeholder credential IDs and asset URLs as needed in the imported workflow. How to customize this workflow to your needs Change Storage Locations: Update the Notion block ID or Google Drive folder ID. Switch Google Sheet to log in a different file or sheet. Add More Filters: Use additional Switch rules to handle other Telegram message types (like videos or voice messages). Modify Response Message: Personalize the Telegram confirmation text based on the file type or sender. Use a different image hosting service if you don’t want to use imgbb.
By Lakshit UkaniAutomate financial operations with O3 CFO & GPT-4.1-mini finance team
Automate Financial Operations with O3 CFO & GPT-4.1-mini Finance Team This workflow builds a virtual finance department inside n8n. At the center is a CFO Agent (O3 model) who acts like a strategic leader. When a financial request comes in, the CFO interprets it, decides the strategy, and delegates to the specialist agents (each powered by GPT-4.1-mini for cost efficiency). --- 🟢 Section 1 – Entry & Leadership Nodes: 💬 When chat message received → Entry point for user financial requests. 💼 CFO Agent (O3) → Acts as the Chief Financial Officer. Interprets the request, decides the approach, and delegates tasks. 💡 Think Tool → Helps the CFO brainstorm and refine financial strategies. 🧠 OpenAI Chat Model CFO (O3) → High-level reasoning engine for strategic leadership. ✅ Beginner view: Think of this as your finance CEO’s desk — requests land here, the CFO figures out what needs to be done, and the right specialists are assigned. --- 📊 Section 2 – Specialist Finance Agents Each specialist is powered by GPT-4.1-mini (fast + cost-effective). 📈 Financial Planning Analyst → Builds budgets, forecasts, and financial models. 📚 Accounting Specialist → Handles bookkeeping, tax prep, and compliance. 🏦 Treasury & Cash Management Specialist → Manages liquidity, banking, and cash flow. 📊 Financial Analyst → Runs KPI tracking, performance metrics, variance analysis. 💼 Investment & Risk Analyst → Performs investment evaluations, capital allocation, and risk management. 🔍 Internal Audit & Controls Specialist → Checks compliance, internal controls, and audits. ✅ Beginner view: This section is your finance department — every role you’d find in a real company, automated by AI. --- 📋 Section 3 – Flow of Execution User sends a request (e.g., “Create a financial forecast for Q1 2026”). CFO Agent (O3) interprets it → “We need planning, analysis, and treasury.” Delegates tasks to the relevant specialists. Specialists process in parallel, generating plans, numbers, and insights. CFO Agent compiles and returns a comprehensive financial report. ✅ Beginner view: The CFO is the conductor, and the specialists are the musicians. Together, they produce the financial “symphony.” --- 📊 Summary Table | Section | Key Roles | Model | Purpose | Beginner Benefit | | ---------------------- | ------------------------------------------------------- | ----------------- | ------------------- | -------------------------------------- | | 🟢 Entry & Leadership | CFO Agent, Think Tool | O3 | Strategic direction | Acts like a real CFO | | 📊 Finance Specialists | FP Analyst, Accounting, Treasury, FA, Investment, Audit | GPT-4.1-mini | Specialized tasks | Each agent = finance department role | | 📋 Execution Flow | All connected | O3 + GPT-4.1-mini | Collaboration | Output = complete financial management | --- 🌟 Why This Workflow Rocks Full finance department in n8n Strategic + execution separation → O3 for CFO, GPT-4.1-mini for team Cost-optimized → Heavy lifting done by mini models Scalable → Easily add more finance roles (tax, payroll, compliance, etc.) Practical outputs → Reports, budgets, risk analyses, audit notes --- 👉 Example Use Case: “Generate a Q1 financial forecast with cash flow analysis and risk report.” CFO reviews request. Financial Planning Analyst → Budget + Forecast. Treasury Specialist → Cash flow modeling. Investment Analyst → Risk review. Audit Specialist → Compliance check. CFO delivers a packaged financial report back to you. ---
By Yaron BeenCreate product satisfaction surveys with Telegram, Google Sheets and AI
This n8n template uses a Telegram chatbot to conduct a Product Satisfaction Survey and fetches questions and stores answers in a Google sheet. It augments an AI Agent to ask follow-up questions to engage the user and uncover more insights in their responses. This template is intended to demonstrate how you'd realistically approach a workflow where there is structured conversation (static questions) but you still want to include an free-form element (follow-up questions) which can only be accomplished via AI. Check out an example Survey results: https://docs.google.com/spreadsheets/d/e/2PACX-1vQWcREg75CzbZd8loVI12s-DzSTj3NE_02cOCpAh7umj0urazzYCfzPpYvvh7jqICWZteDTALzBO46i/pubhtml?gid=0&single=true How it works A chat session is started with the user who needs to enter the bot command "/next" to start the survey. Once started, the template pulls in questions from a google sheet to ask the user. Questions are asked in sequence from left column to right column. When the user answers the question, a text classifier node is used to determine if a follow-up question could be asked. If so, a mini conversation is initiated by the AI agent to get more details. If not, the survey proceeds to the next question. All answers and mini-conversations are recorded in the Google Sheet under the respective question. When all questions are answered, the template will stop the survey and give the user a chance to restart. How to use You'll need to setup a Telegram bot (see docs) Create a google sheet with an ID column. Populate the rest of the columns with your survey questions (see sample) Ensure you have a Redis instance to capture state. Either self-host or sign-up to Upstash for a free account. Update the "Set Variable" node with your google sheet ID and survey title. Share your bot to allow others to participate in your survey. Requirements Telegram for Chatbot Google Sheets for Survey questions and answers Redis for State Management and Chat Memory Community+ license and above for Execution data node - you can remove this node if you don't have this licence. Customising this workflow Not using Telegram? This template technically works with other chat apps such as Whatsapp, wechat and even n8n's hosted chat! This state management pattern can also be applied to other use-cases and scenarios. Try it for other types of surveys!
By JimleukBeginner Outlook calendar summary with OpenAI
A step-by-step demo that shows how to pull your Outlook calendar events for the week and ask GPT-4o to write a short summary. Along the way you’ll practice basic data-transform nodes (Code, Filter, Aggregate) and see where to attach the required API credentials. --- 1️⃣ Manual Trigger — Run Workflow | Why | Lets you click “Execute” in the n8n editor so you can test each change. | | --- | --- | --- 2️⃣ Get Outlook Events — Get many events Node type: Microsoft Outlook → Event → Get All Fields selected: subject, start API setup (inside this node): Click Credentials ▸ Microsoft Outlook OAuth2 API If you haven’t connected before: Choose “Microsoft Outlook OAuth2 API” → “Create New”. Sign in and grant the Calendars.Read permission. Save the credential (e.g., “Microsoft Outlook account”). Output: A list of events with the raw ISO start time. > Teaching moment: Outlook returns a full dateTime string. We’ll normalize it next so it’s easy to filter. --- 3️⃣ Normalize Dates — Convert to Date Format js // Code node contents return $input.all().map(item => { const startDateTime = new Date(item.json.start.dateTime); const formattedDate = startDateTime.toISOString().split('T')[0]; // YYYY-MM-DD return { json: { ...item.json, startDateFormatted: formattedDate } }; }); 4️⃣ Filter the Events Down to This Week After we’ve normalised the start date-time into a simple YYYY-MM-DD string, we drop in a Filter node. Add one rule for every day you want to keep—for example 2025-08-07 or 2025-08-08. Rows that match any of those dates will continue through the workflow; everything else is quietly discarded. Why we’re doing this: we only want to summarise tomorrow’s and the following day’s meetings, not the entire calendar. --- 5️⃣ Roll All Subjects Into a Single Item Next comes an Aggregate node. Tell it to aggregate the subject field and choose the option “Only aggregated fields.” The result is one clean item whose subject property is now a tidy list of every meeting title. It’s far easier (and cheaper) to pass one prompt to GPT than dozens of small ones. --- 6️⃣ Turn That List Into Plain Text Insert a small Code node right after the aggregation: js return [{ json: { text: items .map(item => JSON.stringify(item.json)) .join('\n') } }]; Need a Hand? I’m always happy to chat automation, n8n, or Outlook API quirks. Robert Breen – Automation Consultant & n8n Instructor 📧 robert@ynteractive.com | LinkedIn
By Robert BreenCheck To Do on Notion and send message on Slack
This workflow allows you to check the To-Do list on Notion and send a message on Slack. Prerequisites Create a Notion page similar to this page. Create credentials for Notion by following the instructions mentioned in the documentation. Follow the steps mentioned in the documentation to create credentials for Slack. Cron node: This node triggers the workflow every day. Notion node: This node fetches all the tasks from Notion. IF node: This node checks if the task is assigned to a particular user. Create a Direct Message: This node will create a direct message channel with the user. Send a Direct Message: This node will send the to-do lists in the direct message. NoOp: This node is connected to the false output of the IF node. If the condition is false, no further action will be taken.
By Harshil AgrawalSchedule & auto-post videos to Instagram, LinkedIn & TikTok with Google Sheets
Automated Social Media Video Posting 👥 Who's it for This workflow is perfect for content creators, social media managers, and businesses who want to schedule and automatically post videos 📹 to multiple platforms (Instagram, LinkedIn, TikTok) without manual effort. Save hours every week! ⏰ 🤖 What it does It automatically reads scheduled posts from Google Sheets, checks if it's the right time to post, downloads videos from Google Drive, uploads them to multiple social media platforms simultaneously, updates the posting status, and sends you a Telegram notification with the results. Complete hands-free social media management! 🚀 ⚙️ How it works ⏰ Schedule Trigger – Runs twice daily at 9 AM and 9 PM 📊 Google Sheets (Read) – Fetches posts with status "Listo para postear" (Ready to post) ⚙️ Code Node – Converts trigger time to readable Spanish format (e.g., "16 de Octubre a las 9 am") 🔍 If Condition – Checks if current time matches the scheduled post time in the sheet 📝 Format Drive Content – Extracts and organizes post data (Title, Copy, Video URL) 🆔 Social Media Account IDs – Prepares account identifiers (can be customized for specific accounts) 🎬 Upload a video – Posts video simultaneously to Instagram, LinkedIn, and TikTok using UploadPost API 📊 Google Sheets (Update) – Changes post status to "Posteado" (Posted) to avoid duplicates 📱 Telegram Notification – Sends detailed success report with URLs for each platform 📋 Requirements Google Sheets with your content calendar Google Drive to store your videos UploadPost API account (supports Instagram, LinkedIn, TikTok): Click aquí 👉 UploadPost Telegram Bot for notifications n8n instance with required node packages Google Sheets Structure Your spreadsheet should have these columns: Title – Post title Copy – Post caption/description Video Link – Google Drive download URL Status – Post status ("Listo para postear" or "Posteado") Fecha.Hora – Scheduled time (format: "16 de Octubre a las 9 am") row_number – Auto-generated row identifier 🛠️ How to set up Create your Google Sheets calendar: Set up columns as specified above Use status "Listo para postear" for scheduled posts Format dates as "DD de Mes a las HH am/pm" (Spanish format) Upload videos to Google Drive: Get shareable download links (format: https://drive.google.com/uc?export=download&id=FILE_ID) Ensure videos meet platform requirements (duration, format, size) Configure UploadPost API: Create account and get API credentials Connect your Instagram, LinkedIn, and TikTok accounts Add credentials to the "Upload a video" node Set up Google Sheets credentials: Connect OAuth2 for both read and update operations Update documentId with your spreadsheet ID Verify sheet name matches (default: "Video") Configure Telegram notifications: Create a Telegram bot via @BotFather Get your chat ID Add credentials to "Send a text message" node Customize posting times: Modify Schedule Trigger hours (default: 9 AM and 9 PM) Times are in Santiago, Chile timezone (America/Santiago) Test the workflow: Create a test entry with current time Run manually to verify all connections work Check Telegram for success notification Activate the workflow ✅ 🎨 How to customize Change posting schedule: Modify triggerAtHour values in Schedule Trigger (add more times if needed) Add more platforms: Extend the platform array in "Upload a video" node (supports YouTube, Facebook, Twitter) Customize notification format: Edit the Telegram message template to include/exclude information Change timezone: Modify the timeZone parameter in the Code node (default: "America/Santiago") Filter by platform: Add a filter node before upload to post only to specific platforms on certain days Add approval workflow: Insert an approval step before posting using Telegram or Slack Multiple accounts per platform: Modify "Social Media Account IDs" node to specify different account IDs Error handling: Add error notification paths to alert you if uploads fail Batch posting: Remove returnFirstMatch option to post multiple videos at once 💡 Pro Tips Time format must match exactly between Schedule Trigger and Google Sheets for the workflow to trigger Videos should be optimized for each platform before upload (aspect ratio, length, file size) Test with a private account first before going live Keep video files under 100MB for best performance across platforms Use the row_number column to track and update specific posts The workflow runs twice daily, so schedule posts accordingly (9 AM or 9 PM slots) ⚠️ Important Notes Posts marked as "Posteado" won't be processed again (prevents duplicates) Video must be publicly accessible from the Google Drive link UploadPost API has rate limits depending on your plan Telegram notifications show success status and post URLs for each platform The Code node converts times to Spanish format - modify if you need different language/format
By Jose BossaAutomate SEO analysis for multiple domains with Ahrefs and Google Sheets
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Fetch SEO and traffic information from ahref for a list of domains in a Google Sheet. This is great for marketing research and SEO workflow optimizations and saves tons of time. How it works We'll import domains from the Google sheet We use an SEO MCP server to fetch data from ahref free tooling The fetched data is stored in the Google sheet Set up steps Copy Google Sheet template and add it in all Google Sheet nodes Make sure that n8n has read & write permissions for your Google sheet. Add your list of domains in the first column in the Google sheet Add MCP credentials for seo-mcp
By Michael MuenzerFull blog content automation with GPT-4, Claude & Ghost CMS publisher
🌟 Complete Workflow Overview The Full Blogging Automation Journey This N8N workflow transforms a simple topic request into a fully published, SEO-optimized blog post through a seamless 7-phase process. Starting with your topic idea, the system automatically researches, creates, optimizes, edits, and publishes professional content to your Ghost CMS website. Think of it as having an entire content team working 24/7 - from initial research to final publication, all orchestrated by AI agents working in perfect harmony. No more writer's block, no more SEO guesswork, just high-quality content that ranks and engages your audience 📋 Requirements & Setup What You Need to Get Started OpenAI API Key - For GPT models (content generation) Anthropic API Key - For Claude models as failover model Brave Search API Key - For comprehensive research Ghost CMS Admin API Access - For direct publishing Existing Blog Content - Optional but recommended for better research 🔧 Workflow Architecture & Process How the AI Agents Work Together This N8N workflow implements a sophisticated multi-agent system where specialized AI agents collaborate through structured data exchange. The workflow uses HTTP Request nodes to communicate with OpenAI and Anthropic APIs, integrates with Brave Search for real-time research, and connects to Ghost CMS via REST API calls. Each agent operates independently but shares data through N8N's workflow context, ensuring seamless information flow from research to publication. The system includes error handling, retry logic, and quality gates at each stage to maintain content standards.
By Christian MendietaAutomated invoice management with Nextcloud, email and Telegram notifications
This workflow automatically fetches PDF invoices from a Nextcloud folder (/Invoice/Incoming), sends them via email to a fixed recipient (invoice@example.com), sends a Telegram notification, and archives the file to /Invoice/2025/archive. Key Steps: Triggered daily at 8 AM Lists files in /Invoice/Incoming Filters for existing entries Downloads the file Sends the invoice via email Sends a Telegram message with filename Moves the file to archive 📦 Technologies used: Nextcloud SMTP Email Telegram Bot ⚙️ Use case: Perfect for freelancers or small businesses to automate recurring invoice sending with minimal effort.
By Joachim HummelTesla quant technical indicators webhooks tool
📡 This workflow serves as the central Alpha Vantage API fetcher for Tesla trading indicators, delivering cleaned 20-point JSON outputs for three timeframes: 15min, 1hour, and 1day. It is required by the following agents: Tesla 15min, 1h, 1d Indicators Tools Tesla Financial Market Data Analyst Tool ✅ Requires an Alpha Vantage Premium API Key 🚀 Used as a sub-agent via webhook endpoints triggered by other workflows --- 📈 What It Does For each timeframe (15min, 1h, 1d), this tool: Triggers 6 technical indicators via Alpha Vantage: RSI MACD BBANDS SMA EMA ADX Trims the raw response to the latest 20 data points Reformats into a clean JSON structure: json { "indicator": "MACD", "timeframe": "1hour", "data": { "timestamp": "...", "macd": 0.32, "signal": 0.29 } } Returns results via Webhook Respond for the calling agent --- 📂 Required Credentials 🔑 Alpha Vantage Premium API Key Set up under Credentials > HTTP Query Auth Name: Alpha Vantage Premium Query Param: apikey Get yours here: https://www.alphavantage.co/premium/ --- 🛠️ Setup Steps Import Workflow into n8n Name it: TeslaQuantTechnicalIndicatorsWebhooks_Tool Add HTTP Query Auth Credential Name: Alpha Vantage Premium Param key: apikey Value: your Alpha Vantage key Publish and Use the Webhooks This workflow exposes 3 endpoints: /15minData → used by 15m Indicator Tool /1hourData → used by 1h Indicator Tool /1dayData → used by 1d Indicator Tool Connect via Execute Workflow or HTTP Request Ensure caller sends webhook trigger correctly to the path --- 🧱 Architecture Summary Each timeframe section includes: | Component | Details | | ------------------ | --------------------------------------------- | | 📡 Webhook Trigger | Entry node (/15minData, /1hourData, etc.) | | 🔄 API Calls | 6 nodes fetching indicators via Alpha Vantage | | 🧹 Formatters | JS Code nodes to clean and trim responses | | 🧩 Merge Node | Consolidates cleaned JSONs | | 🚀 Webhook Respond | Returns structured data to calling workflow | --- 🧾 Sticky Notes Overview ✅ Webhook Entry: Instructions per timeframe ✅ API Call Summary: Alpha Vantage endpoint for each indicator ✅ Format Nodes: Explain JSON parsing and cleaning ✅ Merge Logic: Final output format ✅ Webhook Response: What gets returned to caller All stickies follow n8n standard color-coding: Blue = Webhook flow Yellow = API request group Purple = Formatters Green = Merge step Gray = Workflow overview and usage --- 🔐 Licensing & Support © 2025 Treasurium Capital Limited Company This agent is part of the Tesla Quant AI Trading System and protected under U.S. copyright. For support: 🔗 Don Jayamaha – LinkedIn 🔗 n8n Creator Profile --- 🚀 Use this API tool to feed Tesla technical indicators into any AI or trading agent across 15m, 1h, and 1d timeframes. Required for all Tesla Quant Agent indicator tools.
By Don Jayamaha JrAutomate lead qualification & customer support with GPT-4o-mini agents
Beginner AI Agent Duo: Lead‑Qualifier Task Automator & Ecommerce Chatbot Status: Ready for Use ✅ Note: This template is built entirely with official n8n nodes—no community‑node installation required. --- 📝 Description This template demonstrates two beginner‑friendly AI‑agent patterns that cover the most common use cases: | Agent | Purpose | Flow Highlights | |-------|---------|-----------------| | Lead‑Qualifier Task Automator | Classifies phone‑call transcripts to decide if the caller is a good bulk‑order lead. | Manual Trigger → Code (sample data) → AI Agent (GPT‑4o‑mini) → Structured Output Parser → Set (clean fields) | | Ecommerce Chatbot | Answers customer questions about products, bulk pricing, shipping, and returns. | Chat Trigger (webhook) → AI Agent (GPT‑4o‑mini) with Memory → If node → Order‑placed reply or no‑op | Both agents run on GPT‑4o‑mini and use n8n’s LangChain‑powered nodes for quick, low‑code configuration. --- ⚙️ How to Install & Run Import the Workflow In n8n, go to Workflows → Import from File or Paste JSON, then save. Add Your OpenAI API Key Go to Credentials → New → OpenAI API. Paste your key from <https://platform.openai.com>. Select this credential in both OpenAI Chat Model nodes. (Optional) Select a Different Model Default model is gpt‑4o‑mini. Change to GPT‑4o, GPT‑3.5‑turbo, or any available model in each OpenAI node. Test the Lead‑Qualifier Agent Click Activate. Press Test workflow. The Code node feeds four sample transcripts; the AI Agent returns JSON like: json { "Name": "Jordan Lee", "Is Good Lead": "Yes", "Reasoning": "Customer requests 300 custom mugs, indicating a bulk order." } Test the Ecommerce Chatbot Copy the Webhook URL from the When chat message received trigger. POST a payload like: json { "message": "Hi, do you offer discounts if I buy 120 notebooks?" } The AI Agent replies with bulk‑pricing info. If the customer confirms an order, it appends *; the If node then sends “Your order has been placed”. --- 🧩 Customization Ideas Refine Qualification Logic Edit the Task Agent’s system prompt to match your own lead criteria. Save Leads Automatically Add Google Sheets, Airtable, or a database node after the Set node. Expand the Chatbot Connect inventory APIs, payment gateways, or CRM integrations. Adjust Memory Length Change the Simple Memory node’s window to retain more conversation context. --- 🤝 Connect with Me Description I’m Robert Breen, founder of Ynteractive — a consulting firm that helps businesses automate operations using n8n, AI agents, and custom workflows. I’ve helped clients build everything from intelligent chatbots to complex sales automations, and I’m always excited to collaborate or support new projects. If you found this workflow helpful or want to talk through an idea, I’d love to hear from you. Links 🌐 Website: https://www.ynteractive.com 📺 YouTube: @ynteractivetraining 💼 LinkedIn: https://www.linkedin.com/in/robert-breen 📬 Email: rbreen@ynteractive.com
By Robert BreenSeo keyword analysis and filter
Use case This workflow is designed for e-commerce brands and content teams who: Need to scale SEO content production without sacrificing quality Want to eliminate manual keyword filtering (saves 10+ hours/week) Aim to dominate niche search terms (e.g., "vegan leather crossbody bags") What this workflow does Automates the end-to-end process from keyword discovery to publish-ready articles: Keyword Harvesting: Pulls 1,000+ keywords/day from SEMrush/Ahrefs Smart Filtering:Blocks competitor brands (e.g., "Zara alternatives") Detects irrelevant demographics ("kids", "petite") AI Content Generation:Flags non-compliant colors (non-black/white terms) Multi-Channel Output: Formats content for blogs, product descriptions, and email campaigns setup Add Google,SEMrush and OpenAI credentials Set the rules excel of google drive Test workflow by testing workflow Review generated opportunity report in Google Sheets How to adjust this template Change scenario: Replace the rules and define different target
By Alex Huang