Workflow overview
Why this workflow matters
Potentially useful as a reusable automation building block.
Automate TikTok video posting from Google Sheets & Drive with Blotato. Perfect for content creators and social media managers. ⚠️ IMPORTANT Self-hosted AlekSystem 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 AlekSystem instance Blotato API account Google Drive & Sheets OAuth2 credentials Community node: @blotato/AlekSystem-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.
Best fit
Categories
Services
Use cases
Need another direction?