We’ve created a YouTube data scraper in Google Sheets that enables you to collect any video data (including title, description, views, likes, comments, etc.) without technical knowledge or complex software to download. We have configured 15 data points for you! All you need is the ImportFromWeb add-on in Google Sheets and you’re ready to start importing powerful YouTube data into our approachable template.
With this kind of tool at your constant disposal, you can collect video metrics and data in bulk, monitor the evolution of those metrics and improve your video performance analysis…
How does it work?
It uses the ImportFromWeb add-on that we built.
ImportFromWeb provides a simple function to extract data from any websites. You just need to find the urls of the pages you want to load and tell ImportFromWeb about the location of the elements you want to extract from those pages.
1. Install the ImportFromWeb add-on
ImportFromWeb is the add-on that collects the data. Simply install it from the Google Workspace Marketplace. You can try it for free, we offer you 1,000 requests (no credit card required!)
2. Make a copy of the YouTube scraper template
Make a simple copy of the template to manipulate it with the video that you wish to scrape from YouTube
3. Activate the ImportFromWeb add-on
Easy step too! In your template copy, activate the add-on through your Google sheets menu: Extensions >> ImportFromWeb >> Activate add-on
4. Start retrieving data
First, choose the data you want to collect from the drop-down lists in the ⌗ Selectors section. We have preconfigured the main YouTube video data selectors.
Then, just input in column C the YouTube video URLs you want to collect the data from and that’s it. The IMPORTFROMWEB function will make the job and scrape the data you’re asking for!
Bear in mind that this template is designed to work with video URLs, i.e. any YouTube video page URL that follows this format:
https://www.youtube.com/watch?v=1XqIWr_WqM4
To make better use of this template and our ImportFromWeb tool, here are a couple of other tips to ensure that your web scraping experience is giving you full access to valuable YouTube video data.
Tip #1: Always stay up-to-date
Extracting data from YouTube can be incredibly rewarding, but you don’t want this information to lose its value over night. We suggest you configure your template with our advanced update system to keep your information up to date.
You can set the frequency of updates based on your preference and always have access to the latest data from YouTube. With our update system, your data will always be fresh and up-to-date.
Tip #2 Use it anywhere
You don’t need to use this template to extract YouTube video data.
It’s very easy to use the IMPORTFROMWEB function wherever you like.
Here is how you can do it:
- Type up to 50 urls, each one in a different cell
| A1 | https://www.youtube.com/watch?v=xxx |
| A2 | https://www.youtube.com/watch?v=yyy |
| A3 | …etc |
- Type the elements you want to extract
| A5 : F5 | title | views | channel_id | published_date | duration | author |
- Use the IMPORTFROMWEB function
| A7 | =IMPORTFROMWEB(A1:A3, A5:F5) |
Any question?
If you feel stuck on anything at all, reach out to our team. We’d love to help you better understand our tools and templates so that you can achieve your desired results.