Import YouTube API Data to Google Sheets

Import YouTube API Data to Google Sheets

Comments:2

  1. Hi Ana, thank you for this, I managed to set up my API url. how do I get the full url of the Youtube videos into google sheets? sorry completely new to this . I’ve set up an api to search for videos with the keyword podcasting and want to get the full url link of the videos as well as the channel IDs, what do I need to add extra from this: https://www.googleapis.com/youtube/v3/search?part=snippet&key={API_key}&q=google sheets&maxResults=50 ?

    1. Hey Riva, have you run that search request yet? If so, in the response you should see a field called items » id » videoId. YouTube doesn’t return the full URL, but it’s easy to construct it yourself by adding that value to the YouTube base URL (https://www.youtube.com/watch?v=).
      For example, when I run the search request for ‘podcasting’, in cell J2 under the items » id » videoId header, I see an ID of PIJpOcFf5h4.
      In a new column, I can make a formula like ="https://www.youtube.com/watch?v="&J2 to get the full URL of the YouTube video. Of course you can copy this down or, even better, add it to an array formula like =arrayformula("https://www.youtube.com/watch?v="&J2:J) to get the URLs for all the video IDs returned by the API. Let me know if that makes sense!

Leave a Reply

Your email address will not be published.