{"id":16753,"date":"2024-12-18T00:30:00","date_gmt":"2024-12-17T15:30:00","guid":{"rendered":"https:\/\/84office.jp\/?p=16753"},"modified":"2024-12-17T23:30:11","modified_gmt":"2024-12-17T14:30:11","slug":"get-youtube-data-api","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/get-youtube-data-api\/","title":{"rendered":"YouTube API Key Setup: Export and Manage Video Data in Google Sheets"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>To retrieve video data and channel information from YouTube and manage it in Google Sheets, the YouTube API is a powerful and convenient tool.<\/p>\n\n\n\n<p>By using the API, you can automatically import information from YouTube.<\/p>\n\n\n\n<p>This article will show you how to obtain the YouTube Data API key, which is the most typical of the several YouTube APIs.<\/p>\n\n\n\n<p>This will be a preparation for how to use the API to compile video data into a spreadsheet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">What is the YouTube API?<\/h2>\n\n\n\n<p>The YouTube API is a mechanism that allows external applications and websites to access YouTube videos and channel information.<\/p>\n\n\n\n<p>This allows data to be managed and displayed in spreadsheets and other formats.<\/p>\n\n\n\n<p>There are several types of YouTube APIs, but the most common is the YouTube Data API.<\/p>\n\n\n\n<p>You will have access to the following information<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Obtain video title, number of views, number of comments, etc.<\/li>\n\n\n\n<li>List of subscribers and uploaded videos on the channel<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-60\">Creating and editing playlists<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\">Steps to Obtain a YouTube Data API Key<\/h2>\n\n\n\n<h3 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Obtaining a YouTube Data API Key<\/h3>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Creating a Google Cloud Platform Account<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"395\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f262afedb3eab997bc9f965be7a7e939-1024x395.png\" alt=\"\" class=\"wp-image-16757\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f262afedb3eab997bc9f965be7a7e939-1024x395.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f262afedb3eab997bc9f965be7a7e939-300x116.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f262afedb3eab997bc9f965be7a7e939-768x296.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f262afedb3eab997bc9f965be7a7e939-1536x592.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f262afedb3eab997bc9f965be7a7e939-2048x789.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Go to the official <strong><a href=\"https:\/\/cloud.google.com\/free\/?utm_source=google&amp;utm_medium=cpc&amp;utm_campaign=japac-TH-all-en-dr-BKWS-all-core-trial-EXA-dr-1605216&amp;utm_content=text-ad-none-none-DEV_c-CRE_602345109763-ADGP_Hybrid%20%7C%20BKWS%20-%20EXA%20%7C%20Txt%20-GCP-General-core%20brand-main-KWID_43700071562408604-kwd-87853815&amp;userloc_9198369-network_g&amp;utm_term=KW_gcp&amp;gad_source=1&amp;gclid=CjwKCAiA34S7BhAtEiwACZzv4S2yMNhN2kIOL5YSKOzZqLpe1XzMVqf1vcMfYGxObKbkxAQkcn-cvRoCaQcQAvD_BwE&amp;gclsrc=aw.ds&amp;hl=en\" target=\"_blank\" rel=\"noreferrer noopener\">Google Cloud Platform (GCP)<\/a><\/strong> website.<\/p>\n\n\n\n<p>If you are using it for the first time, click <strong>&#8220;Get Started for Free&#8221;<\/strong>, and log in with your Google account or create a new account.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Selecting a Project<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"499\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-1024x499.png\" alt=\"\" class=\"wp-image-16758\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-1024x499.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-300x146.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-768x375.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-1536x749.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-2048x999.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-0b0f55ee-a0f6-482b-a0a6-947344ea0e3f\">Once you&#8217;re on the dashboard, click <strong>&#8220;Select a project&#8221;<\/strong> located at the top left of the screen.<\/p>\n\n\n\n<p>Here, create a new project and proceed with preparing to use the API.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Creating a Project<br><\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-1024x335.png\" alt=\"\" class=\"wp-image-16760\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-1024x335.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-300x98.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-768x251.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1.png 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Click <strong>&#8220;New Project&#8221;<\/strong> to create a new project.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Set a Name for Your Project.<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"697\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-1024x697.png\" alt=\"\" class=\"wp-image-16761\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-1024x697.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-300x204.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-768x523.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de.png 1211w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p id=\"block-b53aeee0-629c-434f-9050-a1738af05a1b\">Decide on a project name and click the <strong>&#8220;Create&#8221;<\/strong> button.<\/p>\n\n\n\n<p id=\"block-8acea833-26b7-4680-b76b-4cc5dbec64c1\">The project name is pre-filled by default, but you can change it to any name you like.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Select the Project You Just Created<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-1024x362.png\" alt=\"\" class=\"wp-image-16762\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-1024x362.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-300x106.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-768x271.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf.png 1494w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-435494c9-eeb2-4f86-a4a2-731b07508a95\">From <strong>&#8220;Select a project&#8221;<\/strong>, choose the project you just created.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Select <strong>&#8220;APIs &amp; Services&#8221;<\/strong>.<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"602\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-1024x602.png\" alt=\"\" class=\"wp-image-16763\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-1024x602.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-300x176.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-768x452.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-1536x903.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-2048x1204.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-bf8a9aa3-9578-4de8-ae76-e4b94f6c0c61\">After selecting your project, click on <strong>&#8220;APIs &amp; Services&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Select &#8220;Library&#8221;<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"500\" height=\"552\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/65b73cfa59a7b8fa63282bf9bad62310.png\" alt=\"\" class=\"wp-image-16766\" style=\"width:324px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/65b73cfa59a7b8fa63282bf9bad62310.png 500w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/65b73cfa59a7b8fa63282bf9bad62310-272x300.png 272w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-9b7762c6-a6a3-4bea-aee9-77f05795f15e\">Next, navigate to the <strong>&#8220;Library&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Search for YouTube Data API<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"367\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/296acf2fd1c7d0a4940db3d9219d72fe-1024x367.png\" alt=\"\" class=\"wp-image-16767\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/296acf2fd1c7d0a4940db3d9219d72fe-1024x367.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/296acf2fd1c7d0a4940db3d9219d72fe-300x108.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/296acf2fd1c7d0a4940db3d9219d72fe-768x276.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/296acf2fd1c7d0a4940db3d9219d72fe.png 1240w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Search for <strong>&#8220;YouTube Data API v3&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Enable the API<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-30\"><img decoding=\"async\" width=\"1024\" height=\"229\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/d64bf66c0a7af72fbfb6c50f7124897a-1-1024x229.png\" alt=\"\" class=\"wp-image-16769\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/d64bf66c0a7af72fbfb6c50f7124897a-1-1024x229.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/d64bf66c0a7af72fbfb6c50f7124897a-1-300x67.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/d64bf66c0a7af72fbfb6c50f7124897a-1-768x171.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/d64bf66c0a7af72fbfb6c50f7124897a-1-1536x343.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/d64bf66c0a7af72fbfb6c50f7124897a-1.png 1711w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"388\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/14b5d7c090890c61a8723778c724cc84-1024x388.png\" alt=\"\" class=\"wp-image-16770\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/14b5d7c090890c61a8723778c724cc84-1024x388.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/14b5d7c090890c61a8723778c724cc84-300x114.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/14b5d7c090890c61a8723778c724cc84-768x291.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/14b5d7c090890c61a8723778c724cc84.png 1334w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>From the search results, select <strong>&#8220;YouTube Data API v3&#8221;<\/strong> and click the <strong>&#8220;Enable&#8221;<\/strong> button to activate the API.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Obtaining an API Key<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"393\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-1024x393.png\" alt=\"\" class=\"wp-image-16771\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-1024x393.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-300x115.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-768x295.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-1536x590.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4.png 1726w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Go to <strong>&#8220;APIs &amp; Services&#8221; > &#8220;Credentials&#8221;<\/strong>, then click <strong>&#8220;Create Credentials&#8221;<\/strong> and select <strong>&#8220;API Key&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Copy the Generated API Key.<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-1024x571.png\" alt=\"\" class=\"wp-image-16772\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-1024x571.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-300x167.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-768x428.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6.png 1101w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Copy the generated API key and save it for later use in Google Apps Script.<\/p>\n\n\n\n<p class=\"is-style-icon_pen\">If you are only accessing public data, the <strong>OAuth consent screen<\/strong> is not required, and you can use the <strong>API key<\/strong> alone with the YouTube Data API v3.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Saving the API Key in Script Properties<\/h3>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">To use the API key in <strong>Google Apps Script<\/strong>, save it in the <strong>Script Properties<\/strong>.<\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open the Apps Script Editor.<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"939\" height=\"614\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e.png\" alt=\"\" class=\"wp-image-16773\" style=\"width:453px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e.png 939w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e-300x196.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e-768x502.png 768w\" sizes=\"(max-width: 939px) 100vw, 939px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-b72d9194-4148-4e05-9ac1-dbecdb09694b\">Open your <strong>Google Sheets<\/strong>, go to the <strong>&#8220;Extensions&#8221;<\/strong> menu, and click on <strong>&#8220;Apps Script&#8221;<\/strong> to open the editor.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open the Project Settings<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"555\" height=\"660\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/b17152a330aa1cf28d99ed3ffffce21d.png\" alt=\"\" class=\"wp-image-16774\" style=\"width:361px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/b17152a330aa1cf28d99ed3ffffce21d.png 555w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/b17152a330aa1cf28d99ed3ffffce21d-252x300.png 252w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60\">In the Apps Script editor, select <strong>&#8220;Project Settings&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Add Script Properties<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"236\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-1024x236.png\" alt=\"\" class=\"wp-image-16775\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-1024x236.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-300x69.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-768x177.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808.png 1518w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Select <strong>&#8220;Add Script Properties&#8221;<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/58b4b90a121e1f774408d33a6cd728a2-1024x231.png\" alt=\"\" class=\"wp-image-16776\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/58b4b90a121e1f774408d33a6cd728a2-1024x231.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/58b4b90a121e1f774408d33a6cd728a2-300x68.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/58b4b90a121e1f774408d33a6cd728a2-768x173.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/58b4b90a121e1f774408d33a6cd728a2-1536x346.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/58b4b90a121e1f774408d33a6cd728a2.png 1557w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Enter a key name (e.g., &#8220;YOUTUBE_DATA_API_KEY&#8221;) and the API key.<\/p>\n\n\n\n<p>Once entered, click <strong>&#8220;Save Script Properties&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Testing the API Request<\/h3>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">Once the API key has been obtained and saved in the Script Properties, execute a simple request to confirm that the API is working correctly.<\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Creating the Script<\/strong><\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"444\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8f4140bc1062738ef01744c988a1114e-1024x444.png\" alt=\"\" class=\"wp-image-16777\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8f4140bc1062738ef01744c988a1114e-1024x444.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8f4140bc1062738ef01744c988a1114e-300x130.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8f4140bc1062738ef01744c988a1114e-768x333.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8f4140bc1062738ef01744c988a1114e-1536x666.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8f4140bc1062738ef01744c988a1114e.png 1589w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>function myFunction(){<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">is included from the beginning, delete it and paste the following script.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-30\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function testYouTubeAPI() {\n  var apiKey = PropertiesService.getScriptProperties().getProperty('YOUTUBE_DATA_API_KEY');\n  var channelId = 'YOUR_CHANNEL_ID'; \/\/ Enter the ID of the channel you want to retrieve data from\n  var url = `https:\/\/www.googleapis.com\/youtube\/v3\/channels?part=snippet,statistics&amp;id=${channelId}&amp;key=${apiKey}`;\n  \n  var response = UrlFetchApp.fetch(url);\n  var data = JSON.parse(response.getContentText());\n\n  Logger.log(data); \/\/ Output channel information to the log\n}\n\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">testYouTubeAPI<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> apiKey <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> PropertiesService.<\/span><span style=\"color: #A6E22E\">getScriptProperties<\/span><span style=\"color: #F8F8F2\">().<\/span><span style=\"color: #A6E22E\">getProperty<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&#39;YOUTUBE_DATA_API_KEY&#39;<\/span><span style=\"color: #F8F8F2\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> channelId <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&#39;YOUR_CHANNEL_ID&#39;<\/span><span style=\"color: #F8F8F2\">; <\/span><span style=\"color: #88846F\">\/\/ Enter the ID of the channel you want to retrieve data from<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> url <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">`https:\/\/www.googleapis.com\/youtube\/v3\/channels?part=snippet,statistics&amp;id=<\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">channelId<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\">&amp;key=<\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">apiKey<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\">`<\/span><span style=\"color: #F8F8F2\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> response <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> UrlFetchApp.<\/span><span style=\"color: #A6E22E\">fetch<\/span><span style=\"color: #F8F8F2\">(url);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> data <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> JSON.<\/span><span style=\"color: #A6E22E\">parse<\/span><span style=\"color: #F8F8F2\">(response.<\/span><span style=\"color: #A6E22E\">getContentText<\/span><span style=\"color: #F8F8F2\">());<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  Logger.<\/span><span style=\"color: #A6E22E\">log<\/span><span style=\"color: #F8F8F2\">(data); <\/span><span style=\"color: #88846F\">\/\/ Output channel information to the log<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The <strong><code>apiKey<\/code><\/strong> contains the API key retrieved from the Script Properties.<\/li>\n\n\n\n<li>Specify the ID of the channel you want to retrieve in <strong><code>channelId<\/code><\/strong>.<\/li>\n\n\n\n<li>Construct the API request URL and retrieve the data using <strong><code>UrlFetchApp.fetch<\/code><\/strong>.<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-40\">The retrieved data is in JSON format, so you can parse it with <strong><code>JSON.parse<\/code><\/strong> and check the channel information using <strong><code>Logger.log<\/code><\/strong>.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Save the Script<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"447\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1024x447.png\" alt=\"\" class=\"wp-image-16778\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1024x447.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-300x131.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-768x335.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1536x670.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b.png 1690w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>After writing the script, name and save it.<\/p>\n\n\n\n<p>(e.g., \u201cYoutube Data Acquisition Test\u201d)<\/p>\n\n\n\n<p><br>(Don&#8217;t forget to replace the <code>YOUR_CHANNEL_ID<\/code> part in the script)<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Run Script<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"447\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1-1024x447.png\" alt=\"\" class=\"wp-image-16779\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1-1024x447.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1-300x131.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1-768x335.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1-1536x670.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/29ca445f1d37d407e9bffa47fb7eaf7b-1.png 1690w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">When the execution completes without any error messages and data is output to the log, the YouTube Data API is ready.<\/p>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_memo u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>If you&#8217;re running the script for the first time, you need to authorize it.<\/p>\n\n\n\n<p><strong>Therefore, press &#8220;<strong>Review Permissions.<\/strong>&#8220;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"882\" height=\"345\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png\" alt=\"\" class=\"wp-image-15938\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png 882w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-300x117.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-768x300.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n<\/div>\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Detailed Authorization Steps<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p><strong>Press &#8220;Advanced.&#8221;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-50\"><img decoding=\"async\" width=\"1272\" height=\"688\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg\" alt=\"\" class=\"wp-image-15939\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg 1272w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-300x162.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-1024x554.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-768x415.jpg 768w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><\/figure>\n\n\n\n\n\n\n\n<p><strong>Press &#8220;Go to Untitled project (Unsafe).&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"1305\" height=\"893\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg\" alt=\"\" class=\"wp-image-15940\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg 1305w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-300x205.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-1024x701.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-768x526.jpg 768w\" sizes=\"(max-width: 1305px) 100vw, 1305px\" \/><\/figure>\n<\/div>\n\n\n<p><strong>After that, press &#8220;Allow.&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"955\" height=\"543\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg\" alt=\"\" class=\"wp-image-15941\" style=\"width:566px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg 955w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-300x171.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-768x437.jpg 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure>\n<\/div>\n\n\n\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\">Conclusion<\/h2>\n\n\n\n<p>In this article, I introduced how to obtain and set up the YouTube Data API.<\/p>\n\n\n\n<p>You are now ready to access YouTube data using your API key.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">I will show you how to compile video information into a spreadsheet in another article.<\/p>\n\n\n<div class=\"p-postListWrap\"><ul class=\"p-postList -type-card -pc-col3 -sp-col1\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/shorten-url-generator-bulk\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">How to Bulk Create Shortened URLs Using Google Sheets and Google Apps Script<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-10\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u670810\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/spreadsheet-tab-move\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/501bb85b65f3aaf0bc43320b189e6694-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/501bb85b65f3aaf0bc43320b189e6694-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/501bb85b65f3aaf0bc43320b189e6694-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/501bb85b65f3aaf0bc43320b189e6694-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/501bb85b65f3aaf0bc43320b189e6694.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Enhance Productivity with Google Apps Script: Instantly Rearrange Google Sheets Tabs Right to Left<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-11-14\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7411\u670814\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/get-youtube-data-api\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2e50637a1d40175ef3385963e05ec2a8-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2e50637a1d40175ef3385963e05ec2a8-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2e50637a1d40175ef3385963e05ec2a8-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2e50637a1d40175ef3385963e05ec2a8-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2e50637a1d40175ef3385963e05ec2a8.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">YouTube API Key Setup: Export and Manage Video Data in Google Sheets<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-12-18\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7412\u670818\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>To retrieve video data and channel information from YouTube and manage it in Google Sheets, the YouTube API is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16782,"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=15687","footnotes":""},"categories":[12],"tags":[],"class_list":["post-16753","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\/16753","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=16753"}],"version-history":[{"count":11,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16753\/revisions"}],"predecessor-version":[{"id":22408,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16753\/revisions\/22408"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/16782"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=16753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=16753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=16753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}