Interact with AppSheet to manage app data and tables

Google AppSheet guMCP Server

Retrieve rows from an AppSheet table with optional filtering and sorting

Key values to find specific row(s). Example: {'ID': '123'}

Filter/sort expression. Examples: 'Filter(Table, [Age] >= 21)', 'Top(Filter(Table, true), 10)'

get_rows

Array of row objects with all field values including virtual and computed fields.

Rows to add. Example: [{'Name': 'Jan', 'Age': 33}]

Array of added row objects with generated field values.

Update existing rows in an AppSheet table

Rows to update with key column. Example: [{'ID': '123', 'Age': 34}]

Array of updated row objects with all field values.

Rows with key column to delete. Example: [{'ID': '123'}]