write_range
Write a 2D array of values to a specified A1 range in a Google Sheet, with options to store as raw strings or parse formulas, dates, and numbers.
Instructions
Write a 2D array of values to an A1 range.
value_input_option: RAW (store verbatim as strings; default) or
USER_ENTERED (parse like a user typing — formulas, dates, and numbers
are evaluated). Opt in to USER_ENTERED explicitly; it evaluates formulas
including those that can make external network requests.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| values | Yes | ||
| spreadsheet_id | Yes | ||
| value_input_option | No | RAW |