Hi there, Woxians!! 👋

In this use case we're going to learn how to automate cool thank you videos for your customers and send them to each in Gmail. Let's begin! 😎

First thing first, You need to add an Email column to your spreadsheet. This will be the email address to which your Thank You videos are sent! Just added it after all the other columns as shown in the image below:

Step 1: Select New Spreadsheet Row in Google Sheets trigger

Choose Google Sheets and continue to click New Spreadsheet Row under the Trigger Event option.

Step 2: Set up action

Just make sure you select the correct Spreadsheet and Worksheet. This information will allow us to actually generate the video.

Step 3: Select Custom Request

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

Step 4: 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": "thank you", "Media 2": "thankful", "Media 3": "amazing", "Text 1": "And I wanted to say thank you", "Text 2": "Cicero", "Text 3": "love ya", "Title 1": "You're amazing!", "Title 2": "Gratitude is of all others.", "Title 3": "Thank You!", "TextPosition": "Top", "TextColor": "#212121", "BackgroundColor": "#0fbd26", "TextStyle": "Criss Cross", "Video Shape": "1:1", "Brand": "https://res.cloudinary.com/dakp804eh/image/upload/v1617214228/Woxo/Logos/Logo_con_Background_224x77.png", "Font": "https://res.cloudinary.com/dakp804eh/raw/upload/v1618505979/woxo-video-fonts-presets/Caveat_Brush/CaveatBrush-Regular.ttf", "FontSize":"8", "Transition": "random", "Music": "https://res.cloudinary.com/dakp804eh/video/upload/v1624041564/woxo-video/audios-v2/Romantic/Darling_Ranch_-_Jingle_Punks.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 5: Select Delay For

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

Step 6: Select Get

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

Step 7: 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 8: Select Send Email in Gmail

Choose Gmail and select Send Email under Action Event.

Step 9: Set up action

Here is where the column we added in our spreadsheet is very helpful! You'll just need to insert the data from the Email column. Every time you add a new row, it will automatically know where to find the address where the email is sent to.

Adjust the other sections to your liking! Remember you can add the Data Landing to the Body and you can also include the video's Data Download Link under the Attachments section.

Once you test it the email should be sent!

For this use case, we used the Thank You templates found in our Greetings Category.

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!