Google Sheets API Skill
google-sheets
Endpoints
| Method | Path | Description |
|---|---|---|
POST | /v4/spreadsheets | |
GET | /v4/spreadsheets/{spreadsheetId} | Creates a spreadsheet, returning the newly created spreadsheet. |
GET | /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId} | Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * S... |
POST | /v4/spreadsheets/{spreadsheetId}/developerMetadata:search | Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata's unique metadataId. |
POST | /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo | Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup object, this will return all DeveloperMetadata en... |
GET | /v4/spreadsheets/{spreadsheetId}/values/{range} | Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet. |
PUT | /v4/spreadsheets/{spreadsheetId}/values/{range} | Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range. |
POST | /v4/spreadsheets/{spreadsheetId}/values/{range}:append | Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption. |
POST | /v4/spreadsheets/{spreadsheetId}/values/{range}:clear | Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, st... |
POST | /v4/spreadsheets/{spreadsheetId}/values:batchClear | Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data valid... |
POST | /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter | Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the c... |
GET | /v4/spreadsheets/{spreadsheetId}/values:batchGet | Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters w... |
POST | /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter | Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. |
POST | /v4/spreadsheets/{spreadsheetId}/values:batchUpdate | Returns one or more ranges of values that match the specified data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges that match any of the da... |
POST | /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter | Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more ValueRanges. |
POST | /v4/spreadsheets/{spreadsheetId}:batchUpdate | Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more DataFilterValueRanges. |
POST | /v4/spreadsheets/{spreadsheetId}:getByDataFilter | Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be a... |
Install as Skill
Use this API as a Claude Code skill for instant agent access.
CLI Install
lapsh skill-install google-sheets
Downloads and installs to ~/.claude/skills/google-sheets/
Recent Versions (1)
v4(2026-03-02)