Chat with your event schedule from Google Sheets in Telegram
What it is Chat with your event schedule from Google Sheets in Telegram: "When is the next meetup?" "How many events are there next month?" "Who presented most often?" "Which future meetups have no presenters yet?" This workflow lets you chat with a telegram bot about past, present and future events that are scheduled in a Google Spreadsheet. (Info: This proof-of-concept was created as a demo for a hackathon of an AI & Developer Meetup in Da Nang (Vietnam) that uses a telegram group to organize) Who it is for If you want an easy way for your audience to get information about your events, you can us this workflow for the same purpose, or easily adapt it to your needs and different use-cases where you want to query smaller amounts of tabular data in natural language. How it works Upon getting triggered by a chat message to a telegram bot, the schedule of meetups is retrieved from Google Spreadsheets, converted into a markdown table syntax and fed into the system prompt of an LLM (we're using OpenRouter in this example), whose output is posted back as answer into the same telegram chat. Setup steps TO REVIEWING IN ACTION As the reviewer of this workflow, you can temporarily use it via an existing telegram bot, simply point your telegram client to https://t.me/AiDaNangBot and start to ask questions like: "When is the next meetup?" "What future meetings do not have presenters?" "Who presented on Future of Human Relationships?" To build upon this workflow: Import the workflow Customize the Google Docs credentials for your individual access Create a telegram bot and connect it to the workflow by entering its API token into the credentials used in the telegram trigger node In the "Settings" node, replace the "scheduleURL" with the URL of your own copy of the Google Spreadsheet or a copy of the Event Schedule Template Sheet to spin off your own – whereby the structure of the spreadsheet doesn't matter, it's just important that you semantically structure your information in dedicated columns clearly labeled in the header row.
By Daniel NoldeBulk auto-publish videos to social networks with AI copy and client approval
This workflow automates batch video publishing prep from a Google Drive folder with AI-generated, platform-specific copy and a simple approval queue in Google Sheets. Perfect for Agencies, content creators or Teams --- What This Workflow Does Fetches videos from a Google Drive folder You provide a folder ID and the workflow lists all files, filtering to keep only .mp4. Builds a simple publishing calendar You configure: Start date Cadence (daily, 5/week, 3/week) Timezone One Publish Hour shared across all selected platforms The workflow creates: Schedule Date Schedule DateTime for each video Analyzes each video with AI Gemini performs a structured analysis of the video to understand: What happens in the content Key topics Tone Audience intent Generates platform-specific social copy For each video, the AI creates unique text for: TikTok Instagram Reels YouTube Shorts The prompts are language-aware: If the video is in English, the titles/descriptions are generated in English. If the video is in Spanish, they are generated in Spanish. Saves everything to Google Sheets as drafts Each video becomes one row with: Titles, descriptions, hashtags/tags A single shared Schedule DateTime Status = draft Auto-publishes approved rows (Flow 2) Every hour: Loads the sheet Filters rows where Status = approved Downloads the Drive file Schedules the video to the selected platforms Updates Status = scheduled --- Sheet Structure The tracking sheet is designed to be a clean approval queue. Recommended columns: Video ID Video Name Index Status Schedule Date Schedule DateTime TikTok Title TikTok Description TikTok Hashtags Instagram Title Instagram Description Instagram Hashtags YouTube Title YouTube Description YouTube Tags Summary Profile Platforms Created At --- How Approval Works New rows start as draft. You revise any copy directly in Sheets. When ready, change Status to approved. Flow 2 schedules the video and updates the row. --- Requirements Google Drive access Google Sheets access Gemini API key Upload-Post account with connected social profiles --- Installation & Setup Create your tracking sheet Copy this sheet in your drive https://docs.google.com/spreadsheets/d/1cegJHxj7Kx4Tg8gMr3uixpzToNc62VEvuuz37iFvnRw/edit?usp=sharing Connect credentials in n8n Google Drive OAuth Google Sheets OAuth Gemini credentials Upload-Post credentials Run the form Provide: Drive Folder ID Profile Username Platforms Timezone Start Date Cadence Publish Hour Google Sheet ID If you want to explore the API used for publishing These docs can help for custom extensions: social media API --- Ideal Use Cases Creators batching Shorts/Reels/TikToks and wanting a single approval queue Agencies that need a simple client-friendly review workflow Teams building internal content ops with predictable scheduling --- Notes This version keeps scheduling simple with one Schedule DateTime per video shared across all selected platforms. If you later want per-platform times, extend the calendar builder to generate separate datetimes again.
By Juan Carlos Cavero Gracia