🚀 Overview
This workflow automates video uploads from Telegram directly to Google Drive, complete with smart file renaming, Google Sheets logging, and AI assistance via Google Gemini. It’s perfect for creators, educators, or organizations that want to streamline video submissions and file management.
⚙️ How It Works
- Telegram Trigger -> Start the workflow when a user sends a video file to your Telegram bot.
- Switch Node -> Detects file type or command and routes the flow accordingly.
- Get File -> Downloads the Telegram video file.
- Upload to Google Drive -> Automatically uploads the video to your chosen Drive folder.
- Smart Rename -> The file name is auto-formatted using dynamic logic (date, username, or custom tags).
- Google Sheets Logging -> Appends or updates upload data (e.g., filename, sender, timestamp) for easy tracking.
- AI Agent Integration -> Uses Google Gemini AI connected to Data Vidio memory to analyze or respond intelligently to user queries.
- Telegram Notification -> Sends confirmation or status messages back to Telegram.
🧠 Highlights
- Seamlessly integrates Telegram → Google Drive → Google Sheets → Gemini AI
- Supports file update or append mode
- Auto-rename logic via the Code node
- Works with custom memory tools for smarter AI responses
- Easy to clone and adapt, just connect your own credentials
🪄 Ideal Use Cases
- Video assignment submissions for schools or academies
- Media upload management for marketing teams
- Automated video archiving and AI-assisted review
- Personal Telegram-to-Drive backup assistant
🧩 Setup Tips
- Copy and use the provided Google Sheet template (SheetTemplate)
- Configure your Telegram Bot token, Google Drive, and Sheets credentials
- Update the AI Agent node with your Gemini API key and connect the Data Vidio sheet
- Test with a sample Telegram video before full automation