> ## Documentation Index
> Fetch the complete documentation index at: https://docs.r28.ai/charter/llms.txt
> Use this file to discover all available pages before exploring further.

# spreadsheets_values_append

> Appends values to a spreadsheet.

<div className="tool-route"><span className="tool-row-method" data-method="POST">POST</span><code>{"https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append"}</code></div>

```python gsheets_spreadsheets_values_append.py theme={null}
from charter.packs import gsheets

result = await gsheets.spreadsheets_values_append.ainvoke({"spreadsheetId": ..., "range": ..., "valueInputOption": ..., "valueRange": ...})
```

<Note>
  Requires `https://www.googleapis.com/auth/spreadsheets`. Costs 1 against the provider's own quota.
</Note>

## Path parameters

<div className="reference-table">
  | Field                                                                 | Type     | Description                                                                                                            |
  | --------------------------------------------------------------------- | -------- | ---------------------------------------------------------------------------------------------------------------------- |
  | `spreadsheetId` <span className="required" title="required">\*</span> | `string` | The ID of the spreadsheet to update.                                                                                   |
  | `range` <span className="required" title="required">\*</span>         | `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. |
</div>

## Query parameters

<div className="reference-table">
  | Field                                                                    | Type                                                                               | Description                                                                                                                                                                                            |
  | ------------------------------------------------------------------------ | ---------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
  | `valueInputOption` <span className="required" title="required">\*</span> | [ValueInputOption](/charter/charter/packs/gsheets/values/objects#valueinputoption)         | How the input data should be interpreted.                                                                                                                                                              |
  | `insertDataOption`                                                       | [InsertDataOption](/charter/charter/packs/gsheets/values/objects#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](/charter/charter/packs/gsheets/values/objects#valuerenderoption)       | Determines how values in the response should be rendered. The default render option is FORMATTED\_VALUE.                                                                                               |
  | `responseDateTimeRenderOption`                                           | [DateTimeRenderOption](/charter/charter/packs/gsheets/values/objects#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. |
</div>

## Body

<div className="reference-table">
  | Field                                                              | Type                                                           | Description                                          |
  | ------------------------------------------------------------------ | -------------------------------------------------------------- | ---------------------------------------------------- |
  | `valueRange` <span className="required" title="required">\*</span> | [ValueRange](/charter/charter/packs/gsheets/values/objects#valuerange) | The request body contains an instance of ValueRange. |
</div>