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.
Content Source: Google Sheets (for captions, status, and Google Drive video URLs)
Social Media Publishing API: Blotato API (for media upload and posting to all platforms)
OpenAI (DALL-E for generating an image for Pinterest)
Instagram
Facebook (Pages)
LinkedIn
TikTok
YouTube
Threads
Twitter (X)
Bluesky
Pinterest
This automation performs the following steps:
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.
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.
Posts to the configured Facebook Page.
Posts to the configured LinkedIn account.
Posts to the configured TikTok account, with specific privacy and feature settings.
Uploads the video as a public YouTube short/video with a title and notifying subscribers.
Posts to the configured Threads account (caption sliced to 500 chars).
Posts to the configured Twitter (X) account (caption sliced to 280 chars).
Posts text-only (no media URL used in the example body) to the configured Bluesky account (caption sliced to 280 chars).
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.