Google AppSheet Integration

Field	Description	Required	Format
App ID	Your AppSheet application ID (found in Settings > App Info or the app URL)	Yes	`xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx`
Application Access Key	Your AppSheet Application Access Key from Settings > Integrations	Yes	`V2-xxxxx-xxxxx-xxxxx-xxxxx-xxxxx`

add_row — Add a new row to a specific table in the AppSheet app

Parameters

string

required

Name of the table to add a row to

object

required

JSON object representing the row data to add, with keys matching table column names

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "rows": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Rows",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "AddRowOutput",
  "type": "object"
}

delete_row — Delete a specific row from a table in the AppSheet app

Parameters

string

required

Name of the table to delete a row from

object

JSON object containing the key field values of the record to delete

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "rows": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Rows",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "DeleteRowOutput",
  "type": "object"
}

get_rows — Read existing records from a table in the AppSheet app

Parameters

string

required

Name of the table to read rows from

string

An expression to filter and format the rows returned, e.g. Filter(TableName, [Column] = “Value”)

object

Filter results using key field values, e.g. {“First Name”: “John”}

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "rows": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Rows",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "GetRowsOutput",
  "type": "object"
}

update_row — Update an existing row in a specific table in the AppSheet app

Parameters

string

required

Name of the table containing the row to update

object

required

JSON object with the key field values of the record to update and any fields to change

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "rows": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Rows",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "UpdateRowOutput",
  "type": "object"
}

Using

Providers

Building

Tools

Google AppSheet Integration for AI Agents & Workflows

Overview

Authentication

AppSheet API Key

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Limits & Quotas

Cal.com

Canva

ConvertAPI

Links

​Overview

​Authentication

​AppSheet API Key

​Required Credentials

​Available Actions

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Limits & Quotas

​Related integrations

Cal.com

Canva

ConvertAPI

​Links

Overview

Authentication

AppSheet API Key

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Limits & Quotas

Related integrations

Links