
YouTube is the second-largest search engine after Google. If you create content for your brand and have a presence on YouTube, the automation we've developed can be a valuable asset to your strategy.
We have used Scrapingdog’s YouTube Scraper API, via which we will get the data points for all the videos using a search term. (For this tutorial, we have used the search term “seo in 2025”)
In this blog, we have created an automation to get the videos’ titles, links, channel names, channel links, and more using Make and a YouTube API.
Let’s get started.
What You Will Need For This Automation
- Access to Google Sheets
- Make.com Account (1000 operations free)
- Scrapingdog API_KEY (1000 Credits free)
For those of you who don’t know what Make is, it is a no-code tool that allows you to combine different applications and eventually create a working system. If you are new to Make, I would advise you to understand a little how it works, as that will help you create this system quickly.
You can build this automation entirely free of cost, and if you will be using it quite often, you can upgrade to a bigger plan of Scrapingdog and Make.
Let’s Start Building this Automation:
We will have 2 tabs in this spreadsheet. One is where you will have the keyword for which you want the data.
The other tab (Output) will take all our data.
This is how our output will look when the automation runs for certain keywords in our Input tab.
Next, sign up to make, click “create a new scenario.”
Now you will enter the space where you can create your scenario. The first module we will be using is Google Sheets → Watch New Rows.
So this module will watch for any new rows that are filled in the Input Tab of our sheet.
Next, we will use the ‘HTTP’ module to call our API.
Note: An endpoint in an API defines which API we are using; each dedicated API has a unique endpoint. Every time you want to call an API, you would have to send a GET request to the endpoint of that particular API.
Let’s test this automation up until here.
We get this data. Now we are only interested in video results, so we will get this data in our spreadsheet.
But this data is in an array, so we will have to iterate over this data to get different output bundles for each video.
The next module we will use is an ‘Iterator’
In the iterator module, we will map the data that we want to iterate upon i.e., “video_results”
Let’s test again up until here & see the output the Iterator module gives.
For each video, we get this data.
Now let’s map it to our final module, which is Google Sheets → “Add A Row”
Remember, we talked about taking the output data in the “Output” tab earlier in this blog.
Let’s map it to the correct data points.
Our Automation is complete, let’s test this full automation.
10 Awesome Use Cases For Extracting Data from YouTube API
Using APIs for mass data extraction is essential for modern data analysis. Relying on manual copy-pasting not only consumes valuable time but also increases the risk of errors.
1. Spot Rising Creators Early
Track fresh uploads in your niche and flag channels that gain views fast but still have small audiences. This lets you partner or promote before competitors notice.
2. Competitor Upload Tracker
Keep an eye on rival channels and log every new video they publish. Your team can respond with timely content or commentary instead of playing catch-up.
3. Keyword-Driven Idea Mining
Collect titles and descriptions for a target keyword, group the common angles, and list unserved topics. These gaps feed your content calendar with ideas proven to interest viewers.
4. Build an Ad-Ready Channel List
Filter search results for high-quality, recent videos and pull channel data and contact info. You walk away with a clean prospect sheet for sponsorship or influencer deals.
5. Brand-Mention Monitoring
Search your company name on repeat and surface any new video that mentions you. Jump in quickly to thank supporters or address criticism before it spreads.
6. Weekly “Top Clips” Newsletter
Every Friday, grab the week’s most-watched clips in your field, bundle titles, thumbnails, and view counts, and drop them into an email. Readers get a quick hit of what mattered most.
7. Sentiment-Based Product Research
Pair search results for “<product> review” with video transcripts, score the language, and summarize common likes and complaints. Product and UX teams gain real customer insight in plain words.
8. Auto-Update Site Video Galleries
Fetch the latest keyword-matched videos and push them straight into your CMS collection. Your landing page always shows fresh clips without manual embeds.
9. Regional Trend Comparison
Run the same query across different countries and log view counts and dates. See which topics take off first in each market and plan campaigns accordingly.
10. Podcast Guest Discovery
Search for “new to you” verified channels in your topic area, filter for mid-size subscriber counts, and list them as potential guests. Outreach becomes a simple, data-backed process.
Conclusion
Note that we have used Google Sheets and Make in here, but if you are familiar with Airtable in place of Google sheets, that would work too.
Make, on the other hand, has many alternatives too that you can use. Some of the popular ones are n8n and Zapier. They are similar to what Make offers and if you have been building automations in them, you can use them too.
For the APIs, you can use an official YouTube data API too; the one we have used is a 3rd party provider, and there are a lot of other providers out there that you can use.
This automation can help you with your content research; you would only need to enter the “search term,” and boom, you get all the data points.
You can further deep dive into the data points you get to have a strong research. Moreover, there are more data APIs that you can use or add to the workflows. That way, you can extract a lot of information from the same platform.
Further, you can also use the YouTube Transcript API to summarize each video and the intent, and therefore build better content from what’s already there on YouTube.
Featured Image by Pixabay.
Share this post
Leave a comment
All comments are moderated. Spammy and bot submitted comments are deleted. Please submit the comments that are helpful to others, and we'll approve your comments. A comment that includes outbound link will only be approved if the content is relevant to the topic, and has some value to our readers.
Comments (0)
No comment