Apps 脚本代码示例
使用集合让一切井井有条 根据您的偏好保存内容并对其进行分类。
如需运行代码示例，您需要在 Apps Script 中启用 YouTube Data API 和 YouTube Analytics API (v2)。Data API 快速入门介绍了如何添加服务。
将 YouTube 数据分析数据导出到 Google 表格
此函数使用 YouTube Analytics API 提取有关已通过身份验证的用户频道的数据，并使用这些数据在用户的云端硬盘中创建一个新的 Google 表格。
此示例的前一部分演示了简单的 YouTube 数据分析 API 调用。此函数会先提取活跃用户的频道 ID。该函数使用该 ID 发出 YouTube Analytics API 调用，以检索过去 30 天的观看次数、赞过次数、不赞过次数和分享次数。该 API 会在包含二维数组的响应对象中返回数据。
示例的第二部分会构建一个电子表格。此电子表格会放入已通过身份验证的用户的 Google 云端硬盘中，标题为“YouTube 报告”，并包含日期范围。该函数会使用 API 响应填充电子表格，然后锁定用于定义图表轴的列和行。系统会为电子表格添加一个堆叠柱形图。
function spreadsheetAnalytics() { // Get the channel ID var myChannels = YouTube.Channels.list('id', {mine: true}); var channel = myChannels.items[0]; var channelId = channel.id; // Set the dates for our report var today = new Date(); var oneMonthAgo = new Date(); oneMonthAgo.setMonth(today.getMonth() - 1); var todayFormatted = Utilities.formatDate(today, 'UTC', 'yyyy-MM-dd') var oneMonthAgoFormatted = Utilities.formatDate(oneMonthAgo, 'UTC', 'yyyy-MM-dd'); // The YouTubeAnalytics.Reports.query() function has four required parameters and one optional // parameter. The first parameter identifies the channel or content owner for which you are // retrieving data. The second and third parameters specify the start and end dates for the // report, respectively. The fourth parameter identifies the metrics that you are retrieving. // The fifth parameter is an object that contains any additional optional parameters // (dimensions, filters, sort, etc.) that you want to set. var analyticsResponse = YouTubeAnalytics.Reports.query({ "startDate": oneMonthAgoFormatted, "endDate": todayFormatted, "ids": "channel==" + channelId, "dimensions": "day", "sort": "-day", "metrics": "views,likes,dislikes,shares" }); // Create a new Spreadsheet with rows and columns corresponding to our dates var ssName = 'YouTube channel report ' + oneMonthAgoFormatted + ' - ' + todayFormatted; var numRows = analyticsResponse.rows.length; var numCols = analyticsResponse.columnHeaders.length; // Add an extra row for column headers var ssNew = SpreadsheetApp.create(ssName, numRows + 1, numCols); // Get the first sheet var sheet = ssNew.getSheets()[0]; // Get the range for the title columns // Remember, spreadsheets are 1-indexed, whereas arrays are 0-indexed var headersRange = sheet.getRange(1, 1, 1, numCols); var headers = []; // These column headers will correspond with the metrics requested // in the initial call: views, likes, dislikes, shares for(var i in analyticsResponse.columnHeaders) { var columnHeader = analyticsResponse.columnHeaders[i]; var columnName = columnHeader.name; headers[i] = columnName; } // This takes a 2 dimensional array headersRange.setValues([headers]); // Bold and freeze the column names headersRange.setFontWeight('bold'); sheet.setFrozenRows(1); // Get the data range and set the values var dataRange = sheet.getRange(2, 1, numRows, numCols); dataRange.setValues(analyticsResponse.rows); // Bold and freeze the dates var dateHeaders = sheet.getRange(1, 1, numRows, 1); dateHeaders.setFontWeight('bold'); sheet.setFrozenColumns(1); // Include the headers in our range. The headers are used // to label the axes var range = sheet.getRange(1, 1, numRows, numCols); var chart = sheet.newChart() .asColumnChart() .setStacked() .addRange(range) .setPosition(4, 2, 10, 10) .build(); sheet.insertChart(chart); } 如未另行说明，那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可，并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情，请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC)：2025-08-21。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["没有我需要的信息","missingTheInformationINeed","thumb-down"],["太复杂/步骤太多","tooComplicatedTooManySteps","thumb-down"],["内容需要更新","outOfDate","thumb-down"],["翻译问题","translationIssue","thumb-down"],["示例/代码问题","samplesCodeIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-21。"],[[["\u003cp\u003eThis guide explains how to enable the YouTube Data API and YouTube Analytics API to run code samples within Apps Script.\u003c/p\u003e\n"],["\u003cp\u003eThe provided Apps Script function exports YouTube Analytics data, such as views, likes, dislikes, and shares, for the authenticated user's channel over the last 30 days.\u003c/p\u003e\n"],["\u003cp\u003eThe exported data is automatically populated into a new Google Sheet in the user's Drive, formatted with a stacked column chart for visualization.\u003c/p\u003e\n"],["\u003cp\u003eThe Google Sheet is named with 'YouTube Report' and the specified date range for the data.\u003c/p\u003e\n"]]],["The provided code exports YouTube Analytics data to a Google Sheet. It first retrieves the user's channel ID and then uses the YouTube Analytics API to query views, likes, dislikes, and shares for the past 30 days. It generates a new Google Sheet named \"YouTube Report,\" populates it with the API response data, including column headers for the metrics, locks the headers, and then generates a stacked column chart. Finally, it inserts the chart in the report.\n"],null,["To run code samples, you need to enable the YouTube Data API and YouTube Analytics API (v2) in Apps Script. The [Data API quickstart](https://developers.google.com/youtube/v3/quickstart/apps-script) explains how to add a service.\n\nExport YouTube Analytics data to Google Sheets\n\nThis function uses the YouTube Analytics API to fetch data about the authenticated user's channel, creating a new Google Sheet in the user's Drive with the data. \n\nThe first part of this sample demonstrates a simple YouTube Analytics API call. This function first fetches the active user's channel ID. Using that ID, the function makes a YouTube Analytics API call to retrieve views, likes, dislikes and shares for the last 30 days. The API returns the data in a response object that contains a 2D array. \n\nThe second part of the sample constructs a Spreadsheet. This spreadsheet is placed in the authenticated user's Google Drive with the name 'YouTube Report' and date range in the title. The function populates the spreadsheet with the API response, then locks columns and rows that will define a chart axes. A stacked column chart is added for the spreadsheet. \n\n```transact-sql\n function spreadsheetAnalytics() {\n // Get the channel ID\n var myChannels = YouTube.Channels.list('id', {mine: true});\n var channel = myChannels.items[0];\n var channelId = channel.id;\n \n // Set the dates for our report\n var today = new Date();\n var oneMonthAgo = new Date();\n oneMonthAgo.setMonth(today.getMonth() - 1);\n var todayFormatted = Utilities.formatDate(today, 'UTC', 'yyyy-MM-dd')\n var oneMonthAgoFormatted = Utilities.formatDate(oneMonthAgo, 'UTC', 'yyyy-MM-dd');\n \n // The YouTubeAnalytics.Reports.query() function has four required parameters and one optional\n // parameter. The first parameter identifies the channel or content owner for which you are\n // retrieving data. The second and third parameters specify the start and end dates for the\n // report, respectively. The fourth parameter identifies the metrics that you are retrieving.\n // The fifth parameter is an object that contains any additional optional parameters\n // (dimensions, filters, sort, etc.) that you want to set.\n var analyticsResponse = YouTubeAnalytics.Reports.query({\n \"startDate\": oneMonthAgoFormatted,\n \"endDate\": todayFormatted,\n \"ids\": \"channel==\" + channelId,\n \"dimensions\": \"day\",\n \"sort\": \"-day\",\n \"metrics\": \"views,likes,dislikes,shares\"\n });\n \n // Create a new Spreadsheet with rows and columns corresponding to our dates\n var ssName = 'YouTube channel report ' + oneMonthAgoFormatted + ' - ' + todayFormatted;\n var numRows = analyticsResponse.rows.length;\n var numCols = analyticsResponse.columnHeaders.length;\n \n // Add an extra row for column headers\n var ssNew = SpreadsheetApp.create(ssName, numRows + 1, numCols);\n \n // Get the first sheet\n var sheet = ssNew.getSheets()[0];\n \n // Get the range for the title columns\n // Remember, spreadsheets are 1-indexed, whereas arrays are 0-indexed\n var headersRange = sheet.getRange(1, 1, 1, numCols);\n var headers = [];\n \n // These column headers will correspond with the metrics requested\n // in the initial call: views, likes, dislikes, shares\n for(var i in analyticsResponse.columnHeaders) {\n var columnHeader = analyticsResponse.columnHeaders[i];\n var columnName = columnHeader.name;\n headers[i] = columnName;\n }\n // This takes a 2 dimensional array\n headersRange.setValues([headers]);\n \n // Bold and freeze the column names\n headersRange.setFontWeight('bold');\n sheet.setFrozenRows(1);\n \n // Get the data range and set the values\n var dataRange = sheet.getRange(2, 1, numRows, numCols);\n dataRange.setValues(analyticsResponse.rows);\n \n // Bold and freeze the dates\n var dateHeaders = sheet.getRange(1, 1, numRows, 1);\n dateHeaders.setFontWeight('bold');\n sheet.setFrozenColumns(1);\n \n // Include the headers in our range. The headers are used\n // to label the axes\n var range = sheet.getRange(1, 1, numRows, numCols);\n var chart = sheet.newChart()\n .asColumnChart()\n .setStacked()\n .addRange(range)\n .setPosition(4, 2, 10, 10)\n .build();\n sheet.insertChart(chart);\n \n }\n```"]]
