In this guide you'll create a Zap which uses Shotstack Workflows to create data-driven video at scale.

We begin by creating a template. A template is the starting point to creating video at scale, through the use of Merge Fields. In this guide you won't create your own template, as you will use this template which has been built for you.

Click on Use Template to continue. This will take you through to the Shotstack Studio where you can edit your Template.

We will leave the template as it is, but if you are interested in learning more about the Shotstack Studio this article is a good starting guide.

Now click Use Template in the top-right corner of your screen and select Workflows - Webhook.

After clicking the Workflows - Webhook button this will automatically create a Workflow pre-configured with your Template.

We will have pre-configured the Webhook Trigger and Render Video Template Action such that you do not need to do anything.

Make sure to name the output of your Workflow something memorable, as you will need to use it in Zapier.

You can add additional Actions to your Workflow such as sending your final videos to AWS S3, use generative AI or manipulate your media in other ways. For this guide you can keep the Workflow as is.

You are now ready to start configuring Zapier.

Our Zap will run from this spreadsheet, where you will create a video listing for every row where the status column is set to pending. Make sure to copy the spreadsheet.

We will use the New or Updated Spreadsheet Row Event for Google Sheets to trigger the Zap every time a new row is added or updated in the spreadsheet.

You only want the video to be created if the status column is set to pending. Use the Filter Action to only let the Zap proceed when the column value is equal to pending.

Now it's time for the Shotstack Workflow to be triggered. Select your Workflow from the list and map all your Google Sheet columns to the correct Merge Field. When this step is executed a Workflow Job is triggered.

As videos need to be rendered it can take about a minute to render this particular video. To play it safe delay your Zap by 2 minutes using the Delay Action.

Now query the status of your Workflow Job. You can map the Job ID from the Shotstack Workflow Action to the Workflow Job ID. The result of this step will give you your final Workflow outputs.

Now update your spreadsheet with the results from the Workflow. Update the Job Status and Link column with the appropriate properties from the Shotstack Workflow Job Status results.

You can find your video by searching for the output name set up in your Shotstack Workflow. In this case it is RENDER_VIDEO_TEMPLATE_0.

Your automation is now complete. After a successful Zap you will start to see links appearing in your spreadsheet.