Zapier: Convert your Shopify store to product videos on Twitter

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:

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