Upload Instagram Reels from Google Sheets with DeepSeek AI captions

Description

Overview
This n8n workflow template automates the entire process of publishing Instagram Reels from content stored in Google Sheets and Google Drive. It's designed for content creators, social media managers, and businesses who maintain a content calendar in spreadsheets and need automated publishing with AI-generated captions.
Workflow Steps

1. Trigger Phase
Schedule Trigger**: Runs every 12 hours (configurable)
Google Sheets Trigger**: Alternatively triggers when new rows are added
Retrieves the next unposted video from the spreadsheet (where POSTED = FALSE)

2. Content Preparation
Downloads video from Google Drive using file ID from spreadsheet
Processes video with FFmpeg to add custom text overlays:
Title text overlay
Numbering overlay
Sales hook text
Sends processed video using SSH

3. Caption & Metadata Generation
Extracts video filename and metadata
Uses AI Agent (DeepSeek) to generate engaging Instagram captions:
2-4 engaging sentences
3-5 relevant hashtags
Clear call-to-action
Under 150 characters total
Stores caption and metadata in Airtable for record-keeping

4. Instagram Publishing
Creates Facebook/Instagram media container with video URL and caption
Waits and polls for video processing completion
Publishes the Reel when ready
Updates Google Sheet to mark content as posted (POSTED = TRUE)

5. Cleanup
Removes temporary video files from disk