Sheets API v4
Read, write, and format data in Sheets. Programmatically create and update pivot tables, data validation, charts and more.
Getting started with the API
Our quickstarts are there to help you get something running right away. Once you've seen the basics, our codelab gives you a detailed look at the process of building a Sheets API application.
API Guides and Reference Docs
These guides explain how you can implement some of the most important use cases. The reference documentation contains detailed information about the API types and methods.
Access the API with Apps Script
In addition to using Apps Script's built-in Spreadsheet service, you can also use the Sheets API directly by using the Sheets advanced service.