gsheets.appendvaluesprops
Home > @runlightyear/gsheets > AppendValuesProps
AppendValuesProps interface
Signature:interface AppendValuesProps
Required Properties
| Property | Modifiers | Type | Description |
|---|---|---|---|
| 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. | |
| spreadsheetId | string | The ID of the spreadsheet to update. | |
| valueInputOption | ValueInputOption | How the input data should be interpreted. | |
| valueRange | ValueRange | The values to append. |
Optional Properties
| Property | Modifiers | Type | Description |
|---|---|---|---|
| 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. | |
| insertDataOption? | InsertDataOption | How the input data should be inserted. | |
| 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. | |
| responseValueRenderOption? | ValueRenderOption | Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. |