Turn ideas in a Google Sheet into ready to share short videos on a daily schedule. The flow writes captions, builds images, turns them into clips, adds a voice track, and delivers a finished render with links. It suits social teams and creators who need steady output without manual editing.

A scheduled start reads new ideas from the sheet. OpenAI writes five captions and image prompts. PiAPI runs Flux to generate images, then Kling to convert each image into a short video. Wait and retry checks handle long queues and failed tasks. OpenAI also drafts a short script for voice. ElevenLabs produces the audio and stores it in Google Drive. A Creatomate template then combines the video, captions, and audio into a single final render. The file uploads to Drive, public links are set, the sheet is updated with links and token usage, and a Discord alert is sent.

Connect accounts and place keys in the Set API Keys node. Add your Creatomate template ID and your ElevenLabs voice ID. Expect each run to turn one idea into up to five clips and a finished cut, cutting production from hours to minutes. Strong use cases include social content, product teasers, and newsletter promos.

• Daily schedule reads new ideas from Google Sheets and writes back links and status.
• OpenAI generates captions, image prompts, and a short voiceover script.
• Flux text to image via PiAPI with task polling, failure checks, and headers for API key auth.
• Kling image to video via PiAPI with timed waits and automatic retries.
• ElevenLabs text to speech and Google Drive upload with share permissions set.
• Creatomate template render that merges video, captions, and audio into one file.
• Discord webhook notification when the final video is ready to download.
• Token usage calculation to track generation costs per run.
• Merge nodes pair captions, video URLs, and audio so every scene stays in sync.

• Reduce manual work from 4 hours to 15 minutes per batch
• Automate about 80 percent of production steps
• Produce up to 5 short videos per idea automatically
• Connect seven systems seamlessly without copy paste
• Increase delivery reliability with waits and retries
• Centralize links and cost data in Google Sheets

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, OpenAI, PiAPI, ElevenLabs, Creatomate, Google Drive and Discord. 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, PiAPI, Creatomate, and ElevenLabs keys. If a key is missing, double click the related node, choose 'Credential to connect with' > 'Create new credential', and follow the on screen steps.
4. Connect Google Sheets: double click the Load Google Sheet node, in 'Credential to connect with' select 'Create new credential' for Google Sheets OAuth2, sign in, then pick your copy of the template sheet and the correct range.
5. Connect Google Drive: open Upload Voice Audio, Upload Final Video, and Set Permissions nodes. Create a Google Drive OAuth2 credential, approve the scopes, and select the Drive folder where files should be saved.
6. Set your Creatomate template: in your Creatomate account, create a video template and copy its template_id. Paste this ID where the workflow expects it, typically in the Set API Keys node or the Render Final Video node parameter.
7. Pick a voice: in ElevenLabs, copy the voice ID you want. Open the Generate voice node and replace the voice ID in the URL with your choice.
8. Review model settings: in Generate Image set the Flux model, and in Image-to-Video confirm the Kling mode. Keep defaults for testing, then adjust for cost and quality later.
9. Link your sheet correctly: make a copy of the provided Google Sheet template and ensure column names match what the workflow reads and updates. Run a quick test with one idea row.
10. Test end to end: click Execute Workflow in n8n. Watch the waits complete, then confirm audio and final video files appear in Google Drive, the sheet updates with links and token usage, and Discord receives a message.
11. Troubleshoot: if media is missing, extend the Wait 10min node or check PiAPI task status. If links are private, review the Set Permissions nodes. If list validation fails, adjust the OpenAI prompts for strict formatting.
12. Activate the schedule when tests pass so the flow runs Once Per Day without manual work.