Generate avatar snippet videos from Google Sheets scripts in Google Drive
Ready for 3.0What this workflow does
This AI workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Gemini and Google Drive.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Avatar Description (Google Sheets): uses Google Sheets
- Global Variables (Edit Fields (Set)): sets 2 fields: page, Description
- Get Script (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Set Loop Inputs (Edit Fields (Set)): sets 4 fields: Gaia, Speech, framing…
- Generate a video with Veo (Google Gemini): work with video
- Upload video file (Google Drive): uses Google Drive
- Update row in sheet with link to video (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Google Drive
n8n-nodes-base.googleDrive
From the author
Who it’s for This workflow is for content creators and marketers who write short scripts in Google Sheets and want to automatically turn each line into an AI-generated avatar video stored in Google Drive, with links written back to the sheet. How it works A…