As a marketer, I have to approach a lot of YouTube influencers to ask them to promote my client’s product. There are a few paid tools out there that can scrape YouTube data easily, but I prefer using free tools.
Actually, you can use Google Spreadsheet to find YouTube influencers fast by using YouTube Data3 API. Of course, Google Spreadsheet is totally free. If you don’t want to take the effort to set up a spreadsheet, I will also share a free program to help you automatically. Keep reading.
Scrape data from YouTube using Google Spreadsheet
The setup process may be a little complicated. Once setup, you can input a keyword, and this sheet will give you hundreds of YouTube search results including user name, channel name, channel URL, video title, email address, etc. If you have tried import XML in Google Sheet, then this is easy for you.
Configure Spreadsheet
You can skip this process by making a copy of my spreadsheet. If you want to create a new sheet from the ground, follow the steps below.
Step 1. Create a new Google Spreadsheet.
Step2. Click on Tools -> Script Editor.
Step 3. Copy this entire script.
Step 4. Click Create script for Spreadsheet.
Step 5. Delete the placeholder content and paste the script you just copied.
Step 6. Rename the script to ImportJSON.gs and click the save button.
Get YouTube API
This method will use the YouTube API to get data. If you are familiar with JSON, then it is very good. Don’t worry, it is not that difficult. I, myself, have no coding background either.
Step 1. Go to Google Developers Console and create a project. Create a name as you like. You need to login to your Google account if you haven’t.
Step 2. Go to the API Console and select the project that you just registered. In the API Library, select YouTube Data API v3.
Step3. Click the Enable button to enable YouTube API.
Step 4. Next click on the blue ‘Go to Credentials’ button to the right.
Step 5. Choose the select option YouTube Data API v3 for the first select option and Web server(e.g. node js. Tomcat) for the second selection. Then choose Public data. Now click the blue button, “What credentials do I need?.”
Step 6. Wait for Google to create your API key and you should see the screen below where you can copy your API Key.
Get YouTube Data
After that, you get this Google Spreadsheet that I created. You just create a copy of it and then change the “Your API Key” to your own YouTube API key. Viola, you can now input a keyword in A2 and this spreadsheet will give you all the results. The email address is extracted from the description, so there will be blank if no email address found in the channel description.
Youtube API only shows you 50 results, so if you want more results, you need to configure the next page data. Just change the API Key in A52, 103, 154, 205, etc. With this sheet, now you can sort all the data and contact all the YouTube influencers.
Find YouTube Influencers with Buzzsumo
Buzzsumo is a powerful tool that can help you find YouTube influencers in your niche. Here are some steps to use Buzzsumo for this purpose:
- Go to the YouTube Analyzer section of Buzzsumo and enter a keyword or topic related to your niche.
- You will see a list of videos that match your query, along with their views, engagement, and channel information.
- You can filter the results by date, language, country, and other criteria to narrow down your search.
- You can also sort the results by different metrics, such as views, comments, likes, dislikes, and engagement rates.
- To find the influencers behind the videos, click on the channel name or icon and you will see their profile page.
- On the profile page, you can see the influencer’s total subscribers, views, uploads, and average engagement rate.
- You can also see their most popular videos, recent videos, and related channels.
- To contact the influencer, you can either use the email address provided on their profile page or click on the social media icons to reach out to them on other platforms.
Using Buzzsumo, you can easily find YouTube influencers who can help you promote your brand, product, or service to a targeted audience.
Export data using Scraper Chrome Extension
If you don’t like either of these methods, you can also use this Scraper Chrome Extension to scrape search results from YouTube. You can export to Google Sheet or copy it to Office Excel.
Step 1. Once get it installed, go to YouTube and type a keyword to perform a search.
Step 2. Right click on 1 search result and select Scrape Similar and a new window will pop out.
Step 3. You probably want to scrape more data. So you select another info and click Scrape Similar again.
Step 4. Copy the data and paste them into one spreadsheet.
If you know a little bit more about Xpath, you easily use Scrape Similar extension to export the data your want.
Conclusion
No matter which method you use, it can only get you the email address left in the channel description. For those channels that don’t leave an email address in the description, you have to open each channel URL to find it out. To save time, you can use this Chrome Extension to open multiple URLs in one go.
That’s all three methods to help you scrape data from YouTube fast free. Now it is your turn. Which of the tools or methods do you use to find YouTube influencers? Leave your thoughts in the comments.
Best
Nicest
Good
Good
Excellent
Nice
It’s so good
Good
Best
Very nessesary