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.
Web Scraper IO (Chrome Extension and Scraping Platform)
Google Sheets
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!