100% Automated Trending Video ; Multi-Platform Posting System

This template is designed for creators, agencies, solopreneurs, and brands that want daily viral-style content without spending hours on research, scripting, editing, and posting.

1. Intelligent Topic Discovery (No More Guessing) The system begins in Google Sheets:

Reads your niche or theme from a “Theme” sheet (e.g., “AI automation for business”, “fitness for busy dads”).

Looks at the “Search” sheet to see which topics/search terms you’ve already used, so it doesn’t repeat content.

Uses OpenAI GPT-4o to generate a fresh YouTube search term your audience would actually type, while avoiding duplicates and varying the term length between 3–5 words for natural search behavior.

Every run = a new, unique angle inside your niche.

2. Viral Filter Using YouTube Data (View vs. Subscriber Logic) Next, the system queries the YouTube Data API:

Searches for videos matching the new search term and pulls the top results sorted by view count.

For each candidate video, it fetches:

Video statistics (views, etc.)

Channel statistics (subscriber count)

A built-in “Trending Video Filter” then compares:

video view count vs. channel subscriber count

Only videos where views are greater than subscribers pass—this means the system is selecting content that’s over-performing for that channel, a strong signal of viral potential.

3. Transcript Extraction & Key Idea Summarization For the winning video:

The automation calls a YouTube transcript API via RapidAPI to fetch a detailed transcript.

OpenAI GPT-4o-mini then:

Summarizes the video in ~150 words

Highlights the most important quotes

Extracts the core lessons into a clear bullet list

This gives you a distilled “idea core” from proven viral content.

All of this is logged into a “Topic” sheet for tracking and reuse.

4. Viral Instagram Reel Script + Caption Generation Using the summary and original video title, the system generates:

A viral reel script

Uses GPT-4o to imitate a proven high-converting script structure (hook + numbered steps + CTA).

Ensures sentence count and structure match the example script.

Formats it with “/” before every sentence so it can be split into lines automatically for overlays and voiceover.

A viral caption for Instagram

Mimics a proven caption pattern:

Strong comment CTA

Simple explanation of the benefit

Save/Share CTA

Hashtag block

Automatically tuned to the specific topic and video title.

Both the script and caption are saved into a “Video” sheet for full content tracking.

5. AI Voiceover Creation with ElevenLabs To avoid manual recording, the system:

Splits the reel script into sentences using the “/” separators.

Takes the first 5 key lines and sends them to ElevenLabs using a multilingual, high-quality voice model.

ElevenLabs returns a natural, human-like voiceover file (audio).

This audio is then:

Uploaded to Google Drive

Given a public share link so it can be used in the final video render.

6. Stock Video & Cinematic Storytelling via Pexels + Creatomate To create scroll-stopping visuals:

The automation calls the Pexels Videos API using your niche as the search query (from the “Theme” sheet).

Randomly selects one video from the results for variation (using a shuffle + first selection logic).

Then, it sends everything to Creatomate:

Template ID (your pre-built story/reel template)

Modifications:

Audio: Google Drive share link of the ElevenLabs voiceover

Video: Pexels stock video URL

Text-1 → Text-5: The first five sentences of your script as on-screen captions

Creatomate then renders a complete vertical video:

AI voiceover

Dynamic text overlays

Stock B-roll background

No editing software is ever opened.

7. Multi-Platform Distribution (Omni-Channel Posting) Once the video is ready, the automation fan-distributes it across multiple channels via a router:

LinkedIn – Uploads as a native video post with your generated caption.

X (Twitter) – Uploads media and posts a tweet using one of the key transcript lines as the text.

Instagram Reels – Publishes a reel to your business account using the Creatomate video URL and AI caption.

YouTube – Uploads as a video with:

Title from the first transcript sentence

Description from the AI caption

Category and visibility preconfigured.

Facebook Page – Uploads the video file directly with your caption.

Email Delivery for TikTok – Sends you an email via Gmail with:

The video file attached

The caption text in the body (so you can paste it into TikTok).

All of this happens in one automated roundtrip.

8. Centralized Tracking in Google Sheets Throughout the workflow, the system keeps your Google Sheets updated:

“Search” sheet – Every new YouTube search term used.

“Topic” sheet – Video ideas, summaries, key lessons.

“Video” sheet – Scripts, captions, video status, and metadata.

This turns your Google Sheets into a content operations dashboard for your viral clips.

Tools Used in This Automation Based on the JSON flow:

Make (Scenario Orchestration)

Google Sheets

Get cell (Theme)

Filter rows (Search)

Add row (Search, Topic, Video)

Update row (Video)

OpenAI (via Make’s OpenAI module)

GPT-4o for search term generation, reel script, and caption

GPT-4o-mini for YouTube summary and key lessons

HTTP / API Modules

YouTube Data API (search, videos statistics, channels statistics)

RapidAPI – YouTube Transcript / Summarizer endpoint

Pexels Videos API

HTTP Get File for downloading final videos

JSON Parse & Utility Modules

JSON:ParseJSON for API responses

BasicFeeder for looping items

TextAggregator for joining existing search terms

SetVariable for “Transcript sentences” and “Random Video”

ElevenLabs – Text-to-Speech (voiceover)

Google Drive – Upload audio, generate shareable links

Creatomate – RenderTemplate for final video creation

LinkedIn API – CreateVideoPost

Twitter / X API – Upload media + Create Tweet

Instagram Business API – Create Reels

YouTube API – Upload Video

Facebook Pages API – Upload Video

Gmail (Google Email) – Send email with video attached

Ideal For

Content creators who want daily viral-style short videos

Coaches, consultants, and info businesses building authority

Agencies delivering content packages to clients

Faceless brand channels across YouTube Shorts, IG Reels, TikTok

Anyone who wants one system that handles ideation, scripting, voiceover, video creation, and posting

This is not a “preset filter” or one simple automation.It’s a full viral video production and distribution pipeline that runs on autopilot from a single Google Sheet.