Multi-Platform Video Publisher using Google Sheets and Blotato - n8n Workflow

• Content creators managing multiple social channels.


• Marketing teams needing to automate video distribution.


• Users looking for advanced n8n templates for cross-platform publishing.


• Developers interested in complex n8n workflow design utilizing HTTP requests and sub-workflows.

This advanced n8n workflow provides a robust solution for automating content distribution across nearly a dozen social media platforms simultaneously, eliminating the repetitive manual task of uploading videos to each service. The core of this n8n automation relies on a Schedule n8n trigger and Google Sheets integration, allowing users to queue videos by simply updating a spreadsheet. Once a video is marked as ready, the workflow uses the Blotato API to upload the media and then publishes it to Instagram, YouTube, TikTok, Facebook, Threads, Twitter, LinkedIn, Bluesky, and Pinterest. This approach ensures high-efficiency publishing and provides a centralized control panel (Google Sheets) for all content releases. Furthermore, the template includes examples of advanced n8n practices, such as modularizing logic using sub-workflows and dynamically retrieving API keys using the n8n Data Table node.

The primary scheduled path of this n8n workflow begins with the Schedule Trigger n8n node, which activates the process at a predefined time (e.g., 22:00 daily). The workflow then moves to the Google Sheets n8n node, which filters the sheet to find video rows where the ReadyToPost column contains the value "Ready."

1. Configuration: The Assign Social Media IDs n8n node sets up necessary account IDs (Instagram ID, YouTube ID, etc.) required for the Blotato API calls.


2. Upload: An HTTP Request n8n node (Upload Video to Blotato) takes the video URL from the Google Sheet data and uploads it to the Blotato service, receiving a media URL response.


3. Cross-Posting: Multiple parallel HTTP Request n8n nodes are triggered, each configured for a specific social platform (INSTAGRAM, YOUTUBE, TIKTOK, FACEBOOK, THREADS, LINKEDIN, BLUESKY, PINTEREST, TWITTER). Each n8n node uses the Blotato endpoint to create a post, referencing the uploaded media URL, the video description, and the corresponding account ID.


4. Completion & Cleanup: Finally, the Update Video Sheet Google Sheets n8n node marks the processed row's ReadyToPost status as "Finished." This prevents the n8n trigger from picking up the same video again on the next cycle, completing the automated n8n workflow.

Note: The second section demonstrates a callable sub-workflow pattern, showing how another n8n workflow can trigger this publishing logic, dynamically passing parameters like URL, Title, and Description, retrieving API keys using the Data Table n8n node for enhanced security and management.

To successfully deploy this powerful n8n workflow, follow these setup steps:

1. Import: Import the provided n8n workflow JSON into your n8n instance.


2. Google Sheets Setup: Create a Google Sheet containing at least two columns: URL VIDEO (containing the public video link) and ReadyToPost (used for filtering, use the value "Ready" to queue a video).


3. Google Sheets Credentials: Configure the Google Sheets n8n node (Get my video and Update Video Sheet) by creating a new OAuth2 credential connection to your Google account and selecting the correct spreadsheet and sheet name.


4. Blotato API Key: Obtain your API key from your Blotato account settings. This key must be configured in the header parameters of all HTTP Request n8n nodes, often labeled blotato-api-key.


5. Social Media IDs: Update the Assign Social Media IDs n8n node with your specific Blotato account IDs for each social platform. These IDs are essential for the posting HTTP Request n8n nodes to function correctly.


6. Schedule: Activate the Schedule Trigger n8n node or manually test the n8n workflow to ensure all connections are working.

Schedule Trigger (n8n trigger): Initiates the n8n workflow daily at 22:00, ensuring regular checks for new content.
Google Sheets (Get my video): Fetches rows from the connected spreadsheet where the ReadyToPost column equals "Ready." This n8n node determines the content to be published.
Set (Assign Social Media IDs): A critical n8n node used for central configuration, storing all platform-specific account IDs needed for the Blotato API.
HTTP Request (Upload Video to Blotato): Posts the video URL to the Blotato API media endpoint. This is the first crucial API call in the n8n workflow.
Multiple HTTP Request Nodes (INSTAGRAM, YOUTUBE, TIKTOK, etc.): These n8n nodes handle the cross-posting. They use the media URL returned from the previous step and the account IDs set earlier to publish content to each respective social network via the Blotato posts endpoint. Each n8n node is customized with specific platform parameters (e.g., YouTube title, TikTok privacy).
Google Sheets (Update Video Sheet): Updates the row status to "Finished" after successful publication, ensuring idempotency for the scheduled n8n trigger.
Execute Workflow Trigger (Media to publish): Acts as the starting n8n node for the sub-workflow variant, allowing external n8n workflows to call this logic and pass input data (URL, Title, Description).
Data Table (get blotato key): Demonstrates best practice by fetching the Blotato API key dynamically from an n8n Data Table, centralizing credentials for use across all subsequent HTTP Request n8n nodes in the sub-workflow path.