Google Sheets

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