write_range
Overwrite a specific range of cells in a Google Sheet with new rows, replacing existing values; choose USER_ENTERED to parse formulas or dates, or RAW for literal storage.
Instructions
Overwrite a range of cells with the given rows. Existing values are replaced.
Args: spreadsheet_id: The long token from the spreadsheet URL. a1_range: Top-left anchored range, e.g. "Sheet1!A2:C10". values: Rows of cell values, outer list is rows, inner list is columns. value_input_option: USER_ENTERED parses formulas and dates; RAW stores literally.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| values | Yes | ||
| a1_range | Yes | ||
| spreadsheet_id | Yes | ||
| value_input_option | No | USER_ENTERED |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||