Telegram to Google Drive: Auto Upload & Track Videos with Gemini AI Assistant

Description

🚀 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