Quick overview
This scheduled workflow reads episode and character data from Google Sheets, uses OpenAI to write a 30-second Seedance 2.5 prompt with captions, renders the video on Replicate, and publishes it via SocialRobot to TikTok (draft) with optional posting to Instagram Reels and Threads.
How it works
- Runs every day at 18:00 on a schedule trigger.
- Reads the Episodes tab in Google Sheets, selects the first episode not marked done/failed, and pulls the most recent completed episode summary for continuity.
- Loads matching character reference image URLs and descriptions from the Characters tab in Google Sheets and prepares them as ordered reference inputs.
- Uses OpenAI (GPT-6 Luna) to generate a timed multi-shot Seedance prompt, an episode title, platform-specific captions, and a short episode summary.
- Submits a Seedance 2.5 reference-to-video job to Replicate, polls until it succeeds/fails/times out, and downloads the resulting MP4.
- Validates the downloaded video’s file size, type, and duration, then uses SocialRobot to save a TikTok inbox draft and (if enabled) publish to Instagram Reels and Threads.
- Updates the episode row in Google Sheets with status, post IDs, produced timestamp, and the new summary, or marks the row failed with a readable error message.
Setup
- Self-host n8n and install the SocialRobot community node, then add your SocialRobot API credentials and connect your TikTok/Instagram/Threads accounts.
- Create a Google Sheet with Episodes and Characters tabs matching the required columns, then paste the sheet URL into the sheet_url field in Set Series Settings.
- Add Google Sheets OAuth credentials for the Google Sheets nodes.
- Add a Replicate HTTP Bearer token credential for the Replicate HTTP Request nodes and an OpenAI credential for the OpenAI chat model.
- Select the target SocialRobot account IDs for TikTok (and optionally Instagram Reels/Threads) and enable the Instagram/Threads nodes if you want immediate public posting.
- Review and adjust series settings (premise, style, model, resolution, duration, limits) and the schedule trigger time before activating the workflow.