Automated daily posting to 9 social platforms with Google Sheets, Drive and Blotato

Name: Automated daily posting to 9 social platforms with Google Sheets, Drive and Blotato
Availability: InStock
Rating: 4.5 (73 reviews)
Author: Sabrina Ramonov 🍄

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

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

Sabrina Ramonov 🍄

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

advanced

Published 12 Sept 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Create and schedule LinkedIn posts from Google Sheets with Gemini and DALL·E

## Overview This n8n automation is a complete LinkedIn Content Engine that turns simple topic ideas into fully written, visual, and scheduled posts. It features a "Human-in-the-Loop" design, meaning AI handles the heavy lifting of writing and image creation, but nothing goes live until you manually approve it in Google Sheets. ## How It Works The system runs two separate workflows in parallel: ### 1. The "Creator" Workflow **Input:** Detects when you add a new topic to your "Content Calendar" Google Sheet. **Brand Alignment:** Pulls your specific "Brand Voice" guidelines from a separate tab to ensure the AI sounds like you. **Creation:** Uses Gemini Flash 1.5 to write the post and DALL-E 3 to generate a matching professional image. **Drafting:** Uploads the image to ImgBB and saves the full draft back to your sheet with a status of "Draft." ### 2. The "Publisher" Workflow **Daily Scan:** Wakes up every morning to check your Content Calendar. **Verification:** Looks for posts that match two criteria: * Date Scheduled matches today's date. * Status is marked as "Approved" (by you). **Publishing:** If both match, it automatically uploads the text and image to LinkedIn and updates the sheet status to "Posted." **Tools Used:** n8n, Google Sheets, OpenRouter (Gemini / OpenAI), ImgBB. ## Connect & Learn More **YouTube Channel:** **[Simon Scrapes](https://www.youtube.com/@simonscrapes)** – More tutorials on AI & Automation. **Community:** **[Skool Community](https://www.skool.com/scrapes/about)** – Master AI & Automation with us. **Full Video Tutorial:** [Watch the step-by-step build here](https://youtu.be/eiIRSUhPgOI?si=lgZTrPZPMqWF4uqz&t=4276)

View

Curate and post AI news to X, Bluesky, Threads and more with GPT-5 mini and Cue

# Curate & post AI news to X, Bluesky, Threads & more via GPT-5 mini & Cue This n8n template automatically curates AI news from RSS feeds and generates platform-tailored social media posts using GPT-5 mini. Posts are saved as drafts in Cue for review before publishing to X, Bluesky, Threads, Mastodon, and Facebook. Use cases include: * Daily automated AI/tech news curation * Multi-platform social media content creation * Building thought leadership with consistent posting * Staying on top of industry news without manual effort ## Who is this for? This workflow is ideal for: * Tech content creators who want to share AI news across multiple platforms * Social media managers handling multiple accounts * Anyone building an audience around AI/tech topics * Teams who want consistent daily content without manual curation ## What problem does this workflow solve? Manually curating news, writing platform-specific posts, and publishing across 5 different social networks is time-consuming. This workflow automates the entire process: * **Curation** - Pulls from 4 trusted AI/tech RSS feeds daily * **Deduplication** - Tracks posted articles in Google Sheets so you never share the same story twice * **Content creation** - GPT-5 mini writes posts tailored to each platform's style and character limits * **Review workflow** - Creates drafts in Cue so you can review before publishing ## How it works 1. **Schedule Trigger** - Runs daily at 9am (configurable) 2. **RSS Feeds** - Fetches articles from TechCrunch AI, Ars Technica AI, The Verge AI, and MIT Tech Review 3. **Filter & Merge** - Combines all feeds and filters to articles from the last 7 days 4. **Deduplication** - Compares against Google Sheets to find unposted articles 5. **Random Selection** - Picks one random article from available stories 6. **AI Generation** - GPT-5 mini generates 5 platform-specific posts with appropriate tone and length 7. **Save to Cue** - Creates a draft post with all 5 platform variations 8. **Log to Sheet** - Records the article URL to prevent future duplicates ## Setup ### Requirements * [Cue account](https://oncue.so) with connected social accounts * OpenAI API key * Google account for Sheets ### Step 1: Install the Cue community node 1. Go to **Settings** → **Community Nodes** 2. Click **Install** 3. Enter `@cuehq/n8n-nodes-cue` ### Step 2: Create tracking spreadsheet 1. Create a new Google Sheet named "AI News Tracker" 2. Add these column headers in row 1: * `article_url` * `title` * `source` * `processed_at` ### Step 3: Configure credentials 1. **Google Sheets** - Add OAuth2 credentials and connect to the "Get Recent Posts" node 2. **OpenAI** - Add your API key and connect to the "GPT-5 mini" node 3. **Cue** - Add your API key from [Cue Settings](https://app.oncue.so/settings/api) ### Step 4: Configure the Cue node 1. Open the **Create Draft in Cue** node 2. Select your **Profile** 3. For each platform slot, select your social account: * Slot 1 → X/Twitter * Slot 2 → Bluesky * Slot 3 → Threads * Slot 4 → Mastodon * Slot 5 → Facebook Don't have all 5 platforms? Simply delete the unused slots. ### Step 5: Publish Save and click **Publish** to activate the workflow. ## Customizing this workflow ### Change the schedule Edit the **Daily 9am Trigger** node to run at a different time or frequency. ### Use different RSS feeds Replace the feed URLs with sources relevant to your niche. The workflow handles any standard RSS feed. Keep 3-6 feeds for best results. ### Auto-publish instead of drafts To publish immediately instead of creating drafts, enable **Publish Immediately** in the Cue node settings. ### Adjust the AI tone Modify the system prompt in the **Write Social Posts** node to match your brand voice or adjust platform-specific guidelines. ## Good to know * **Cost** - Each run uses one OpenAI API call. With GPT-5 mini, this costs approximately $0.01-0.02 per execution. * **Draft review** - Posts are created as drafts in Cue, giving you a chance to review and edit before publishing. * **Deduplication** - The Google Sheet tracks all posted URLs, so the same article is never shared twice. ## About Cue [Cue](https://oncue.so) is a social media scheduling platform that lets you manage and publish content across X, Bluesky, Threads, Mastodon, Facebook, LinkedIn, TikTok, and Instagram from a single dashboard. Key features: * **Multi-platform publishing** - Schedule once, publish everywhere * **Platform-specific content** - Tailor each post for different audiences * **Draft workflow** - Review and edit before publishing * **API & integrations** - Connect with n8n, Zapier, Make, and custom apps [Get started free](https://oncue.so) · [Documentation](https://docs.oncue.so) · [n8n Community Node](https://www.npmjs.com/package/@cuehq/n8n-nodes-cue)

View

Create and post social media image captions with GPT-4.1-mini and Google Sheets

# Social Media Posting Automation with Image and Caption ## How it works This AI-powered workflow streamlines your social media posting process, transforming hours of manual caption writing, image uploading, and scheduling into a fully automated system. You define the topic and image once, and the workflow handles caption generation, review, approval, and posting to your selected platforms. ### Automated Flow 1. **Generate Caption** Trigger the workflow manually and set your post topic and image URL in the Set node. The AI (GPT-4.1-mini) generates a high-quality, engaging social media caption tailored to your audience, platform, and content goals. 2. **Store in Google Sheet** The generated caption, along with your image URL and post metadata, is automatically appended to your Google Sheet. This creates a central location to review and manage all your social media content. 3. **Review and Approve** You review the generated caption in the sheet, make any edits if needed, and update the status to **Approved**. You can also select the platform(s) where you want to post. 4. **Automatic Posting** Once the status is updated to Approved, the next workflow is triggered automatically. It posts your caption and image to the selected social media platform(s) without any further manual effort. **The result?** A seamless, end-to-end social media posting process where captions are AI-generated, stored, reviewed, and posted automatically. Focus on strategy and engagement instead of repetitive manual posting. --- ## Setup Steps **Setup time:** ~10–15 minutes **What you’ll need:** OpenAI API key, Google account, access to your social media platform(s) 1. **Connect Your Google Account** - Click on the Google Sheets node in your workflow. - Select the Credential dropdown and choose **+ Create New Credential**. - Authenticate your Google account and grant the necessary permissions. 2. **Initialize Your Spreadsheet** - Run the workflow once by clicking the play button on the start node. - This will automatically create a Google Sheet with all the required columns for caption tracking and approval. 3. **Add Your OpenAI API Key** - Navigate to the AI Agent node. - Click the Credential dropdown and select **+ Create New Credential**. - Paste your OpenAI API key and save. - Get your API key from [platform.openai.com/api-keys](https://platform.openai.com/api-keys). 4. **Set Post Topic and Image** - Update the title in the Set node with the topic you want to post. - Add the image URL associated with your post. 5. **Review Captions and Approve** - Open your Google Sheet, review the generated captions, and update the status to **Approved**. - Select the platform(s) where the post should go live. 6. **Go Live** - Once the status is updated, the workflow will automatically post your content to the selected social media platform(s). - Sit back and watch your AI-generated captions and images go live automatically. **Ready to automate your social media?** Activate your workflow and start posting smarter today! 🚀💡✅

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.