AutomationMart
Home/Browse/Automate TikTok video posting from Google Sheets & Drive with Blotato
n8n

Automate TikTok video posting from Google Sheets & Drive with Blotato

n8nn8n9 modulesv1.0
Google SheetsGoogle Drive

Automate TikTok video posting from Google Sheets & Drive with Blotato. Perfect for content creators and social media managers. ⚠️ IMPORTANT Self-hosted n8n only - requires community nodes not available in cloud version. Google Sheets Structure Required columns: ID, Media URL, Caption, Status - Videos must be in Google Drive - Status must be "pending" for processing - Captions can include hashtags (5 max recommended) How it works 1. Schedule Trigger → Runs every hour 2. Fetch Data → Gets pending

At a glance

Automate TikTok video posting from Google Sheets & Drive with Blotato is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Google Drive
Modules
9
Price
Free
Version
v1.0
Automate TikTok video posting from Google Sheets & Drive with Blotato workflow diagram

About this workflow

Automate TikTok video posting from Google Sheets & Drive with Blotato. Perfect for content creators and social media managers. ⚠️ IMPORTANT Self-hosted n8n only - requires community nodes not available in cloud version. Google Sheets Structure Required columns: ID, Media URL, Caption, Status - Videos must be in Google Drive - Status must be "pending" for processing - Captions can include hashtags (5 max recommended) How it works 1. Schedule Trigger → Runs every hour 2. Fetch Data → Gets pending videos from Google Sheets 3. Process Video → Extracts Drive ID and shares file 4. Upload → Transfers to Blotato platform 5. Post → Automatically posts to TikTok 6. Update Status → Marks as "posted" in spreadsheet Requirements - Self-hosted n8n instance - Blotato API account - Google Drive & Sheets OAuth2 credentials - Community node: @blotato/n8n-nodes-blotato.blotato Use cases - Automated TikTok content posting - Batch video processing - Content management workflows - Scheduled social media distribution The workflow processes one video per hour to avoid rate limits and maintains a clear audit trail through Google Sheets integration.

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

Filter and update Google Sheets rows based on specific criteria

Automatically filter and update Google Sheets rows based on specific criteria. Use Make to streamline data management with Google Sheets' filter and update functions.

Free

Create SMSC senders from new Google Sheets spreadsheet rows

Every time a new row is added to a Google Sheets spreadsheet, Make will automatically create a new sender in SMSC.

Free

Track your Android device location and save it into a Google Sheets spreadsheet

When an Android device being watched changes its location by a given distance, Make will automatically record that change into a row on a Google Sheets spreadsheet. The template uses this [example spreadsheet](https://goo.gl/wwVPsn).

Free

Automate video content posting to multiple social platforms with Postiz

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automates the distribution and scheduling of video content across multiple social platforms (TikTok, YouTube, Facebook, Instagram, Threads) through Postiz. Videos are collected from Google Drive, approved manually, and scheduled via the Postiz community node. --- 🧾 Requirements - Google Drive account with access to the folder that will watch for new items uploaded. - videos in mp4

Free

Sync Facebook Lead Ads leads with Google Sheets

Seamlessly capture and organize new Facebook Lead Ads leads by automatically adding them to a Google Sheets spreadsheet. Streamline your lead management process and enhance productivity with this efficient automation solution.

Free

Monitor SEO keyword rankings with LLaMA AI & Apify Google SERP scraping

Who is this template for? This SEO Keyword Monitoring workflow template is perfect for SEO professionals, digital marketing agencies, website owners, and content strategists who need to track their search rankings and get actionable insights when they're not performing well. Whether you're managing multiple client sites, monitoring your own brand's visibility, or conducting competitive analysis, this automation provides comprehensive rank tracking with AI-powered recommendations. What problem do

Free

Generate personalized marketing emails from Google Sheets with Llama AI

An AI-powered email marketing automation workflow that generates personalized marketing emails using data from Google Sheets and delivers them directly to clients. This workflow combines the power of AI content generation with spreadsheet-based campaign management for seamless email marketing automation. What's the Goal? - Automatically pull marketing offer details from Google Sheets (Sheet 1) - Fetch client information from Google Sheets (Sheet 2) - Use AI to generate compelling, personalized m

Free

Manage garage service reminders, pickups and feedback with Airtable, WhatsApp and Gmail

What problem does this workflow solve? Garage and auto service businesses handle much more than just vehicle repairs — they manage service schedules, customer reminders, pickups, feedback, and repeat visits. When handled manually, this often leads to missed reminders, delayed pickups, unhappy customers, and lost repeat business. This workflow delivers a fully automated, end-to-end customer communication system for garages using n8n + Airtable + WhatsApp + Email, ensuring timely, professional, an

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