n8n-node-appsheet

Forked from https://github.com/rifadm817/n8n-nodes-rifad-appsheet

Welcome to n8n-node-appsheet – AppSheet integration nodes for n8n.

Improvements and additions

• Modernized UI inputs with Records key/value editors for Create, Find, Update, Delete, Invoke
• Options panel with Locale, Location, Timezone, User Settings, Run as User Email, and Action Properties
• New If Exists operation with multiple operators, type handling, and selector support
• New Upsert Records (Bulk) operation with batch size and dry-run mode
• Returned exists, count, and records for If Exists
• Updated icon and improved packaging (ship only required files)

Features

• Create Record: Add one or more new records to an AppSheet table.
• Read Records: Retrieve records using a selector expression or by specifying key fields.
• Update Record: Update existing records by providing key fields and the new field values.
• Delete Record: Delete records by specifying key fields.
• Invoke Action: Invoke a custom AppSheet action on one or more rows.
• If Exists: Check if a record exists based on conditions, and return matching rows.
• Upsert Records: Create or update multiple records with batching and dry-run.

Examples

Find record by key

Operation: Find Record

Records:

Key: event_id
Value: 1793a645b9c5659ee10ebf578e388bb7

Find using selector

Operation: Find Record

Selector:

FILTER(hibob_webhooks_events, [event_id] = "1793a645b9c5659ee10ebf578e388bb7")

If Exists with conditions

Operation: If Exists

Conditions:

• Field: event_id
• Operator: Contains
• Value Type: String
• Value: 1793a6

Bulk Upsert

Operation: Upsert Records

Records (2 items):

Fields:
  Key: Email
  Value: user@example.com
  Key: Name
  Value: John

Fields:
  Key: Email
  Value: jane@example.com
  Key: Name
  Value: Jane

Key Fields:

Field Name: Email

Batch Size: 100
Dry Run: true

Install on n8n Cloud

If you use the cloud version of n8n (n8n.io), installing our node is a piece of cake. Follow these steps:

1. Log in to Your n8n.io Account:
   Open your browser and log in at n8n.io.

2. Navigate to Settings:
   In the n8n editor, click your Profile → Settings icon.

3. Go to Community Nodes:
   Select Community Nodes from the Settings menu. You’ll be able to search for and install custom nodes there.

4. Search for n8n-nodes-rifad-appsheet:
   Type the package name in the search bar. When it appears, click Install.

5. Add the AppSheet Node to Your Workflow:
   Once installed, add the AppSheet node to your workflow, configure it with your AppSheet API credentials, and start automating without hardcoding API calls.

Usage

Simply configure the node with your AppSheet API credentials and choose an operation (create, read, update, delete, or invoke). Each operation requires you to provide the necessary parameters as JSON. For example, to add a record, supply a JSON array of objects (each object representing a record with the required key fields).

Happy Automating!