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

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.