Fetch YouTube Stats from Data API - without OAuth

[sourabh]

Demo

What are we really after?

For every video that’s listed publicly on a channel - STATS

Web app

Note: You’d first need an API key from your Google Cloud console - read this for more details.

You could then try this out on your own, here -
https://app.dashdash.com/published/QMqL6Yl92hnvduRsu2KiFptSHDt2Q9HDxz7MVvELow7_/

Rant

If you’re anything like me, then even you too dread the annoying OAuth way of obtaining authorization credentials

Lucky for us, the YouTube Data API supports 2 types of authorization -

• OAuth 2.0
• API keys

Obviously, this post would make use of the 2^nd option to get stats for any publicly listed channel on YouTube using their Data API

API Resources

• Channels: list - you input the username or channel ID and the API fetches the playlist ID that buckets every single video that were ever publicly uploaded on the channel
• PlaylistItems: list - once you get the playlist ID, this API allows you to query all the videos (i.e. the video ID) that the playlist holds
• Videos: list - finally, given every video ID, we then get to fetch the relevant details i.e. name, upload date and most importantly, the stats

Gotchas

I blew through my YouTube Data API Quota for a day simply during random testing; albeit, I test like a mad-person and it takes a ton of trial & errors to make sure I get to cover all plausible edge-cases.

Setup

1. I make use of 2 things from our action elements
   – Input fields
   – Buttons

2. Invoke YouTube APIs using the GET function (none of their API resources that we use for this app requires anything else) and PARSE their JSON responses accordingly

3. Finally, populate the table below with OVERWRITE_DATA & FILL functions

Sneak peak

This is how the setup looks like from the builder’s POV - I bet the design could be better

Challenge

Now that you know (almost) all that you need, would you be able to build it by yourself?

• Yes, I get the idea
• No, tell me more

I can also always help you set this up too once you’ve registered for our early access program, feel free to block some time using my Calendly link.

Let’s go!
Sourabh | No-Code Builder

The spreadsheet where teams work faster

[egl]

Is there a way to call api’s with Oauth / Oauth2 in Rows?

[sourabh]

Hey @egl — this would depend on the service itself. Most allow server-side access to OAuth APIs but some require users to authorize it (for the first time) from the frontend.

We can definitely support the former scenario and you’ll find a link to a Google Doc that we’d published a while ago here -

Google cloud vision api

Hi Colin, I hope you enjoyed the holidays and are having a great new year! Please find in the link below a guide about how to connect to the Google Analytics API using Google Cloud Platform and OAuth 2.0 Playground The steps will be pretty much similar for the Vision API. The only difference is that instead of selecting the Google Analytics API in the OAuth 2.0 Playground, you will need to select the Vision API. Please let me know if this works for you.

For reference, it’s this one -

How to Automate Google Analytics Reporting

Do please feel free to reach out in case you face any difficulties with it.