Workflow overview
Why this workflow matters
Useful for software delivery and engineering operations. Supports knowledge capture and document intelligence use cases.
🎬 What This Workflow Does This workflow turns your Google Sheet into a fully automated AI video factory powered by Google Veo 3 via Vertex AI. Simply fill in your prompts, choose your video settings, tick a checkbox — and walk away. The workflow handles everything: sending the prompt to Veo 3, waiting for the video to generate, downloading it, uploading it to Google Drive, and writing the link back to your sheet automatically. No manual downloading. No checking APIs. No copy-pasting links. Just tick and go. Whether you need 5 videos or 500, this workflow runs each one through the same reliable pipeline — with full error handling so you always know what succeeded and what failed, and exactly why. 🧠 Why This Workflow Exists Google Veo 3 is one of the most powerful AI video generation models in the world — but the Google Cloud console only lets you generate videos one at a time. If you have a client who needs 50 product videos, or a content team producing videos at scale, doing it manually through the UI is completely impractical. This workflow solves that. It gives you a spreadsheet-driven production pipeline for Veo 3 — where each row is one video job, fully configurable with its own prompt, resolution, aspect ratio, and duration. ✅ What You Get ✅ Checkbox trigger — tick a row in Google Sheets to start generation ✅ Per-row settings — each video can have its own resolution, aspect ratio, and duration ✅ Smart polling loop — automatically checks every 60 seconds until the video is ready ✅ Google Drive upload — finished videos land in your Drive folder automatically ✅ Sheet auto-update — Drive link written back to the exact row when done ✅ Full error handling — content blocks and API errors are logged to the sheet with the exact reason ✅ No wasted credits — validation gate blocks empty or incomplete rows before any API call is made 🗂️ Google Sheet Template Use this ready-made Google Sheet template to get started immediately: 👉 Click here to open the Google Sheet Template (File → Make a copy) Your sheet must have these columns in this exact order: | Column | Description | |---|---| | prompt | Your video description — what Veo 3 should generate | | resolution | Video quality: 720p or 1080p | | aspectRatio | 16:9 for landscape, 9:16 for portrait/vertical | | durationSeconds | Video length: 4, 6, or 8 seconds only | | send_for_generation | Checkbox column — tick this to trigger the workflow | | video_drive_link | Auto-filled — Drive link on success, error reason on failure | | row_number | Auto-filled by Apps Script — do not edit manually | ⚙️ Full Setup Guide — Step by Step STEP 1 — Create a Google Cloud Project & Enable Vertex AI Go to console.cloud.google.com Click the project dropdown at the top → New Project Give it a name (e.g. veo-automation) → click Create Once created, make sure this project is selected In the left menu go to APIs & Services → Library Search for Vertex AI API → click it → click Enable Now go to Billing in the left menu Link a billing account to your project — Vertex AI requires billing to be enabled even if you're within free tier limits STEP 2 — Get Your Vertex AI API Key go on this url https://console.cloud.google.com/vertex-ai/studio in the vertex ai studio create the api key Save the key somewhere safe — you will paste it into the Data Collection node in AlekSystem STEP 3 — Get Your Project ID In Google Cloud Console, look at the top bar — your Project ID is shown next to the project name It looks like: project-xxxxxxx-xxxx-xxxx-ada or similar Copy this — you will paste it into the Data Collection node in AlekSystem STEP 4 — Set Up AlekSystem Credentials In AlekSystem you need two Google credential connections: Google Sheets OAuth2 In AlekSystem go to Settings → Credentials → New Search for Google Sheets OAuth2 API Follow the OAuth flow to connect your Google account This credential is used by the Update video Link in sheet and Update Error in Sheet nodes Google Drive OAuth2 Same process — search for Google Drive OAuth2 API Connect the same or a different Google account This credential is used by the Upload Video to Drive node STEP 5 — Configure the Data Collection Node Open the Data Collection node in AlekSystem and update these values: | Field | What to put | |---|---| | project_id | Your Google Cloud Project ID from Step 3 | | vertex_api | Your Vertex AI API Key from Step 2 | | veo_3_model | veo-3.0-generate-preview (or newer model if available) | | api_endpoint | Leave as us-central1-aiplatform.googleapis.com | | region | Leave as us-central1 | STEP 6 — Set Up the Google Drive Folder Go to drive.google.com Create a new folder where your videos will be saved (e.g. Veo Generated Videos) Open the folder — copy the folder ID from the URL: URL looks like: https://drive.google.com/drive/folders/xxxxxxxxxxxxxx-xxxxxxxxxxx The folder ID is the last part: xxxxxxxxx-xxxxxxxxx Paste this into the Upload Video to Drive node → Folder ID field STEP 7 — Connect Your Google Sheet Open the Update video Link in sheet node Click the Document field → select your copy of the Google Sheet template Make sure the sheet tab selected is VEO_3 Do the same in the Update Error in Sheet node Here is the full rewritten section in clean markdown without any code blocks around the URL: STEP 8 — Set Up the Apps Script Webhook Trigger This is what connects your Google Sheet checkbox to AlekSystem. Without this, ticking the checkbox does nothing. 📄 Download the Apps Script file here How to install it: Open your Google Sheet Click Extensions → Apps Script Delete any existing code in the editor Paste the entire Apps Script code provided with this template Find the url field in the config block and replace YOUR_AlekSystem_WEBHOOK_URL_HERE with your AlekSystem webhook URL — found in the Google Sheet Trigger node in AlekSystem. Use the Production URL, not the test URL. Click Save (floppy disk icon at the top) Now add the installable trigger — this step is critical: In Apps Script, click the clock icon on the left sidebar (Triggers) Click + Add Trigger in the bottom right corner Set these exact options: Choose which function to run: handleEdit Choose which deployment to run: Head Select event source: From spreadsheet Select event type: On edit Click Save Google will ask you to authorise the script — click through and allow all permissions Go back to your sheet and tick a checkbox in column E to test — open Apps Script Executions tab to confirm it fired successfully ⚠️ Why the installable trigger is required: The basic onEdit function that Google runs automatically does NOT have permission to make external HTTP requests. The installable trigger runs under your Google account permissions and can call external URLs like your AlekSystem webhook. This is a Google limitation — not an AlekSystem one. STEP 9 — Activate the Workflow in AlekSystem In AlekSystem open the workflow Toggle the workflow to Active using the switch in the top right corner Copy the Production webhook URL from the Google Sheet Trigger node Paste it into your Apps Script config in Step 8 where it says YOUR_AlekSystem_WEBHOOK_URL_HERE 🔄 How the Workflow Runs — Full Flow Explained 🔄 How the Workflow Runs — Full Flow Explained Google Sheet checkbox ticked ↓ Apps Script fires webhook → AlekSystem ↓ Validation Gate (If node) — checks prompt, resolution, aspectRatio are all filled — if anything missing → workflow stops, no API call made ↓ Data Collection node — bundles all settings into one clean item ↓ Vertex AI — Send for Generation — POST to predictLongRunning endpoint — returns an operation name (like a tracking number) ↓ Wait 60 seconds ↓ Fetch / Check Video — POST to fetchPredictOperation — checks if done: true ↓ IF raiMediaFilteredCount === 0 → TRUE: video exists → Convert Base64 to MP4 file → Upload to Google Drive → Write Drive link to sheet ✅ → FALSE: check for error → IF raiMediaFilteredCount > 0 OR error exists → Write error reason to sheet ❌ → ELSE: still processing → Wait 60 seconds → check again ⏳ ⚙️ Video Settings Reference Resolution 720p — standard quality, faster, lower cost 1080p — high quality, uses more credits Aspect Ratio 16:9 — landscape (YouTube, ads, presentations) 9:16 — vertical (Instagram Reels, TikTok, YouTube Shorts) Duration 4, 6, or 8 seconds — Veo 3 only accepts these exact values, no other numbers ❌ Error Handling — What Gets Logged If a video fails, the exact reason is written to the video_drive_link column: Prompt violates Veo safety policy,| Full AI reason from Google || This means your client can see exactly which rows failed and why — without needing to check any logs. 💡 Tips for Best Results Keep prompts on a single line — multi-line prompts are handled automatically by the workflow Use descriptive cinematic prompts: "Slow motion close-up of ocean waves at sunset, golden hour, 4K" Start with 720p to test — switch to 1080p for final production runs Use 9:16 for Instagram Reels, TikTok, YouTube Shorts Use 16:9 for YouTube, presentations, ads 🔧 Requirements AlekSystem (self-hosted or cloud) — version 1.0+ Google Cloud account with billing enabled Vertex AI API enabled on your project Google Sheets + Google Drive OAuth credentials in AlekSystem Google Apps Script access on your sheet
Best fit
Categories
Services
Use cases
Need another direction?