Hi there, Woxians! 👋

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

If you are not feeling like reading, please check out the following video. But if you do, see the below step-by-step tutorial.

We are going to use tools that are going to help us get different quotes for our videos. The first tool is BrainyQuote to get quotes bank and Web Scrapper IO as our scraping platform, so make sure you install the Chrome Extension before starting.

Step 1

Let's open our quote bank page (BrainyQuote) and right-click on Inspect.

Step 2

Now, let's search for the Web Scraper tab and click on it.

Step 3

Let's click on Create new sitemap and select Import Sitemap. (Make sure the Inspection preview is big enough so this option will display.)

Step 4

Inside the Sitemap JSON section, paste the following code to make the scraping. Then, make sure to click on Import 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}]}

Step 5

Now, let's edit the metadata. Click on Sitemap brainquote and select Edit metadata.

There, you will add the URL for the quotes you want to be extracted from. So, make sure you add all of those you want and click on Save Sitemap once you are done.

Step 6

Let's the party start. Click on Sitemap brainquote again, click on Scrape, and then Start scraping.

Step 7

Just wait a couple of seconds until it is ready. If you are not getting any results, click on the Refresh button and get all the data. Now, copy all those results and go to a spreadsheet to start working on your videos.

Step 8

On a spreadsheet, create another sheet to paste our quotes and rename it so you can identify it later.

Make sure we have the best quotes. To do so, let's filter the Quote Text and delete any Null results by giving a right-click and selecting Delete selected rows.

Step 9

Now, let's go back to our video format sheet to link the raw data with our videos. We must use the GoogleSheets formulas. In Title 1, enter the following:


=CONCATENATE("Quotes by ", Raw_Data!D2)

D2 is where I have my data stored. So, it will vary depending on where you have your data.

Raw_Data is the name I gave to my sheet will all the quotes. So, it will vary depending on the name you gave to your sheet.

We have the authors ready, so let's link the quotes. In Title 2, enter the following:

=Raw_Data!C2

Step 10

Now, let's fill out the rest of the columns. You can use Smart Media to add any video or music to your videos. Once you are done editing all the fields, copy the link of your spreadsheet and go to Woxo to build your videos! Start a new project, click on Integrations and select Import GoogleSheet.

Make sure you give access to Woxo to be able to collect all the information.

And tadaaaaa!!! 🥳🥳🥳 Now, just check out how amazing your videos are and export them!

*** More Information:

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


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?