Google AppSheet
App · 5 actions
Find, add, edit and delete AppSheet table rows, and run an app action.
Actions
| Action | What it does |
|---|---|
| Add rows | Add rows in your connected AppSheet app. |
| Delete rows | Delete rows in your connected AppSheet app. |
| Edit rows | Edit rows in your connected AppSheet app. |
| Find rows | Find rows in your connected AppSheet app. |
| Run table action | Run table action in your connected AppSheet app. |
Add rows
Add rows in your connected AppSheet app.
Inputs
- Table name
table_nametextRequired - The table name shown in Data > Tables in your app.
- Rows
rowslistRequired - Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector
selectortext - An AppSheet FILTER or SELECT expression to choose rows.
- Locale
localetext - Locale for interpreting dates and numbers, such as en-US.
- Time zone
time_zonetext - Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email
run_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 name
table_nametextRequired - The table name shown in Data > Tables in your app.
- Rows
rowslistRequired - Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector
selectortext - An AppSheet FILTER or SELECT expression to choose rows.
- Locale
localetext - Locale for interpreting dates and numbers, such as en-US.
- Time zone
time_zonetext - Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email
run_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 name
table_nametextRequired - The table name shown in Data > Tables in your app.
- Rows
rowslistRequired - Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector
selectortext - An AppSheet FILTER or SELECT expression to choose rows.
- Locale
localetext - Locale for interpreting dates and numbers, such as en-US.
- Time zone
time_zonetext - Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email
run_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 name
table_nametextRequired - The table name shown in Data > Tables in your app.
- Rows
rowslist - Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector
selectortext - An AppSheet FILTER or SELECT expression to choose rows.
- Locale
localetext - Locale for interpreting dates and numbers, such as en-US.
- Time zone
time_zonetext - Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email
run_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 name
table_nametextRequired - The table name shown in Data > Tables in your app.
- Action name
action_nametextRequired - The name of an existing action in your AppSheet app.
- Rows
rowslistRequired - Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector
selectortext - An AppSheet FILTER or SELECT expression to choose rows.
- Locale
localetext - Locale for interpreting dates and numbers, such as en-US.
- Time zone
time_zonetext - Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email
run_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": []
}