Google 表格开发者视频库
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
以下视频介绍了有助于您为应用使用 Google Sheets API 的概念。每段视频通常会介绍一个概念或简短的示例应用,让您快速开始尝试特定的 API 功能,或详细了解如何通过 REST API 或 Google Apps 脚本电子表格服务以编程方式访问 Google 表格功能。
将 SQL 数据迁移到 Google 表格
在这段 Google Sheets API 简介视频中,您将了解如何将 SQL 数据迁移到 Google 表格。观看完视频后,请继续学习 Sheets API Codelab,您可以在其中为一家虚构的玩具公司构建自定义报告工具。该应用中使用的数据库与视频中使用的数据库相同。
(时长:7:29)
您还可以参阅博文“Google Sheets API v4 简介:将数据从 SQL 数据库转移到工作表”,了解此功能。
通过该 API,您可以获得的一项功能是在 Google 表格中设置内容格式。此视频的示例应用演示了如何设置冻结行、加粗单元格、将浮点值格式化为币种,以及实现单元格数据验证。
(时长:8:31)
您还可以参阅博文“使用 Google Sheets API 设置单元格格式”,了解此功能。
根据电子表格数据生成幻灯片
对于已熟悉 Sheets API 的开发者,此视频展示了如何将该 API 与 Google Slides API 搭配使用,以链接图表并将数据从电子表格导入到幻灯片演示文稿中,从而使您的 Google 表格数据更具演示性。
(时长:7:40)
您还可以参阅博文“根据电子表格数据生成幻灯片”,了解此功能。
从电子表格访问 Google 地图?
不,从电子表格访问 Google 地图并不是一种魔术。此视频介绍了在哪些情况下此功能非常有用,更重要的是,它还展示了如何使用 Google Apps 脚本 Maps 服务根据存储在 Google 表格中的地址创建地图。
(时长:10:47)
(办公室的一天)使用 Google Apps 脚本自动获取 YouTube 统计数据
您的老板是否曾要求您做一些简单但耗时且乏味的工作,例如统计公司视频甚至竞争对手视频的观看次数?这是一项繁琐的任务,但借助 Apps 脚本及其 YouTube Data 高级服务,可以轻松地在 Google 表格中完成。
(时长:7:31)
这篇博文《(办公室的一天)使用 Google Apps 脚本自动生成 YouTube 统计信息》中也介绍了此功能。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-08-29。
[null,null,["最后更新时间 (UTC):2025-08-29。"],[],[],null,["# Google Sheets developer video library\n\nThe following videos explain concepts that help you to use the Google Sheets API\nfor your applications. Each video generally walks through a concept or short\nsample app to give you a jump start in trying specific API features or learn\nmore about how to access Sheets features programmatically from\nthe REST API or the\n[Google Apps Script Spreadsheet service](/apps-script/guides/sheets).\n\nMigrating SQL data to Google Sheets\n-----------------------------------\n\nIn this introductory video to the Google Sheets API, learn how to migrate SQL\ndata to a Google Sheet. After the video, move on to the [Sheets API\ncodelab](http://g.co/codelabs/sheets) where you can build a customized reporting\ntool for a fictitious toy company. The database used in that app is the same\ndatabase used in the video.\n\n(Running time: 7:29)\n\nThis feature is also described in the blog post [\"Introducing the Google Sheets API\nv4: Transferring data from a SQL database to a Sheet\"](http://cloud.google.com/blog/products/application-development/introducing-google-sheets-api-v4).\n\nFormatting cells with the Google Sheets API\n-------------------------------------------\n\nOne of the features you get with the API is the ability to format content in\nSheets. The sample app for this video demonstrates how to set\nfrozen rows, bold cells, format floating-point values as currency, and implement\ncell data validation.\n\n(Running time: 8:31)\n\nThis feature is also described in the blog post\n[\"Formatting cells with the Google Sheets API\"](https://workspace.google.com/blog/developers-practitioners/formatting-cells-with-the-google-sheets-api).\n\nGenerating slides from spreadsheet data\n---------------------------------------\n\nFor developers already familiar with the Sheets API, this video shows\nhow to use the API along with the Google Slides API to link charts and import data\nfrom spreadsheets into slide presentations, making your Sheets\ndata even more presentable.\n\n(Running time: 7:40)\n\nThis feature is also described in the blog post\n[\"Generating slides from spreadsheet data\"](https://developers.googleblog.com/en/generating-slides-from-spreadsheet-data/).\n\nAccessing Google Maps from a spreadsheet?!?\n-------------------------------------------\n\nNo, accessing Google Maps from a spreadsheet isn't a parlor trick. This video\ndescribes various scenarios where this is useful and, more importantly, shows\nhow to create maps from addresses stored in a Google Sheet using the\nGoogle Apps Script [Maps service](/apps-script/reference/maps).\n\n(Running time: 10:47)\n\n(A day at the office) Automating YouTube stats with Google Apps Script\n----------------------------------------------------------------------\n\nHave you ever been asked by your boss to do something simple but long and\ntedious, such as tallying up the view counts for your corporate videos and\nperhaps your competitors'? This is a laborious task that's easily handled from a\nGoogle Sheet with the help of Apps Script and its\n[YouTube Data advanced service](/apps-script/advanced/youtube).\n\n(Running time: 7:31)\n\nThis feature is also described in the blog post [\"(A day at the office)\nAutomating YouTube stats with Google Apps Script\"](https://developers.googleblog.com/en/a-day-at-the-office-automating-youtube-stats-with-google-apps-script/)."]]