Stay organized with collections
Save and categorize content based on your preferences.
The following videos explain concepts that help you to use the Google Sheets API
for your applications. Each video generally walks through a concept or short
sample app to give you a jump start in trying specific API features or learn
more about how to access Sheets features programmatically from the REST API or
the Google Apps Script Spreadsheet service.
Migrating SQL data to Google Sheets
In this introductory video to the Google Sheets API, learn how to migrate SQL
data to a Google Sheet. After the video, move on to the Sheets API
codelab where you can build a customized reporting
tool for a fictitious toy company. The database used in that app is the same
database used in the video.
One of the features you get with the API is the ability to format content in
Sheets. The sample app for this video demonstrates how to set frozen
rows, bold cells, format floating-point values as currency, and implement cell
data validation.
For developers already familiar with the Sheets API, this video shows how to use
the API along with the Google Slides API to link charts and import data from
spreadsheets into slide presentations, making your Sheets data even more
presentable.
No, accessing Google Maps from a spreadsheet isn't a parlor trick. This video
describes various scenarios where this is useful and, more importantly, shows
how to create maps from addresses stored in a Google Sheet using the Google Apps Script Maps service.
(Running time: 10:47)
(A day at the office) Automating YouTube stats with Google Apps Script
Have you ever been asked by your boss to do something simple but long and
tedious, such as tallying up the view counts for your corporate videos and
perhaps your competitors'? This is a laborious task that's easily handled from a
Google Sheet with the help of Apps Script and its YouTube Data advanced
service.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-19 UTC."],[[["These videos introduce the Google Sheets API and how to use it with applications by demonstrating concepts and sample apps."],["Learn how to migrate SQL data, format cells, generate slides from spreadsheet data, and access Google Maps, all using the Google Sheets API and Google Apps Script."],["The videos explore features like formatting cells, importing data into slides, and using Google Apps Script to automate tasks, enhancing spreadsheet functionalities."],["Each video provides a practical example and offers links to relevant resources such as codelabs and blog posts for further exploration."],["This content is aimed at developers who want to leverage the Google Sheets API and Google Apps Script to enhance their workflows and applications."]]],["The videos demonstrate how to utilize the Google Sheets API for various applications. Key actions include migrating SQL data to Google Sheets and building a reporting tool. Other capabilities include formatting cell content, setting frozen rows, and implementing data validation. Developers can learn to link charts and import data into Google Slides presentations. The API also allows for creating maps from addresses within Sheets, and automating tasks like tallying YouTube statistics using Apps Script.\n"]]
