Sheets

List, create, and edit Google Sheets from a workflow using a Google connection.

Sheets blocks sit in the builder palette under google/sheets. They appear only when a Google connection has Google Sheets enabled. Shared graph rules are on Workflows.

Listing spreadsheets uses Drive metadata on that connection. File-change events also need Google Drive.

Google has no stable row primary key. Store a spreadsheet id, then use ranges.

Use	Block
Search or page spreadsheets	List Spreadsheets
New spreadsheet	Create Spreadsheet
Tabs and title	Get Spreadsheet
Read cells	Get Values
Overwrite cells	Update Values
Add rows	Append Values
Empty a range	Clear Values
New tab	Add Sheet
Remove a tab	Delete Sheet

Store a spreadsheet id on a Spreadsheet column. Use Spreadsheet Changed when edits should start a flow (needs Drive on the same connection).

List Spreadsheets

List Google Sheets files with optional search and paging.

Create Spreadsheet

Create a spreadsheet with optional tab titles.

Get Spreadsheet

Load spreadsheet metadata and tabs by id.

Get Values

Read cell values from an A1 range.

Update Values

Overwrite cell values in an A1 range.

Append Values

Append rows after an A1 range.

Clear Values

Clear cell values in an A1 range.

Add Sheet

Add a tab to a spreadsheet.

Delete Sheet

Delete a tab by numeric sheet id.