Key takeaways
- Automate video generation by connecting Google Sheets to Sendspark Agentic Workflows.
- First create a Dynamic Video Campaign with your personalization variables, then a sheet with matching columns (First Name, Email, Background URL, etc.).
- In Agentic Workflows, use Google Sheets as the trigger and Sendspark → Create Dynamic Video as the action.
- Map your sheet columns to the campaign variables, then enable the workflow — new rows generate videos automatically.
🤖 Use Agentic Workflows to automatically generate personalized Dynamic Videos whenever new data is added to a Google Sheet Row.
🎥 Step 1: Create a Dynamic Video Campaign
Create your Dynamic Video Campaign and configure all personalization variables. https://sendspark.com/dynamic-videos📊 Step 2: Prepare Your Google Sheet
Create a Google Sheet and add the columns you want to use for personalization (First Name, Email, Background URL, etc.).⚙️ Step 3: Create an Agentic Workflow
Go to Agentic Workflows and create a new automation. https://sendspark.com/agentic-workflows- Select Google Sheets as the trigger.
- Choose the spreadsheet you want to monitor.
🚀 Step 4: Add Sendspark as the Action
Add a new action and select: Sendspark → Create Dynamic Video Then choose the Dynamic Video Campaign you created earlier.🔗 Step 5: Map Your Fields
Match the columns from Google Sheets with the corresponding variables in your Dynamic Video Campaign.✅ Step 6: Enable the Workflow
Save the workflow and turn it on. Any new rows added to the spreadsheet will automatically generate personalized Dynamic Videos.🎉 That’s It!
Your Dynamic Videos will now be generated automatically using the data stored in Google Sheets.Frequently asked questions
What triggers a new video to be generated?
What triggers a new video to be generated?
Adding a new row to the Google Sheet you’re monitoring triggers the workflow to generate a personalized Dynamic Video from that row’s data.
What do I need to set up first?
What do I need to set up first?
Create your Dynamic Video Campaign and configure all its personalization variables before building the workflow, so there’s a campaign for the action to reference.
Which columns should my Google Sheet have?
Which columns should my Google Sheet have?
Add the columns you want to personalize with — for example First Name, Email, and Background URL — then map them to your campaign’s variables.
Which action do I choose in the workflow?
Which action do I choose in the workflow?
Add the Sendspark → Create Dynamic Video action and select the Dynamic Video Campaign you created earlier, then map your fields.
Related articles
- Sendspark Automated Workflows: Beginner’s Guide
- How to Create a Dynamic Video Campaign
- Agentic Workflows: Add Variable Fallbacks
- Form Triggers: Auto-Create Videos