AutomationMart
Home/Browse/Multi-platform video publishing from Google Sheets to 9 social networks via Blotato API
n8n

Multi-platform video publishing from Google Sheets to 9 social networks via Blotato API

n8nn8n16 modulesv1.0
Google SheetsOpenAIGoogle DriveLinkedInInstagramFacebook

This workflow automates the process of publishing content from a Google Sheet to multiple social media platforms using the Blotato API. It retrieves content details (caption and Google Drive video URL) from a Google Sheet, uploads the media to Blotato, and then distributes it to Instagram, Facebook, LinkedIn, TikTok, YouTube, Threads, Twitter, Bluesky, and Pinterest. It also includes a separate branch for generating and publishing an AI-created image to Pinterest. Tools & Services Used Content S

At a glance

Multi-platform video publishing from Google Sheets to 9 social networks via Blotato API is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI, Google Drive, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI, Google Drive, LinkedIn, Instagram, Facebook
Modules
16
Price
Free
Version
v1.0
Multi-platform video publishing from Google Sheets to 9 social networks via Blotato API workflow diagram

About this workflow

This workflow automates the process of publishing content from a Google Sheet to multiple social media platforms using the Blotato API. It retrieves content details (caption and Google Drive video URL) from a Google Sheet, uploads the media to Blotato, and then distributes it to Instagram, Facebook, LinkedIn, TikTok, YouTube, Threads, Twitter, Bluesky, and Pinterest. It also includes a separate branch for generating and publishing an AI-created image to Pinterest. Tools & Services Used Content Source: Google Sheets (for captions, status, and Google Drive video URLs) Media Hosting: Google Drive (for source videos) Social Media Publishing API: Blotato API (for media upload and posting to all platforms) AI Image Generation: OpenAI (DALL-E for generating an image for Pinterest) Target Social Platforms: Instagram Facebook (Pages) LinkedIn TikTok YouTube Threads Twitter (X) Bluesky Pinterest Workflow Overview This automation performs the following steps: Trigger & Content Retrieval: The Schedule Trigger node initiates the workflow on a defined schedule (e.g., every interval). The Google Sheets node reads data from a specified sheet (Sheet1 of "Publish to 9 Social Platforms"). It filters for rows where the "Status" column is "Ready to Post" and returns the first match. This provides the caption and the Google Drive URL for the video content. The Get Google Drive ID node (a Set node) extracts the unique Google Drive file ID from the video URL obtained from the sheet. Configuration & Media Preparation for Blotato: The Setup Social Accounts node (a Set node) defines placeholders for the Blotato API key and various social media account IDs required by the Blotato API. These need to be manually filled with your actual credentials and IDs. The Upload to Blotato node (HTTP Request) uploads the video content to Blotato's media endpoint. It constructs the downloadable Google Drive URL using the extracted file ID and sends it to Blotato along with the API key. Blotato then fetches and stores the media, returning a Blotato media URL. Content Distribution to Social Platforms via Blotato (Parallel Branches from "Upload to Blotato"): The Blotato media URL (from the previous step) and the caption (from Google Sheets) are used to make individual POST requests to the Blotato API (/v2/posts) for each target platform. Each request is an HTTP Request node configured for a specific platform: [Instagram] Publish via Blotato (Disabled by default): Posts to the configured Instagram account. Publish to Facebook: Posts to the configured Facebook Page. Publish to LinkedIn: Posts to the configured LinkedIn account. Publish to Tiktok: Posts to the configured TikTok account, with specific privacy and feature settings. Publish to Youtube: Uploads the video as a public YouTube short/video with a title and notifying subscribers. Publish to Threads: Posts to the configured Threads account (caption sliced to 500 chars). Publish to Twitter: Posts to the configured Twitter (X) account (caption sliced to 280 chars). Publish to Bluesky: Posts text-only (no media URL used in the example body) to the configured Bluesky account (caption sliced to 280 chars). AI Image Generation & Pinterest Publishing (Separate Branch from "Upload to Blotato"): This branch demonstrates an alternative content type. The OpenAI node generates an image based on a prompt ("Image of a manatee staring in the mirror at its AI avatar") and returns image URLs. The Upload to Blotato - Image node (HTTP Request) takes one of these generated image URLs and uploads it to Blotato's media endpoint. The [Pinterest] Publish via Blotato node then posts this AI-generated image to the configured Pinterest account and board, along with the caption from the Google Sheet and a link.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

AI-powered candidate screening and evaluation workflow using OpenAI and Airtable

Who is this for? This workflow is ideal for: HR professionals and recruiters who want to automate and enhance the hiring process Organizations seeking AI-driven, consistent, and data-backed candidate evaluations Hiring managers using Airtable as their recruitment database --- What problem is this workflow solving? Screening candidates manually is time-consuming, inconsistent, and difficult to scale. This workflow solves that by: Automating resume intake and AI evaluation Matching candidates

Free

Automatically find verified emails and phones for every new row in Google Sheets with FullEnrich

This template automatically enriches new leads added to your Google Sheet. When a new row is detected, it sends the contact's details to FullEnrich to retrieve their work email and phone number, then writes the results back to the same row. Perfect for sales teams who collect leads in Google Sheets and want to enrich them instantly without manual work.

Free

Get New Ranked Keywords in Google AIO with DataForSEO

Once a week, this scenario automatically scans Google to detect newly ranked keywords for your domains in AI Overview using the DataForSEO API. It pulls the latest data for every target you track, stores a fresh snapshot in Google Sheets, and compares it to the previous run. Any newly ranked keywords are automatically added to a dedicated Google Sheet, creating an easy-to-review log. Lastly, the automation emails you a short summary, so your team can quickly see what’s changed without manual che

Free

Natural language database queries with dual-agent AI & PostgreSQL integration

AI Database Assistant with Smart Query's & PostgreSQL Integration Description: 🚀 Transform Your Database into an Intelligent AI Assistant This workflow creates a smart database assistant that safely handles natural language queries without crashing your system. Features dual-agent architecture with built-in query limits and PostgreSQL optimization – perfect for commercial applications! ✅ Ideal for: SaaS developers building database search features 🔍 Database administra

Free

Add Google Sheets rows for Gfycat GIF Hosting Gfycats

Make will import your Gfycat GIF Hosting Gfycats into your Google Sheets spreadsheet as a row. Here's the [sheet](https://docs.google.com/spreadsheets/d/1NmniggdTneXw0CGOneN_ote-XM2yaLUnYpKLdFPoo08/edit?usp=sharing) used in this scenario.

Free

Upsert a vector into a Pinecone namespace from new Google Sheets row data

Easily upsert vectors into Pinecone namespaces using Google Sheets row data, enhancing search and machine learning capabilities, improving data-driven insights and decision-making.

Free

Create children’s AI story videos from drawings and auto-publish to YouTube with Blotato

From Drawing to Story: Auto-Publish AI Video to YouTube with Blotato Overview Transform a hand-drawn character sketch into a fully animated, narrated video story — automatically. This 3-part pipeline uses Claude AI, image generation, and video synthesis to go from a simple drawing to a publish-ready video, with no manual editing required. Perfect for: indie creators, educators, storytellers, and anyone who wants to bring hand-drawn characters to life at scale. --- How It Works

Free

Scrape developer profiles from Stack Overflow for lead generation with OpenAI & Bright Data

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically discovers and collects information about Stack Overflow user profiles for lead generation. It saves you time by eliminating the need to manually browse through developer profiles and provides a centralized database of potential leads with their technical expertise. Overview This workflow automatically scrapes Stack Overflow user profiles and extracts key information li

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free