Automate TikTok Video Posting from Google Sheets & Drive with Blotato
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 Schedule Trigger → Runs every hour Fetch Data → Gets pending videos from Google Sheets Process Video → Extracts Drive ID and shares file Upload → Transfers to Blotato platform Post → Automatically posts to TikTok 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.
Related Templates
Extract Title tag and Meta description from url for SEO analysis with Airtable
Extract Title tag and meta description from url for SEO analysis. How it works The workflows takes records from Airtabl...
Restore your workflows from GitHub
This workflow restores all n8n instance workflows from GitHub backups using the n8n API node. It complements the Backup ...
Extract Named Entities from Web Pages with Google Natural Language API
Who is this for? Content strategists analyzing web page semantic content SEO professionals conducting entity-based anal...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments