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.

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!


Did this answer your question?