Skip to main content
AppSheet is Google’s no-code application platform that lets you build apps from spreadsheets and databases. The AppSheet MCP server lets you read, add, update, and delete rows using natural language.

​
What Can It Do?

  • Retrieve rows from any table with filters and conditions
  • Add new rows to keep your app data current
  • Update existing rows to reflect changes from other systems
  • Delete rows to clean up outdated records

​
Where to Use It

Add AppSheet as a tool to any agent. The agent can then interact with your app’s tables conversationally, choosing the right actions based on context. To add an MCP tool to your agent:
  1. Open your agent’s configuration
  2. Click Add tools → Connect an app with MCP
  3. Search for the integration and select it
  4. Authenticate with your account
You can control which tools your agent has access to. After adding an integration, click on it to enable or disable specific tools based on what your agent needs.

​
In Workflows (Via Agent Node)

For automated pipelines, use an Agent Node with AppSheet tools. This gives you the flexibility of an agent within a deterministic workflow.

​
As a Custom MCP Node

You can also create a standalone MCP node for a specific action. This generates a reusable node that performs one task, useful when you need the same operation repeatedly in workflows.
To create a custom MCP node:
  1. Go to your node library and search for the integration
  2. Click Create a node with AI
  3. Describe the specific action you want (e.g., “Get all rows from Inventory where In Stock is true”)
  4. Test the node and save it for reuse
Custom MCP nodes are single-purpose by design. For tasks that require multiple steps or dynamic decision-making, use an agent instead.

​
Setting Up AppSheet Credentials

Before using AppSheet, you need to enable API access in your app:
1

Open Your AppSheet App

In the AppSheet editor, go to Settings → Integrations.
2

Enable Cloud Services Access

Under IN: from cloud services to your app, toggle Enable to allow external services to communicate with your app.
3

Copy Your App ID

Your App Id is displayed in the Integrations panel. Copy this value.
4

Create an Access Key

Click Create Application Access Key to generate a new key. Copy the access key value.
5

Add Credentials in Gumloop

Go to Connectors page, add AppSheet, and enter your App ID and Access Key.
Application Access Keys provide full access to your AppSheet app’s data. Keep them secure and never share publicly.

​
Available Tools

​
Example Prompts

Use these with your agent or in the Agent Node: Retrieve records:
Add new data:
Update records:
Clean up data:

​
Troubleshooting

Agents are smart enough to chain multiple API calls together. For example, asking “Update all overdue tasks to high priority” will get the tasks first, then update them. If results seem off, check the agent’s step-by-step reasoning.

​
Need Help?

Use this integration directly in Claude or Cursor. Connect remotely via the AppSheet MCP server using credentials from your Connectors page.