> ## Documentation Index
> Fetch the complete documentation index at: https://learn.workflow.dog/llms.txt
> Use this file to discover all available pages before exploring further.

# Write Range

> Write user-entered values into a Google Sheets range.

The **Write Range** action replaces values in a specified A1 range. Values are
interpreted as if a person entered them in Google Sheets, so formulas and
recognized dates can be parsed by Sheets.

## Inputs

| Input                     | Type                | Required | Description                                             |
| ------------------------- | ------------------- | -------- | ------------------------------------------------------- |
| **Third-party account**   | Google account      | Yes      | Account with write access.                              |
| **Spreadsheet ID or URL** | String              | Yes      | Spreadsheet to update.                                  |
| **Range**                 | String              | Yes      | A1 destination range.                                   |
| **Major Dimension**       | `Rows` or `Columns` | No       | How the outer Values list is interpreted. Default Rows. |
| **Rows** or **Columns**   | List of lists       | Yes      | Cell values arranged by the selected dimension.         |

## Outputs

| Output            | Type   | Description                          |
| ----------------- | ------ | ------------------------------------ |
| **Updated Range** | String | A1 range actually updated by Google. |

<Warning>
  This action writes over cells in the destination. Use **Append Values to
  Range** or **Insert Table Rows** when existing data should move rather than be
  replaced.
</Warning>

## Example

With **Major Dimension** set to **Rows**, this value:

```json theme={null}
[
  ["Name", "Status"],
  ["Avery", "Active"]
]
```

writes two rows and two columns starting at the first cell of **Range**.