Hi guys!

Let's mass-produce videos with quotes by scraping a quote content website.

Topics

  • Tools and resources.

  • Finding a Template.

  • Getting quotes data.

  • Data curation in Google Spreadsheets.

  • Using Google Sheets formulas and references.

  • Importing Data into WOXO

  • Bulk exporting videos.

Tools and resources

Getting quotes data by scrapping brainyquotes.

If you are using Web Scraper IO just copy/paste this sitemap using the import sitemap option.

Sitemap

{"_id":"brainquote","startUrl":["https://www.brainyquote.com/topics/experience-quotes","https://www.brainyquote.com/topics/inspirational-quotes"],"selectors":[{"id":"quote","type":"SelectorElement","parentSelectors":["_root"],"selector":"div.grid-item","multiple":true,"delay":0},{"id":"quoteText","type":"SelectorText","parentSelectors":["quote"],"selector":".oncl_q","multiple":false,"regex":"","delay":0},{"id":"quoteAuthor","type":"SelectorText","parentSelectors":["quote"],"selector":".oncl_a","multiple":false,"regex":"","delay":0}]}

Spreadsheet

https://docs.google.com/spreadsheets/d/1zLX1CZT_m9vYNLu2MV2F8Kh129dTTOICL27hjl4nfHM/edit#gid=1952687550

Videos

https://woxo.tech/watch/@darieladmin/JX-oOQzQ_QuiK

Did this answer your question?