Turn a list of ideas in Google Sheets into finished short videos ready for social channels. The system runs on a schedule, builds clips with AI, adds a voiceover, renders a final cut, and can post to multiple networks. Ideal for social teams, creators, and brands that need steady output without manual work.

Here is how it works. A daily trigger reads your sheet and asks OpenAI to write five captions. The flow validates the list and tracks token use for cost control. Images are created with Flux through PiAPI, then each image becomes a video clip with Kling via PiAPI. ElevenLabs produces a voiceover, which is stored on Google Drive. Captions, clips, and audio are merged and sent to a Creatomate template for rendering. The final video is saved to Google Drive, sharing is enabled, the sheet is updated with links and costs, and a Discord message confirms completion. An optional branch extracts audio from the final video, asks OpenAI to write platform text, and uploads to TikTok, Instagram, YouTube, Facebook, and LinkedIn using upload-post.com.

You will need API keys for OpenAI, PiAPI, ElevenLabs, and Creatomate, plus Google credentials and a Discord webhook. Expect a single idea to produce a batch of clips and a master video with minimal input. Great for agencies that want daily publishing, marketing teams planning content calendars, or creators who want to scale output while keeping costs clear.

• Daily schedule reads a Google Sheet of ideas and starts batch generation.
• OpenAI creates video captions and a short script, with list validation and token usage tracking.
• Flux image generation via PiAPI with configurable model and prompt controls.
• Kling image to video creation through PiAPI with wait and retry logic to handle queue times.
• ElevenLabs voiceover generation and upload to Google Drive for easy access.
• Creatomate template render that combines captions, video, and audio into a final cut.
• Google Drive upload and permission settings so files are shareable by link.
• Google Sheets update with links, token counts, and completion status.
• Discord webhook alert when the final video is ready.
• Optional cross posting using upload-post.com with AI generated platform descriptions.

• Reduce manual video production from hours to about 20 minutes of oversight.
• Automate up to 80 percent of the steps from idea to published asset.
• Connect Google Sheets, OpenAI, PiAPI, ElevenLabs, Creatomate, Google Drive, Discord, and upload-post.com in one flow.
• Handle five clips per idea by default and scale volume by adding rows.
• Lower rework with built in validation, waits, and retry checks for image and video tasks.
• Track token usage and output links in the sheet to keep costs and status visible.

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Google Drive, OpenAI, PiAPI, ElevenLabs, Creatomate, Discord and upload-post.com. See the Tools Required section above for links to create accounts with these services.
3. Open the Set API Keys node and add your OpenAI key, PiAPI key, ElevenLabs key, and Creatomate API key. Save the node after entering each value.
4. In the n8n credentials manager, connect Google Sheets and Google Drive. Double click the Load Google Sheet and Upload Final Video nodes, choose Create new credential, and follow the on screen steps to authorize with your Google account.
5. In Creatomate, create a template and copy its template_id. Paste the template_id into the Render Final Video node fields where the template is referenced.
6. Copy the provided Google Sheets template and set the spreadsheet and sheet details in the Load Google Sheet node to point to your copy.
7. Open Generate Video Captions, Generate Image Prompts, and Generate Script nodes to review and adjust prompts for your brand tone.
8. In the Generate Image and Image to Video nodes, confirm the chosen Flux and Kling model settings. For lower cost tests, switch Kling to the standard model in the node body.
9. Set a Google Drive folder in the Upload Voice Audio and Upload Final Video nodes. Confirm the Set Permissions nodes grant link access for viewing.
10. Open the Notify me on Discord node and paste your Discord webhook URL. Send a test message to confirm notifications work.
11. Run a small test: add one idea row in your sheet and click Execute workflow once in n8n. Verify images, clips, and the final video appear in Google Drive and that the sheet updates with links and token counts.
12. If you plan to publish automatically, get an API token from upload-post.com. In each upload node, set the Authorization header to Apikey followed by your token.
13. Troubleshoot common issues: if image or video tasks stay pending, check API quotas and keys, increase Wait node times, and verify the Fail check path. If Google errors appear, reauthorize the credentials with the correct scopes.
14. Turn on the workflow and confirm the Once Per Day schedule matches your publishing plan.