Google Sheets API Integration Profile
Information and guides about integrating with Google Sheets API
Add Google Sheets Integration to Your AppSheets Spreadsheets Get in Google Sheets API
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: * Specify a field mask listing your desired fields using the fields URL parameter in HTTP * Set the includeGridData URL parameter to true. If a field mask is set, the includeGridData parameter is ignored For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want. To retrieve only subsets of spreadsheet data, use the ranges URL parameter. Ranges are specified using A1 notation. You can define a single cell (for example, A1) or multiple cells (for example, A1:D5). You can also get cells from other sheets within the same spreadsheet (for example, Sheet2!A1:C4) or retrieve multiple ranges at once (for example, ?ranges=A1:D5&ranges=Sheet2!A1:C4). Limiting the range returns only the portions of the spreadsheet that intersect the requested ranges.
Input schema fields
| Field Name | API Key | Type | |
|---|---|---|---|
| Path Parameters | pathParameters | object | |
| Spreadsheet Id | pathParameters.spreadsheetId | string | |
| Query | query | object | |
| Access Token | query.access_token | string | |
| Alt | query.alt | string |
Output schema fields
| Field Name | API Key | Type | Description |
|---|---|---|---|
| Spreadsheet Id | spreadsheetId | string | The ID of the spreadsheet. This field is read-only. |
| Properties | properties | object | Properties of a spreadsheet. |
| Title | properties.title | string | The title of the spreadsheet. |
| Locale | properties.locale | string | The locale of the spreadsheet in one of the following formats: * an ISO 639-1 language code such as `en` * an ISO 639-2 language code such as `fil`, if no 639-1 code exists * a combination of the ISO language code and country code, such as `en_US` Note: when updating this field, not all locales/languages are supported. |
| Auto Recalc | properties.autoRecalc | string | The amount of time to wait before volatile functions are recalculated. |
