AppSheet
Overview
This node integrates with the AppSheet API to manage records in AppSheet tables. It supports creating, reading, updating, deleting records, and invoking custom actions on table records. The "Delete Record" operation specifically allows users to delete one or more records from a specified AppSheet table by providing key field values identifying those records.
Common scenarios for this node include automating data management workflows where records need to be programmatically removed based on dynamic criteria, such as cleaning up outdated entries, removing test data, or synchronizing deletions from other systems.
Example:
You want to delete all records in the "Products" table where the "Product Group" equals "Group To Delete". You provide a JSON array specifying these key fields, and the node sends a delete request to AppSheet to remove those records.
Properties
| Name | Meaning |
|---|---|
| Region | The AppSheet region domain to use in the API URL. Options: "Global (www.appsheet.com)" or "EU (eu.appsheet.com)". |
| Table Name | The name of the AppSheet table from which records will be deleted. This should be URL-encoded if necessary. |
| Delete Data (JSON) | A JSON array of objects specifying the key fields of the record(s) to delete. Each object must contain the key fields that uniquely identify a record. Example: [{"Product Group": "Group To Delete"}] |
| Locale | Locale string used for formatting dates and numbers, e.g., "en-US". |
| Location | Geographical coordinates as a string, e.g., "47.623098, -122.330184". |
| Timezone | Timezone string used for date/time formatting, e.g., "Pacific Standard Time". |
Output
The node outputs an array of JSON objects representing the response from the AppSheet API after attempting to delete the specified records. The structure depends on the API's response but generally includes confirmation of deletion or error details.
No binary data output is produced by this operation.
Dependencies
- Requires an API key credential for authenticating with the AppSheet API.
- Needs the App ID associated with the target AppSheet application.
- The node makes HTTP POST requests to the AppSheet API endpoint constructed using the selected region, App ID, and table name.
Troubleshooting
Invalid JSON format errors:
If the JSON provided in "Delete Data (JSON)" is malformed or not a valid JSON array of objects, the node throws an error indicating invalid JSON format. Ensure the JSON is correctly formatted and represents an array of objects with the required key fields.Operation not supported error:
If an unsupported operation value is somehow passed, the node will throw an error stating the operation is not supported. This should not occur if the UI is used properly.API authentication errors:
If the API key or App ID credentials are incorrect or missing, the API call will fail. Verify that the correct credentials are configured in n8n.Record not found or deletion failure:
If the specified key fields do not match any records, the API may return an error or empty result. Double-check the key fields and their values.