Google AppSheet

Google AppSheet builds no-code apps on top of spreadsheets and databases, and its API reads and writes the rows of one app's tables through the app itself — so the app's formulas, security filters and Bots apply.

Authentication

• Application Access Key

Actions

Generic API request. Call any AppSheet API endpoint on this connection, for the case where no shipped action covers it yet. The connection supplies the base URL, the authentication and the egress route, so only the path, query and body are yours to fill.

• Add rows (v1)Add one or more new rows to a table of the connected AppSheet app, the way a form submission in the app would — initial values, app formulas and Bots triggered by adds all run.
• Delete rows (v1)DestructiveDelete rows from a table of the connected AppSheet app.
• Edit rows (v1)DestructiveUpdate existing rows in a table of the connected AppSheet app.
• Find rows (v1)Read rows from one table of the connected AppSheet app — every row, the rows an AppSheet expression selects (Selector, e.g. Filter(People, [Status] = "Open")), or specific rows by key (Rows).
• Invoke app action (v1)DestructiveRun one of the app's own actions — a data-change action or a grouped action defined on the table in the AppSheet editor — on specific rows, so the app's business logic (set values, cascade to other tables, trigger Bots) applies exactly as when a user taps the action.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.