Comprehensive access to spreadsheets
Google Sheets API
- Read and write data
- Format text and numbers
- Build pivot tables
- Enforce cell validation
- Set frozen rows
- Adjust column sizes
- Apply formulas
- Create charts... and more!
Getting started
Developer documentation
Featured videos
Introducing the Sheets API v4 (SQL data migration)
Completed the Quickstart and ready for the next step? In this video, learn how to migrate SQL data to a Google Sheet. Once you've got this working, move on to our codelab where you can build a customized reporting tool for a fictitious toy company. Both applications use the same database. (7:29)
Formatting cells with the Google Sheets API
One of the features you get with the latest API is the ability to format content in Google 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. (8:31)
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. (7:40)