Automated Daily Posting to 9 Social Platforms with Google Sheets, Drive and Blotato

Description

Description
This automation publishes to 9 social platforms daily! Manage your content in a simple Google Sheet. When you set a post's status to "Ready to Post" in your Google Sheet, this workflow grabs your image/video from your Google Drive, posts your content to 9 social platforms, then updates the Google Sheet post status to "Posted".

Overview
1. Trigger: Check Every 3 Hours
Check Google Sheet for posts with Status ""Ready to Post""
Return 1 post that is ready to go

2. Upload Media to Blotato
Fetch image/video from Google Drive
Upload image/video to Blotato

3. Publish to Social Media via Blotato
Connect your Blotato account
Choose your social accounts
Either post immediately or schedule for later
Includes support for images, videos, slideshows, carousels, and threads

Setup
Sign up for Blotato
Generate Blotato API Key by going to Settings > API > Generate API Key (paid feature only)
Ensure you have "Verified Community Nodes" enabled in your n8n Admin Panel. Install "Blotato" community node.
Create credential for Blotato.
Connect your Google Drive to n8n: https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service
Copy this sample Google Sheet. Do NOT change the column names, unless you know what you're doing: https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit
Make your Google Drive folder containing images/videos PUBLIC (i.e. Anyone with the link)
Complete the 3 setup steps shown in BROWN sticky notes in this template

Troubleshooting Checklist
your Google Drive is public
column names in your Google Sheet match the original example
file size < 60MB; for large files, Google Drive does not work, use Amazon S3 instead

📄 Documentation
Full Tutorial

Troubleshooting
Check your Blotato API Dashboard to see every request, response, and error. Click on a request to see the details.

Need Help?
In the Blotato web app, click the orange button on the bottom right corner. This opens the Support messenger where I help answer technical questions