How to create video slideshows with Zapier using Google Forms and YouTube

In this article we'll show you how to use Zapier to automatically build a video slideshow from Google Forms and upload it to YouTube.

Before we get started please add the Shotstack Zapier app to your Zapier account. This provides you with access to all Shotstack modules you need to build your automated video slideshow workflow.

Please note that the Shotstack Zapier integration is still in beta. This means that some functionality may not work as expected and that particular modules may not be available in future releases. We would love to hear your experience using our Zapier integration and any ideas you have for other functionalities.

How will this work

We will be using Zapier. Zapier is an automation tool that allows you to build workflows that don't require any code. In this example we'll show you how you can use Zapier to build video slideshows from images uploaded using a Google Form, which are subsequently uploaded to YouTube.

Configuring Google Forms

Go to Google Forms and create a form with a File upload field. Make sure to only allow for images to be uploaded, set the maximum number of files to 5 and make it a required field.

Create a new Google Form with an Upload Filesfield

Shotstack requires your files to be publicly accessible. By default Google Forms creates a folder that only you can access. You can change this by changing by clicking on the View folder link and changing the permissions on the folder to allow files to be viewed by Anyone with the link.

Set the permissions of your folder to be publiclyaccessible

Create a Shotstack account

Make sure you've signed up for a free Shotstack account. The free account provides you with 20 minutes of video every month. Enough to build multiple slideshows.

Building the Zap

After having added the Shotstack integration to your Zapier apps go ahead and create a new Zap.

Google Forms module

We'll start off by creating a trigger to execute our Zap every time someone fills out the Google Form and uploads 5 images. This provides us with all the image links that were uploaded via the form.

Add the Google Form module to your Zap

Split Text module

Because Google Forms provides you with the links in one long comma separated string we will need to extract the individual urls to use for our slideshow. We do this by adding a Split Text formatter to extract the links. Use a comma , as the separator.

Make sure you select the variable with the urls from the Google Forms module and select All (as Separate Fields) under the Segment Index option to turn the links into individual options we can select later when building our video slideshow.

Use a regex pattern to filter out the file IDs

Video Slideshow module

Add the Shotstack Video Slideshow module as the next step of your Zap, and connect your Shotstack account.

Add the Shotstack Video Slideshow module to yourZap

Your Shotstack account comes with two keys, which can be accessed via your dashboard. As we want to create video slideshows without a watermark we'll go ahead and add our Production key.

Use your staging or production key to connect your Shotstack account toZapier

Set up the action by adding the individual urls to the image url fields. Then decide how long you want your images to show, what resolution your video should be in and what type of transition to use between images.

Pro tip: Set up the Zap with 10 image fields (the max amount of files allowed to be uploaded by Google Forms), even if you are going to be using less than 10 images. Zapier will skip all the image fields that do not have a value. You can do the same for other modules and add a maximum amount of image fields based on the maximum amount of images you want to allow in your slideshow. Configure the Video Slideshow module using the images from the Google Formsmodule

Delay module

For this example we want to keep everything together in the same Zap. So instead of using a callback we'll build in a delay and retrieve the status of our video slideshow. We'll set it up to only delay the Zap for a minute as our example slideshow video will take less than 10 seconds to complete.

Add the delay module to your Zap

Poll Render Status module

As a last step we'll add in the Poll Render Status module, which will provide you with the status of the video slideshow and provide you with the link to the video when completed. Add the Shotstack Poll Render Status module toyour Zap

YouTube module

Your video is already available via high performance hosting and you can directly use the link provided in the prior module, but if you want to use another provider such as YouTube to share your video you can use the YouTube module to upload your video to your channel. Add the YouTube module to yourZap

Automated video slideshow

Congratulations. You've built yourself an automated video slideshow workflow that takes uploaded images from Google Forms, transforms them into a video slideshow using Shotstack and then uploads it to YouTube when it's done. All in one Zap!

Pro Tip: If you are looking build even more impressive video slideshows add a soundtrack module to your Zap.

Derk Zomer

BY DERK ZOMER
26th July, 2021