Google AppSheet - NoClick

The Google AppSheet node adds Google AppSheet operations to your workflows. Add it on the canvas or ask the AI builder for it by name, then pick an operation and fill in its fields. Google AppSheet also includes 5 trigger operations (marked in the tables below) that can start a workflow when something happens in Google AppSheet.

You can wire the Google AppSheet node into an AI agent as a tool provider: the agent calls the operations you allow. See Agent tools.

Credentials

Connect Google AppSheet under Credentials in the node settings. See Connecting credentials for the general flow. Enter the values manually when creating the credential. Get your credentials here.

Operations

Actions

Operation	ID	Description	Trigger
Invoke Custom Action	`invoke_action`	Run a data-change action predefined in the app against the supplied rows.

Find

Operation	ID	Description	Trigger
Find All Rows	`find_all_rows`	Return every row in the table (empty Rows, no Selector).
Find Rows by Key	`find_rows`	Read specific rows by key; provide key values in Rows.
Find with Selector	`find_with_selector`	Read rows matching an AppSheet Selector expression (FILTER/SELECT/ORDERBY/TOP).

Rows

Operation	ID	Description	Trigger
Add Rows	`add_rows`	Insert one or more new rows into a table.
Delete Rows	`delete_rows`	Delete existing rows; each row must include the key column value(s).
Edit Rows	`edit_rows`	Update existing rows; each row must include the key column(s) plus changed columns.

Other

Operation	ID	Description	Trigger
On Any Data Change	`on_data_change`	Fires on any data change (AppSheet bot event: ‘Adds and updates’ / ‘All changes’).	Yes
On Rows Added	`on_rows_added`	Fires when rows are added (AppSheet bot event: ‘Adds only’).	Yes
On Rows Deleted	`on_rows_deleted`	Fires when rows are deleted (AppSheet bot event: ‘Deletes only’).	Yes
On Rows Updated	`on_rows_updated`	Fires when rows are updated (AppSheet bot event: ‘Updates only’).	Yes
On Schedule	`on_schedule`	Fires on a schedule (AppSheet bot event: ‘Scheduled’).	Yes