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 Gumloop Credentials, 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

ToolDescription
Get RowsRetrieve rows from a table with optional filters
Add RowsAdd new rows to a table
Update RowsUpdate existing rows in a table
Delete RowsDelete rows from a table

​
Example Prompts

Use these with your agent or in the Agent Node: Retrieve records: 
Get all rows from the Inventory table where In Stock is true
Add new data: 
Add a new contact: Name "Sarah Smith", Email "[email protected]", Company "Acme Corp"
Update records: 
Update the project PRJ-123 to set Status to "In Progress"
Clean up data: 
Delete all rows from the Logs table older than June 2024

​
Troubleshooting

IssueSolution
Agent not finding the right dataInclude the app ID and exact table names in your request
Action not completingCheck that cloud services access is enabled and your access key is active
Unexpected resultsThe agent may chain multiple tools (e.g., getting rows first, then updating). Review the agent’s reasoning to understand its approach.
Tool not availableVerify the tool is enabled in your agent’s MCP configuration
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 your Gumloop credentials.