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](https://developers.google.com/apps-script/guides/sheets).

## Migrating SQL data to Google Sheets

[Video](https://www.youtube.com/watch?v=VLdrgE8iJZI)

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](http://g.co/codelabs/sheets) 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"](http://cloud.google.com/blog/products/application-development/introducing-google-sheets-api-v4).

## Formatting cells with the Google Sheets API

[Video](https://www.youtube.com/watch?v=86q5TMzvRqo)

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"](https://workspace.google.com/blog/developers-practitioners/formatting-cells-with-the-google-sheets-api).

## Generating slides from spreadsheet data

[Video](https://www.youtube.com/watch?v=h2_oiGv3ZdQ)

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"](https://developers.googleblog.com/en/generating-slides-from-spreadsheet-data/).

## Accessing Google Maps from a spreadsheet?!?

[Video](https://www.youtube.com/watch?v=hkpj-xzXhaw)

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](https://developers.google.com/apps-script/reference/maps).

(Running time: 10:47)

## (A day at the office) Automating YouTube stats with Google Apps Script

[Video](https://www.youtube.com/watch?v=cKIVdzCf8ic)

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](https://developers.google.com/apps-script/advanced/youtube).

(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"](https://developers.googleblog.com/en/a-day-at-the-office-automating-youtube-stats-with-google-apps-script/).