POST
gsheets_spreadsheets_values_append.py
from charter.packs import gsheets
result = await gsheets.spreadsheets_values_append.ainvoke({"spreadsheetId": ..., "range": ..., "valueInputOption": ..., "valueRange": ...})
Requires
https://www.googleapis.com/auth/spreadsheets. Costs 1 against the provider’s own quota.Path parameters
| Field | Type | Description |
|---|---|---|
spreadsheetId * | string | The ID of the spreadsheet to update. |
range * | string | The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table. |
Query parameters
| Field | Type | Description |
|---|---|---|
valueInputOption * | ValueInputOption | How the input data should be interpreted. |
insertDataOption | InsertDataOption | How the input data should be inserted. |
includeValuesInResponse | boolean | Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values. |
responseValueRenderOption | ValueRenderOption | Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. |
responseDateTimeRenderOption | DateTimeRenderOption | Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. |
Body
| Field | Type | Description |
|---|---|---|
valueRange * | ValueRange | The request body contains an instance of ValueRange. |