Google AppSheet

App · 5 actions

Find, add, edit and delete AppSheet table rows, and run an app action.

Actions

ActionWhat it does
Add rowsAdd rows in your connected AppSheet app.
Delete rowsDelete rows in your connected AppSheet app.
Edit rowsEdit rows in your connected AppSheet app.
Find rowsFind rows in your connected AppSheet app.
Run table actionRun table action in your connected AppSheet app.

Add rows

Add rows in your connected AppSheet app.

Inputs

Table nametable_nametextRequired
The table name shown in Data > Tables in your app.
RowsrowslistRequired
Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
Selectorselectortext
An AppSheet FILTER or SELECT expression to choose rows.
Localelocaletext
Locale for interpreting dates and numbers, such as en-US.
Time zonetime_zonetext
Timezone used to interpret date and time values, such as America/Los_Angeles.
Run as user emailrun_as_user_emailtext
Email of the user to run this request as, when your app permits it.

Outputs

datalist
Google App Sheet response data.
Example output
{
  "data": []
}

Delete rows

Delete rows in your connected AppSheet app.

Inputs

Table nametable_nametextRequired
The table name shown in Data > Tables in your app.
RowsrowslistRequired
Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
Selectorselectortext
An AppSheet FILTER or SELECT expression to choose rows.
Localelocaletext
Locale for interpreting dates and numbers, such as en-US.
Time zonetime_zonetext
Timezone used to interpret date and time values, such as America/Los_Angeles.
Run as user emailrun_as_user_emailtext
Email of the user to run this request as, when your app permits it.

Outputs

datalist
Google App Sheet response data.
Example output
{
  "data": []
}

Edit rows

Edit rows in your connected AppSheet app.

Inputs

Table nametable_nametextRequired
The table name shown in Data > Tables in your app.
RowsrowslistRequired
Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
Selectorselectortext
An AppSheet FILTER or SELECT expression to choose rows.
Localelocaletext
Locale for interpreting dates and numbers, such as en-US.
Time zonetime_zonetext
Timezone used to interpret date and time values, such as America/Los_Angeles.
Run as user emailrun_as_user_emailtext
Email of the user to run this request as, when your app permits it.

Outputs

datalist
Google App Sheet response data.
Example output
{
  "data": []
}

Find rows

Find rows in your connected AppSheet app.

Inputs

Table nametable_nametextRequired
The table name shown in Data > Tables in your app.
Rowsrowslist
Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
Selectorselectortext
An AppSheet FILTER or SELECT expression to choose rows.
Localelocaletext
Locale for interpreting dates and numbers, such as en-US.
Time zonetime_zonetext
Timezone used to interpret date and time values, such as America/Los_Angeles.
Run as user emailrun_as_user_emailtext
Email of the user to run this request as, when your app permits it.

Outputs

datalist
Google App Sheet response data.
Example output
{
  "data": []
}

Run table action

Run table action in your connected AppSheet app.

Inputs

Table nametable_nametextRequired
The table name shown in Data > Tables in your app.
Action nameaction_nametextRequired
The name of an existing action in your AppSheet app.
RowsrowslistRequired
Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
Selectorselectortext
An AppSheet FILTER or SELECT expression to choose rows.
Localelocaletext
Locale for interpreting dates and numbers, such as en-US.
Time zonetime_zonetext
Timezone used to interpret date and time values, such as America/Los_Angeles.
Run as user emailrun_as_user_emailtext
Email of the user to run this request as, when your app permits it.

Outputs

datalist
Google App Sheet response data.
Example output
{
  "data": []
}

On this page