Write 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.

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.

Example

With Major Dimension set to Rows, this value:

[
  ["Name", "Status"],
  ["Avery", "Active"]
]

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

Check AvailabilityCheck whether a Google Calendar has any conflicts during a specific time.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

Example

​Inputs

​Outputs

​Example

Inputs

Outputs

Example