Automate TikTok video posting from Google Sheets & Drive with Blotato
n8n9 modulesv1.0Google 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
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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
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.
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
Free