Welcome once again Woxians! Ready to create some killer marketing videos? 😎 Today we're focusing on using reviews from different products to create videos showcasing your products πŸ’₯

Topics

  • Tools and resources.

  • Finding a Template.

  • Getting the data.

  • Data curation in Google Spreadsheets.

  • Using Google Sheets formulas and references.

  • Importing Google Sheet into WOXO

  • Building and bulk exporting videos.

Tools and resources.

Getting the data

If you are using Web Scraper IO just copy/paste this sitemap when using the import sitemap option (as shown in the video!).

Sitemap

{"_id":"amazon_reviews_toys","startUrl":["https://www.amazon.com/Bunch-Balloons-Rapid-Fill-Amazon-Exclusive/dp/B07XYQY7SV?th=1","https://www.amazon.com/HAPEE-Sweater-Holiday-Pumpkin-Halloween/dp/B076CM4N5X","https://www.amazon.com/Fashion-Focus-Clothes-Knitwear-Thickening/dp/B0785S725X"],"selectors":[{"id":"ProductImage1","type":"SelectorImage","parentSelectors":["_root"],"selector":"#main-image-container .itemNo0 .a-dynamic-image","multiple":false,"delay":0},{"id":"ClickImages","type":"SelectorElementClick","parentSelectors":["_root"],"selector":"#altImages .imageThumbnail","multiple":true,"delay":2000,"clickElementSelector":"#altImages .imageThumbnail","clickType":"clickOnce","discardInitialElements":"do-not-discard","clickElementUniquenessType":"uniqueCSSSelector"},{"id":"ProductImage2","type":"SelectorImage","parentSelectors":["_root"],"selector":"#main-image-container .itemNo1 .a-dynamic-image","multiple":false,"delay":0},{"id":"ProductImage3","type":"SelectorImage","parentSelectors":["_root"],"selector":"#main-image-container .itemNo2 .a-dynamic-image","multiple":false,"delay":0},{"id":"Review1","type":"SelectorElement","parentSelectors":["_root"],"selector":"[data-hook=\"review\"]:nth-child(1)","multiple":false,"delay":0},{"id":"Review1Title","type":"SelectorText","parentSelectors":["Review1"],"selector":"[data-hook=\"review-title\"]","multiple":false,"regex":"","delay":0},{"id":"ProductTitle","type":"SelectorText","parentSelectors":["_root"],"selector":"#productTitle","multiple":false,"regex":"","delay":0},{"id":"Review2","type":"SelectorElement","parentSelectors":["_root"],"selector":"[data-hook=\"review\"]:nth-child(2)","multiple":false,"delay":0},{"id":"Review2Title","type":"SelectorText","parentSelectors":["Review2"],"selector":"[data-hook=\"review-title\"]","multiple":false,"regex":"","delay":0},{"id":"Review3","type":"SelectorElement","parentSelectors":["_root"],"selector":"[data-hook=\"review\"]:nth-child(3)","multiple":false,"delay":0},{"id":"Review3Title","type":"SelectorText","parentSelectors":["Review3"],"selector":"[data-hook=\"review-title\"]","multiple":false,"regex":"","delay":0},{"id":"ReviewerName1","type":"SelectorText","parentSelectors":["Review1"],"selector":".a-profile-name","multiple":false,"regex":"","delay":0},{"id":"ReviewerName2","type":"SelectorText","parentSelectors":["Review2"],"selector":".a-profile-name","multiple":false,"regex":"","delay":0},{"id":"ReviewerName3","type":"SelectorText","parentSelectors":["Review3"],"selector":".a-profile-name","multiple":false,"regex":"","delay":0},{"id":"Review1Description","type":"SelectorText","parentSelectors":["Review1"],"selector":".reviewText","multiple":false,"regex":"","delay":0},{"id":"Review2Description","type":"SelectorText","parentSelectors":["Review2"],"selector":".reviewText","multiple":false,"regex":"","delay":0},{"id":"Review3Description","type":"SelectorText","parentSelectors":["Review3"],"selector":".reviewText","multiple":false,"regex":"","delay":0},{"id":"Review1Rating","type":"SelectorText","parentSelectors":["Review1"],"selector":".review-rating","multiple":false,"regex":"^.{1,3}","delay":0},{"id":"Review2Rating","type":"SelectorText","parentSelectors":["Review2"],"selector":".review-rating","multiple":false,"regex":"^.{1,3}","delay":0},{"id":"Review3Rating","type":"SelectorText","parentSelectors":["Review3"],"selector":".review-rating","multiple":false,"regex":"^.{1,3}","delay":0}]}

Spreadsheet used in the video

https://docs.google.com/spreadsheets/d/1hzDNxDcC2k-6SLnvvTL5MDlnTfkp-W5zm1dIAyhAAdE/edit?usp=sharing

Final Videos πŸ₯³

https://woxo.tech/watch/@belen.koffman/JX-egSfgc9jka


And that's it: CONGRATULATIONS! You're ready to create as many marketing videos 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?