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"
    }]
    }

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

  • 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:

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!

Did this answer your question?