Hi there you brave Woxian! This time today we're going to learn a cool trick that will allow us to take those Capterra Reviews and turn them into ✨videos✨. Exited yet? Let's get moving people!
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":"capterra_reviews","startUrl":["https://www.capterra.com/p/205994/Pabbly-Connect/","https://www.capterra.com/p/154278/Integromat/","https://www.capterra.com/p/177145/Publer/","https://www.capterra.com/p/173776/lemlist/"],"selectors":[{"id":"ProductName","type":"SelectorText","parentSelectors":["_root"],"selector":"[data-test-id=\"ProductHeader__Nimbus_ProductHeading\"]","multiple":false,"regex":"","delay":0},{"id":"Review1","type":"SelectorElement","parentSelectors":["_root"],"selector":"[data-test-id=\"review-card\"]:nth-child(4)","multiple":false,"delay":0},{"id":"Review2","type":"SelectorElement","parentSelectors":["_root"],"selector":"[data-test-id=\"review-card\"]:nth-child(5)","multiple":false,"delay":0},{"id":"Review3","type":"SelectorElement","parentSelectors":["_root"],"selector":"[data-test-id=\"review-card\"]:nth-child(6)","multiple":false,"delay":0},{"id":"Review1Description","type":"SelectorText","parentSelectors":["Review1"],"selector":"[data-test-id=\"review-content\"] > div > div:nth-child(2)","multiple":false,"regex":"","delay":0},{"id":"Review2Description","type":"SelectorText","parentSelectors":["Review2"],"selector":"[data-test-id=\"review-content\"] > div > div:nth-child(2)","multiple":false,"regex":"(?<=(Overall:|Pros:)).*$","delay":0},{"id":"Review3Description","type":"SelectorText","parentSelectors":["Review3"],"selector":"[data-test-id=\"review-content\"] > div > div:nth-child(2)","multiple":false,"regex":"(?<=(Overall:|Pros:)).*$","delay":0},{"id":"Review1Reviewer","type":"SelectorText","parentSelectors":["Review1"],"selector":".nb-items-center","multiple":false,"regex":"","delay":0},{"id":"Review2Reviewer","type":"SelectorText","parentSelectors":["Review2"],"selector":".nb-items-center","multiple":false,"regex":"","delay":0},{"id":"Review3Reviewer","type":"SelectorText","parentSelectors":["Review3"],"selector":".nb-items-center","multiple":false,"regex":"","delay":0}]}
Spreadsheet used in the video
https://docs.google.com/spreadsheets/d/1NVqdmZ6-YKxHA8OMS-AIyNY4vYDdWRnirvd0Jma0opw/edit?usp=sharing
Final Videos 🥳
https://woxo.tech/watch/@belen.koffman/JX-Jm05ggbqrP
And that's it: CONGRATULATIONS! You're ready to create as many 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!