Latenode
Google sheets
OpenAI GPT Assistants
Creatomate
Google drive
Discord bot

Automate video content creation and multi-platform distribution

This comprehensive automation template orchestrates an end-to-end workflow for generating AI-powered short-form videos and publishing them across multiple social media platforms.

It takes video ideas from a Google Sheet, generates captions, images, voiceovers, and video clips using various AI services, combines them into finished videos, and automatically uploads the videos to popular social media channels like TikTok, Instagram, YouTube, Facebook, and LinkedIn. The template also updates the original Google Sheet with output details and sends a completion notification via Discord, providing a fully automated solution for businesses or creators looking to streamline their video content production and distribution processes.

Updated Apr 2, 2026Est. run: 49sEst. cost: $0.0031
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Social media

Workflow preview

What this template does

  • Extracts video ideas from a Google Sheet
  • Generates captions, images, voiceovers, and video clips using AI services
  • Combines the generated assets into finished videos
  • Uploads the videos to multiple social media platforms
  • Updates the original Google Sheet with output details
  • Sends a completion notification via Discord

How it works

1
Trigger

Fetch new video ideas from Google Sheet

The workflow starts by retrieving new video ideas from a Google Sheet. This sheet acts as the trigger, providing the content to kickstart the automation process.

2
AI

Generate Captions & Prompts

The video ideas from the Google Sheet are then passed to OpenAI, which generates captions and image prompts to accompany the video content.

3
Action

Generate Video Clips

The captions, prompts, and video ideas are sent to Creatomate, which converts the image prompts into short video clips.

4
AI

Generate Voiceover

OpenAI is then used to generate a voiceover script and audio based on the video ideas and captions.

5
Action

Combine Assets

Creatomate is used again to combine the video clips, captions, and voiceover into a finished video asset.

6
Action

Store Video Assets

The generated video and audio files are uploaded to Google Drive for storage and further processing.

7
AI

Generate Social Descriptions

OpenAI is used to generate platform-specific video descriptions for the finished videos, tailored for different social media channels.

8
Action

Notify Completion

Finally, a Discord bot is used to send a notification message indicating that the video generation and publishing process has been completed.

Setup guide

1

Add Google Sheets credential

Add your Google Sheets credentials using the Latenode Credentials panel. Enable the Google Sheets API and configure the credential with the necessary scopes to read and write data to your Google Sheets.

2

Configure Google Drive nodes

In the Latenode visual builder, add the Google Drive nodes and configure the folder IDs and permissions to allow the workflow to upload generated content to your Google Drive.

3

Set up OpenAI credentials

Add your OpenAI API key as a credential in the Latenode Credentials panel. This will allow the workflow to use the OpenAI services for generating captions, image prompts, and voiceover scripts.

4

Configure Creatomate video template

Create a Creatomate video template in the Latenode visual builder and configure it to combine the generated video clips, captions, and voiceover audio into the final video output.

5

Set up upload-post.com credentials

Add your upload-post.com user identifier and platform details as credentials in the Latenode Credentials panel. This will allow the workflow to upload the final videos to the various social media platforms.

Requirements

Google Sheets API access to read video ideas and update output details
Google Drive API access to upload generated video files
Creatomate API key to generate video clips, captions, images, and voiceovers using AI
OpenAI API key to generate video scripts and descriptions using GPT-3

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Social media

Automate and schedule recurring Instagram post liking

This automated workflow allows Instagram users to schedule recurring post liking on a 2-hourly schedule. It uses Phantombuster to scrape recent posts under AI-generated hashtags, GPT-4o for intelligent hashtag selection, and a rotating set of Instagram session cookies to distribute likes across multiple accounts while staying within platform limits. The workflow uploads the posts to be liked to a SharePoint repository, then triggers the Phantombuster 'Auto-like Agent' to interact with the selected content. This streamlined approach helps Instagram users boost engagement and growth on their accounts without manual effort.

28s$0.0018
Social media

Streamline cold calling with automated prospect scraping, AI scripts, and WhatsApp outreach

This workflow automates the entire cold calling pipeline, from prospect identification and research to personalized message creation and delivery. It leverages Apify for web scraping, GPT-4o for intelligent content generation, and WhatsApp integration for automated outreach, transforming raw prospect data into high-converting, personalized cold calling campaigns. The workflow can be triggered manually or via a Google Drive Trigger, and it stores prospect data in a Supabase vector database, processes the data using OpenAI's language models, and sends the personalized messages through the WhatsApp Business API. This solution aims to help sales teams streamline their cold calling efforts, increase reach and response rates, and improve message effectiveness through continuous AI-powered optimization.

22s$0.0014
Social media

Automatically sync LinkedIn Ads lead data to Google Sheets

This automation enables users to seamlessly capture new lead generation form responses from LinkedIn Ads and automatically add them as rows in a designated Google Sheets spreadsheet. This helps consolidate and centralize all LinkedIn Ads lead data in one organized location for further analysis and processing. The automation triggers whenever a new lead form response is received from LinkedIn Ads, and it then creates a new row in the connected Google Sheets spreadsheet, ensuring that users have a comprehensive view of their lead data. This integration streamlines the lead management workflow, saving users time and effort by automating the data transfer process between LinkedIn Ads and Google Sheets.

8s$0.0005