n8n AppSheet Integration

This skill enables seamless integration between n8n workflows and AppSheet tables. Perform full CRUD operations (Create, Read, Update, Delete) and invoke custom AppSheet actions—all through an intuitive, no-code interface in n8n.

What This Skill Does

Provides five core operations for managing AppSheet data within n8n workflows:

1. **Create Record** — Add one or more new records to an AppSheet table

2. **Read Records** — Retrieve records using selector expressions or key fields

3. **Update Record** — Modify existing records by specifying key fields and new values

4. **Delete Record** — Remove records by key fields

5. **Invoke Action** — Trigger custom AppSheet actions on rows

Instructions

Installation (n8n Cloud)

1. Log in to your n8n.io account at [n8n.io](https://n8n.io)

2. Click Profile → Settings → Community Nodes

3. Search for `n8n-nodes-rifad-appsheet`

4. Click Install and wait for confirmation

5. The AppSheet node will appear in your node palette

Installation (Self-Hosted)

For self-hosted n8n instances, install via npm in your n8n installation directory:

```bash

npm install n8n-nodes-rifad-appsheet

```

Then restart your n8n instance.

Configuration

1. Add the AppSheet node to your workflow canvas

2. Configure credentials:

- **Application ID** — Your AppSheet app ID

- **API Key** — Generate from AppSheet API settings

3. Select an operation from the dropdown

4. Provide parameters as JSON objects/arrays based on operation type

Operation Examples

**Create Record:**

```json

[

{

"Name": "John Doe",

"Email": "[email protected]",

"Status": "Active"

}

]

```

**Read Records:**

Use selector expressions like `SELECT(Table[_RowNumber], [Status] = "Active")` or specify key fields.

**Update Record:**

```json

{

"keyFields": {

"ID": "123"

},

"updates": {

"Status": "Inactive"

}

}

```

**Delete Record:**

```json

{

"ID": "123"

}

```

**Invoke Action:**

Specify the action name and target row keys in the node parameters.

Best Practices

Constraints

Example Workflow

**Automated CRM Sync:**

1. Trigger: Webhook receives new customer data

2. AppSheet Node (Create): Add customer record to AppSheet table

3. Conditional: Check if customer qualifies for premium tier

4. AppSheet Node (Invoke Action): Trigger "Send Welcome Email" action

5. Slack notification confirming sync

This skill eliminates the need to write raw API calls, making AppSheet automation accessible to non-developers while maintaining full operational flexibility.