Google Sheets

Development

Visit website

API to read, write, and format Google Sheets data.

About Google Sheets

The Google Sheets API is a REST service, accessible at sheets.googleapis.com, that reads and writes Google Sheets spreadsheets. It exposes resources for spreadsheets, developer metadata, individual sheets, and cell values, with operations to create, retrieve, and batch-update spreadsheet content, copy sheets between spreadsheets, and get, update, append, clear, and batch-clear or batch-get ranges of values.

The API supports both direct range-based operations and data-filter-based variants for retrieving, updating, and clearing values, along with a discovery document for building client libraries and tools. Google provides client libraries for Browser, Go, Java, .NET, Node.js, PHP, Python, and Ruby.

This is intended for developers building applications, add-ons, or integrations that programmatically create or manipulate Google Sheets spreadsheet data.

Key features

Read and write spreadsheet data via REST API
Batch update multiple ranges of values in a spreadsheet
Create new spreadsheets programmatically
Append, clear, and retrieve values from specified ranges
Copy a sheet from one spreadsheet to another
Search and manage developer metadata on spreadsheets

Frequently asked questions

What platforms and languages are supported?

Google provides client libraries for Browser, Go, Java, .NET, Node.js, PHP, Python, and Ruby, and the API can also be called directly over REST.

What is the base endpoint for the API?

The service endpoint is https://sheets.googleapis.com, with all REST URIs relative to it.

Is there a machine-readable spec for building custom clients?

Yes, a Discovery Document is provided at https://sheets.googleapis.com/$discovery/rest?version=v4 for building client libraries and tools.

What operations does the API support?

It supports creating and retrieving spreadsheets, batch updating spreadsheet structure, reading and writing cell values (get, update, append, clear, batchGet, batchUpdate), copying sheets, and searching developer metadata.