{"id":21613,"date":"2025-07-18T18:55:05","date_gmt":"2025-07-18T09:55:05","guid":{"rendered":"https:\/\/84office.jp\/?p=21613"},"modified":"2025-07-18T18:55:06","modified_gmt":"2025-07-18T09:55:06","slug":"googlesheets-gas-youtube-data-api","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/googlesheets-gas-youtube-data-api\/","title":{"rendered":"Google Sheets YouTube API: Retrieve and List 500+ Videos with Apps Script"},"content":{"rendered":"
[Contact us here]<\/div>
[0]<\/div>
[3]<\/div>
[3]<\/div>
[2]<\/div>
[2]<\/div>
[1]<\/div>
[1]<\/div>
[0]<\/div>\n

The script introduced in this article is a paid product<\/strong>.<\/p>\n\n\n\n

Previously, I shared a free Google Apps Script (GAS) that lets you collect YouTube video data into a Google Sheet.
However, the free version is limited to retrieving up to 500 videos<\/strong> per channel due to YouTube API restrictions.<\/p>\n\n\n\n

For those who need to fetch more than 500 videos<\/strong>, I\u2019ve prepared a premium version<\/strong> of the Apps script.
(Note: Each run can fetch up to 50 videos at a time, just like the free version.<\/em>)<\/p>\n\n\n\n

A ready-to-use Google Sheets template<\/strong> is also included.<\/p>\n\n\n\n

Template Features:<\/span><\/span><\/div>
\n
    \n
  • Input fields for Channel ID and fetch range (start\/end position) are pre-configured.<\/li>\n\n\n\n
  • The output area is neatly laid out; data will be automatically listed once retrieved.<\/li>\n\n\n\n
  • The Apps script is already linked, so after copying the sheet, you only need to set your API key in the script properties once, and you\u2019re ready to go.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n

    This solution lets you automatically retrieve YouTube video data in bulk, list it in your spreadsheet, and instantly use it for management or analysis<\/strong>.
    If you want to save time<\/strong> and manage YouTube channels efficiently<\/strong>, this tool is for you!<\/p>\n\n\n\n

    Differences Between the Free and Paid Scripts<\/h2>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Limitations of the Free Version (Up to 500 Videos)<\/span><\/strong><\/span><\/div>
    \n

    The free script uses the search endpoint<\/strong> of the YouTube Data API.
    However, this endpoint can only retrieve up to 50 videos per request<\/strong>, and even with pagination, it is limited to a maximum of 500 videos<\/strong> per channel.<\/p>\n<\/div><\/div>\n\n\n\n

    Improvements in the Paid Version (Retrieve Over 500 Videos)<\/span><\/strong><\/span><\/div>
    \n

    The paid script utilizes the playlistItems endpoint<\/strong>, which allows access to the channel\u2019s full list of uploaded videos (the “Uploads” playlist).
    By strengthening the pagination process, the paid version enables you to retrieve more than 500 videos<\/strong> from a channel.<\/p>\n<\/div><\/div>\n\n\n\n

    \n
    What is an \u201cEndpoint\u201d?<\/span><\/i><\/i><\/span><\/summary>
    \n

    An endpoint<\/strong> is a specific URL that you interact with when making requests to an API.<\/p>\n\n\n\n

    The YouTube Data API offers multiple endpoints depending on your goal\u2014for example:<\/p>\n\n\n\n

      \n
    • search endpoint<\/strong>: used to search for videos<\/li>\n\n\n\n
    • playlistItems endpoint<\/strong>: used to fetch the list of videos from a channel<\/li>\n<\/ul>\n\n\n\n
      Example: Think of Endpoints as Website Pages<\/span><\/strong><\/span><\/div>
      \n
      \n

      search endpoint:<\/dt>\n\n\n\n
      \n

      Like using YouTube\u2019s search bar to find videos by keywords.<\/p>\n<\/dd>\n\n\n\n

      playlistItems endpoint:<\/dt>\n\n\n\n
      \n

      Like opening the \u201cVideos\u201d tab on a YouTube channel to see the full list of uploaded videos.<\/p>\n<\/dd>\n<\/dl>\n<\/div><\/div>\n<\/div><\/details>\n<\/div>\n\n\n\n

      \n
      What is \u201cPagination\u201d?<\/span><\/i><\/i><\/span><\/summary>
      \n

      Pagination<\/strong> is a way to retrieve additional data, similar to flipping through pages in a book or magazine.
      Just as you click \u201cNext page\u201d in web search results to see more items, APIs require pagination to fetch the next set of data until you\u2019ve collected everything you need.<\/p>\n<\/div><\/details>\n<\/div>\n\n\n\n

      Paid Version: Apps Script for YouTube Video Export<\/h2>\n\n\n\n

      [Special Pricing Available!]<\/p>\n\n\n\n

      <\/div><\/div>","protected":false},"excerpt":{"rendered":"

      [Contact us here] [0] [3] [3] [2] [2] [1] [1] [0] The script introduced in this article is a paid product. Pre […]<\/p>\n","protected":false},"author":1,"featured_media":22423,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=17977","footnotes":""},"categories":[12],"tags":[],"class_list":["post-21613","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/21613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=21613"}],"version-history":[{"count":6,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/21613\/revisions"}],"predecessor-version":[{"id":22506,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/21613\/revisions\/22506"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/22423"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=21613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=21613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=21613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}