Google AppSheet

Use Google AppSheet to find, add, edit, and delete table rows. Use Selector expressions to filter results, and identify existing rows by their key column.

Get your Application Access Key

Google AppSheet authenticates with a static Application Access Key rather than OAuth:

1. Open your app in the AppSheet editor
2. Go to Settings > Integrations
3. Enable IN: from cloud services to your app
4. Under Application Access Keys, create an unexpired key (or use an existing one), copy it, and save the app
5. Use the Application Access Key, along with your App ID and table name, in the Sim block configuration

The AppSheet API requires an Enterprise plan. An organization policy can prevent app creators from enabling external API access.

Use the block

Find, add, edit, and delete rows in an AppSheet table using the AppSheet API. Requires an AppSheet Enterprise plan with the API enabled and an Application Access Key.

Actions

AppSheet Find Rows

Read rows from an AppSheet table. Omit the selector to return every row, or provide a Selector expression (Filter/Select/OrderBy/Top) to narrow and shape the results.

Input

Output

AppSheet Add Rows

Add new rows to an AppSheet table. The key column value must be provided explicitly, or omitted when its Initial value expression generates it automatically (e.g. UNIQUEID()).

Input

Output

AppSheet Edit Rows

Update existing rows in an AppSheet table. Each row must explicitly include the key column name and value, plus any columns to change.

Input

Output

AppSheet Delete Rows

Delete rows from an AppSheet table. Each row only needs to include the key column name and value.

Input

Output