Hello lovely Woxian! Get ready for another cool workflow that will allow you to automate and save tame. This week's winner: a Zapier integration to schedule a video inspired by your Shopify store and send it to Twitter β¨
Step 1: Shopify + Google Spreadsheets
Download a CSV with all the info from your Shopify Store and use it to create a Template for your videos using Google Spreadsheets.
To download the info from Shopify go to the Products page and from there click on Export as displayed here:

Here's the example used on the video: https://docs.google.com/spreadsheets/d/1Z8ncyTNZBHzGy9GIH7eUdoY_JiYgzUxmte5g035k7QY/edit?usp=sharing
Remember to add a Date Column at the end that we'll be using later π

Step 2: Setting an Everyday Trigger
We're going to set a trigger that will happen everyday at a set time. Like this:

Step 3: Lookup Spreadsheet Row in Google Sheets
Now, we're going to connect to Google Sheets and remember the columns with the date? We'll be looking for a match there with the current date and boom! We have a match and we have a video to create! π₯³

Step 4: Connect your WOXO account (via Webhooks)
Customize a Webhook integration with WOXO.

For this you will need to enter the following information:

Data:
{
"data": [{
"Media 1": "yourinfo",
"Media 2": "yourinfo",
"Media 3": "yourinfo",
"Text 1": "yourinfo",
"Text 2": "yourinfo ",
"Text 3": "yourinfo",
"Title 1": "yourinfo",
"Title 2": "yourinfo",
"Title 3": "yourinfo",
"TextPosition": "yourinfo",
"TextColor": "yourinfo",
"BackgroundColor": "yourinfo",
"TextStyle": "yourinfo",
"Video Shape": "yourinfo",
"Brand": "yourinfo",
"Font": "yourinfo",
"FontSize":"yourinfo",
"Transition": "yourinfo",
"Music": "yourinfo"
}]
}Headers:
Team & Token: you can get this under the My Account menu on WOXO - just scroll down until you find this:
Content-Type: application/json
Step 5: Select the delay time for triggering the video creation and posting
In here we'll add a little delay as to make sure that the videos are generated properly and we're giving some time (exactly 2 minutes!) to the editor to do they magic β¨

Step 6: Connect WOXO and set Video Code to Success Code
Now it's time to get the video! Select was the Action Event: Webhooks + GET and make sure that you have filed the Video Code with the Success code from Step 2 (WOXO Episode I)

Now in URL you'll need to fill the following:
URL: https://api.woxo.tech/video/native/successcode

Step 7: Connect to Twitter
In this case we're going to be updating a specific Twitter account, so sync with your account.

Now fill out the details (such as description, hashtags and so) to post the video that will be generated from WOXO.

Step 8: Last step - Verification
Go over your Workflow to see everything's looking how you want and that's it! You're ready to activate the flow, sit back and relax while the automations take place π₯³
And that's it: CONGRATULATIONS! You're ready to create as many automations as you'd like and take your video marketing game to the next level π
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!