Hi Woxians! 👋
Before we begin, we want to give a big thank you to Nicole Genetta for this really cool idea and also allowing us to use her Shopify Store for all the information and media we needed! And her logo 😉
We came up with an interesting alternative to share cool product videos from a Shopify store to Insta stories.
‼️Take into consideration that the videos are not going to be directly posted to your stories. In this tutorial, you're going to set a Google calendar reminder with the video file in order to quickly download and post manually.
Add Meta Date Column
First thing first, You need to add a Meta_Date column to your spreadsheet. This will be the date in which every video is meant to be posted! Just added it after all the other columns as shown in the image below:
Step 1: Select Every Day Trigger
Start by setting up your trigger in this case, your going to choose Schedule by Zapier and under Trigger Event your going to choose Every Day.
Step 2: Set up trigger
Make sure you activate the trigger on weekends, if that's what you wish for, by selecting yes and the Time of Day you want. In this case, we selected 10am.
Step 3: Select Lookup Spreadsheet Row in Google Sheets
Now to the next action, select Google Sheets in the Choose app & event section and continue to look for the Lookup Spreadsheet Row under Action Event.
Step 4: Set up action
Make sure you select the correct Spreadsheet and Worksheet. Under Lookup Column and Lookup Value choose the options you can see below:
The other sections that you can't see here remain the same or in other words, leave empty.
Step 5: Select Custom Request
This will be your third action and for this one, you'll need to choose Webhooks by Zapier and under the Action Event select Custom Request.
Step 6: 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:
Select Data
{ "data": [{ "Media 1": "2. Media 1:https://res.clo…1024_aujqf8.jpg", "Media 2": "2. Media 2:https://res.clo…5751_pcnseu.jpg", "Media 3": "2. Media 3:https://res.clo…419a_u4grii.jpg", "Media 4": "2. Media 4:https://res.clo…1024_aujqf8.jpg", "Text 1": "2. Text 1:No data", "Text 2": "2. Text 2:No data", "Text 3": "2. Text 3:No data", "Text 4": "2. Text 4:heritageacresmarket.com", "Title 1": "2. Title 1:Columbus Aqua Chicken Nipples", "Title 2": "2. Title 2:The original chicken nipple", "Title 3": "2. Title 3:Made in Europe, not China", "Title 4": "2. Title 4:Lifetime leak free guarantee!", "TextPosition": "2. TextPosition:Top", "TextColor": "2. TextColor:#fff", "BackgroundColor": "2. BackgroundColor:rgba(95, 27, 27, 1)", "TextStyle": "2. TextStyle:Criss Cross", "Video Shape": "2. Video Shape:9:16", "Brand": "2. Brand:https://res.clo…anco_xcl67h.png", "Font": "2. Font:https://res.clo…oto-Regular.ttf", "FontSize":"2. FontSize:12", "Transition": "2. Transition:random", "Music": "2. Music:https://res.clo…strumentals.mp3" }] }
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.
Step 7: Select Delay For
This will be your fourth action and in this case, we decided to delay it for 2 minutes! However, you can choose your own value and unit.
Step 8: Select Get
This will be your fifth action and for this one, you'll need to choose Webhooks by Zapier and under the Action Event select Get.
Step 9: Set up action
Here you just need to be aware of the URL. For this one, you'll need to change the last bit of it and add the Success Code from the second action (Custom Request).
Also, make sure you add the Headers again, same ones you used before and test!
Step 10: Select Quick Add Event in Google Calendar
Now to our last action! 😅 Select Google Calendar and click Quick Add Event under Action Event.
Step 11: Set up action
Under Calendar, just make sure you select the correct one. Then, proceed to write a description of the event under Describe Event in this case we typed Post and selected the video's Data Download Link. Last but not least, you can add attendees, they will also get the reminder!
Check out the video's download link here.
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!