Hi there, Woxians!! 👋

In this use case, we will learn how to automate Pinterest's pins while working from a spreadsheet. Let's begin! 😎

First thing first, You need to have your videos ready. So, get creative and get the spreadsheet customized as you prefer.

Now it is time to start our automation, so let's open Zapier and create a new workflow to get started.

Step 1: New or Updated Spreadsheet Row in Google Sheets

Let's start by choosing Google Sheets and continue to click New or Updated Spreadsheet Row under the Trigger Event option. Then it will ask you to select your account. Once connected, you will need to choose the Spreadsheet with all the videos and click continue to test the trigger.

Step 2: Custom Request under Webhooks by Zapier

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

Step 3: 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

Data:

{

"data": [

{ "Title 1": " 1. Title 1:Did you know that...",

"Text 1": "1. Text 1:Fun Facts about Wild Animals",

"Media 1": "1. Media 1:https://vod.fro…oto-706194.jpeg",

"Title 2": "1. Title 2:Only half of th…lf stays awake.",

"Text 2": " 1. Text 2:No data",

"Media 2": "1. Media 2:https://vod.fro…to-4886378.jpeg",

"Title 3": "1. Title 3:Can you believe it?",

"Text 3": "1. Text 3:No data",

"Media 3": "1. Media 3:https://vod.fro…to-2191056.jpeg",

"Video Shape": "9:16",

"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",

"BackgroundColor": "#ffe91a",

"TextColor": "#212121",

"TextStyle": "Solid",

"TextPosition": "Top",

"Transition": "random",

"Music": "happy"

}

]

}

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.

After inputting all this information, we need to test this action and ensure that there is no error.

Step 4: Select Delay For

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

Step 5: Select Get

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

Step 6: Set up action

Here you just need to be aware of the URL. (https://api.woxo.tech/video/native/) For this one, you'll need to include at the end the Success Code from the second action (Custom Request/POST).

Also, make sure you add the Headers again, the same ones you used before and test!

Step 7: Create Pin in Pinterest

In this step, you need to select the board from Pinterest where you want your post to be published. Also, you need to choose the media to display. Zapier only allows you to post an image or a gif, so make sure to select those options under the GET tab.

You can select Thumbnails for the image or Preview for the gif.

Also, you need to input the Link for your video's landing page. You can get this information under Custom Request and select Success Native Landing.

Now, it is ready to test it and check your post on Pinterest.

These integrations are so cool! 😎


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?