Hi Woxians! 👋

Today, we're back with another super cool use case. Learn how to automate fun travel videos by using a Google Spreadsheet, schedule and share them on YouTube. Should we get started? 👀

Add Meta Date Column

First thing first, You need to add a Meta_Date column to your spreadsheet. This will be the date in which every video is meant to be posted! Just added it after all the other columns as shown in the image below:

Step 1: Select Every Day trigger

Start by setting up your trigger in this case, your going to choose Schedule by Zapier and under Trigger Event your going to choose Every Day.

Step 2: Set up action

Make sure you activate the trigger on weekends, if that's what you wish for, by selecting yes and the Time of Day you want. In this case, we selected 10am.

Step 3: Select Lookup Spreadsheet Row in Google Sheets

Now to the next action, select Google Sheets in the Choose app & event section and continue to look for the Lookup Spreadsheet Row under Action Event.

Step 4: Set up action

Make sure you select the correct Spreadsheet and Worksheet. Under Lookup Column and Lookup Value choose the options you can see below:

The other sections that you can't see here remain the same or in other words, leave empty.

Step 5: Select Custom Request

This will be your third action and for this one, you'll need to choose Webhooks by Zapier and under the Action Event select Custom Request.

Step 6: Set up action

Make sure you follow the following format to set up your action correctly! Below you'll find the URL needed to continue:

https://api.woxo.tech/video/native/generate

Select Data

{ "data": [{ "Media 1": "2. Media 1:vacation /video", "Media 2": "2. Media 2:https://vod.fro…to-2379864.jpeg", "Media 3": "2. Media 3:https://vod.fro…to-2563733.jpeg", "Text 1": "2. Text 1:Awaken to a different world!", "Text 2": "", "Text 3": "", "Title 1": "2. Title 1:Top-Rated Famil…enture Holidays", "Title 2": "2. Title 2:Exploring the Grand Canyon", "Title 3": "2. Title 3:The Bright Ange…takes two days,", "TextPosition": "2. TextPosition:Top", "TextColor": "2. TextColor:#fff", "BackgroundColor": "2. BackgroundColor:#a62407)", "TextStyle": "2. TextStyle:Criss Cross", "Video Shape": "2. Video Shape:9:16", "Brand": "2. Brand:https://res.clo…ound_224x77.png", "Font": "2. Font:https://res.clo…ush-Regular.ttf", "FontSize":"2. FontSize:8", "Transition": "2. Transition:random", "Music": "2. Music:https://res.clo…vin_MacLeod.mp3" }] }

Add Headers

Make sure you've put the correct team ID and API auth. token under Headers. If you don't know where to find these check out this tutorial. Also, add the Content-Type header along with application/json.

Step 7: Select Delay For

In this case, we decided to delay it for 2 minutes! However, you can choose your own value and unit.

Step 8: Select Get

For this one, you'll need to choose Webhooks by Zapier and under the Action Event select Get.

Step 9: Set up action

Here you just need to be aware of the URL. For this one, you'll need to change the last bit of it and add the Success Code from the second action (Custom Request).

Also, make sure you add the Headers again, same ones you used before and test!

Step 10: Select Upload Video in YouTube

Continue to choose YouTube and under Action Event select Upload Video. Don't forget to connect it to your account before proceeding to Set up action.

Step 11: Set up action

Now for the Title and Description you can connect it to your video's content by clicking on the space of each, clicking on Get and selecting the most accurate option just like shown below:

For the Video make sure you select Data Download Link. In this case, we chose our Privacy Status as private and False for Notify Subscribers, however, these two depend on you.

And once you test this final action, you should be able to see the video in your Channel Content, as shown below:

Now you can easily create a spreadsheet for the month and automate cool and fun travel videos to share them on YouTube on a daily basis! 🎉


If you've got any questions 一 really, any 一 don't be shy and just give a call out at our Support Chat or contact us at [email protected], we'll be more than happy to help you!

Did this answer your question?