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.
(Running time: 7:29)
This feature is also described in the blog post “Introducing the Google Sheets API v4: Transferring data from a SQL database to a Sheet”.
Formatting cells with the Google Sheets API
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.
(Running time: 8:31)
This feature is also described in the blog post “Formatting cells with the Google Sheets API”.
Generating slides from spreadsheet data
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.
(Running time: 7:40)
This feature is also described in the blog post “Generating slides from spreadsheet data”.
Accessing Google Maps from a spreadsheet?!?
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.
(Running time: 7:31)
This feature is also described in the blog post “(A day at the office) Automating YouTube stats with Google Apps Script”.