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:
"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",
"Video Shape": "yourinfo",
Team & Token: you can get this under the My Account menu on WOXO - just scroll down until you find this:
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:
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!