The 10-Minute-a-Day Faceless Factory: Automating Shorts with Zapier and AI

Imagine creating the core assets for 10 YouTube Shorts during your coffee break. This isn't a dream; it's the power of automation. This advanced tutorial shows you how to build a "content assembly line" with Zapier and AI.

The Goal: A Content Assembly Line

Our workflow will look like this: You drop an idea into a Google Sheet, and automation takes over, using AI to write a script and generate a voiceover, which are then neatly organized in your Google Drive, ready for you to edit.

Prerequisites: What You'll Need

• A Zapier account (the free plan is enough to build and test this).
• An OpenAI API key with billing enabled.
• An ElevenLabs account with an API key.
• A Google account (for Sheets and Drive).

Step 1: The Control Panel (Google Sheet)

Create a new Google Sheet. This will be the command center for your content factory. Set up the following columns:

• `Idea` (This is where you'll type your Short's topic)
• `Run Script Zap` (A checkbox column)
• `Run Audio Zap` (A checkbox column)
• `Generated Script` (This will be filled by AI)
• `Audio File URL` (This will be filled by the Zap)
• `Status` (To track progress)

We use two checkbox columns to trigger our Zaps manually, giving us more control.

Step 2: The Scripting Zap (Google Sheets to OpenAI)

In Zapier, create a new Zap.

1. Trigger: "Updated Spreadsheet Row in Google Sheets"
   Connect your Google account and select the sheet you just created. Set it to trigger when the `Run Script Zap` column is updated.
2. Filter by Zapier
   Add a filter step. Only continue if `Run Script Zap` "exactly matches" `TRUE`. This prevents it from running accidentally.
3. Action: "Send Prompt in OpenAI"
   Connect your OpenAI account. In the action setup:
   • Model: Select `gpt-4o` or your preferred model.
   • Prompt: This is the key. Use the `Idea` field from your Google Sheet in the prompt.
     You are an expert YouTube Shorts scriptwriter. Your task is to write a punchy, engaging, 60-second script about the following topic: [Insert 'Idea' field from Step 1] The script must be under 150 words. Start with a strong, curiosity-driven hook. Do not include scene directions or headings like "Narrator:". Output only the raw narration text.
4. Action: "Update Spreadsheet Row in Google Sheets"
   Select the same sheet. For the "Row," use the `row_id` from the trigger step to ensure you're updating the correct row.
   • In the `Generated Script` field, insert the "Response" from the OpenAI step.
   • In the `Status` field, type "Script Generated".
   • In the `Run Script Zap` field, type `FALSE` to uncheck the box.

Test this Zap. Check your box in Google Sheets, and watch the `Generated Script` and `Status` columns fill in automatically!

Step 3: The Voiceover Zap (Google Sheets to ElevenLabs to Drive)

Create a second Zap. This one will activate once a script is ready.

1. Trigger: "Updated Spreadsheet Row in Google Sheets"
   Select the same sheet, but this time, trigger when the `Run Audio Zap` column is updated.
2. Filter by Zapier
   Only continue if `Run Audio Zap` "exactly matches" `TRUE`.
3. Action: "Text to Speech in ElevenLabs"
   Connect your ElevenLabs account. In the action setup:
   • Voice: Choose your desired voice from the dropdown.
   • Text: Insert the `Generated Script` field from your Google Sheet.
4. Action: "Upload File in Google Drive"
   Connect your Google Drive account.
   • Folder: Choose the specific folder where you want your audio files saved.
   • File: This is important. Select the "File" object from the ElevenLabs step.
   • File Name: To keep things organized, name the file dynamically. A good practice is `[Idea from Step 1].mp3`.
5. Action: "Update Spreadsheet Row in Google Sheets"
   Update the same row as before.
   • In the `Audio File URL` field, insert the "Share Link" or "Web Content Link" from the Google Drive step.
   • In the `Status` field, type "Assets Ready".
   • In the `Run Audio Zap` field, type `FALSE` to uncheck the box.

Step 4: The Final Assembly (Your Creative Work)

Once you run these Zaps, you'll have a Google Drive folder filling up with perfectly named MP3 files and a Google Sheet acting as your production dashboard.

Your job is now purely creative. Open your video editor (like CapCut), drag in the audio file, and focus on the fun part: finding the perfect visuals to bring your automated script to life. You've effectively front-loaded all the tedious work.

Conclusion: Your Content Factory Awaits

This semi-automated system separates the logistical work from the creative work, allowing you to batch-produce content assets at an incredible scale. Use this as a starting point. You can add more steps, like using another AI to generate visual ideas or even drafting social media posts. The factory is yours to build.