Quick Overview
This workflow watches Google Sheets for new video ideas, uses Google Gemini to generate a Veo 3.1 short, sends it to Telegram for approval, and when approved publishes it to TikTok, Instagram Reels, and YouTube Shorts via PostWire while logging results back to Google Sheets.
How it works
- Triggers when a new row is added to a Google Sheets document.
- Filters to rows that contain an idea and have an empty status so only unprocessed ideas continue.
- Uses Google Gemini to turn the idea into a Veo prompt plus platform-specific captions and a YouTube title/description.
- Requests an upload URL from PostWire, generates an 8‑second 9:16 video with Veo 3.1, uploads the file to PostWire, and finalizes it to get a media URL.
- Sends the rendered video and captions to Telegram and waits for an Approve or Decline response.
- If approved, publishes the video to TikTok, Instagram, and YouTube via PostWire with per-platform text and title, then updates Google Sheets and sends either the published links or any required fixes back to Telegram.
- If declined, updates the Google Sheets row to declined with a timestamp note.
Setup
- Create a PostWire account, connect your TikTok/Instagram/YouTube accounts, and add an HTTP Header Auth credential in n8n with
Authorization: Bearer <your PostWire API key> for the PostWire HTTP requests.
- Add Google Sheets OAuth credentials and select the target document and sheet in the trigger and all Google Sheets update steps, ensuring columns exist for
idea, status, links, and note.
- Add Google Gemini credentials with billing enabled and ensure the workflow has access to the Gemini model used for planning and the Veo 3.1 model used for video generation.
- Create a Telegram bot, add Telegram credentials in n8n, and replace
YOUR_CHAT_ID with your chat ID so approvals and results are delivered to the right conversation.