AppSheet
Overview
This node integrates with the AppSheet API to perform various operations on table records within an AppSheet application. Specifically, for the Update Record operation, it updates existing records in a specified AppSheet table by sending new values for one or more fields of those records.
Common scenarios where this node is beneficial include:
- Automating updates to data stored in AppSheet tables based on external triggers or workflows.
- Synchronizing changes from other systems into AppSheet-managed data.
- Bulk updating multiple records at once by providing an array of record objects with key fields and updated values.
For example, you might update product information such as short codes or naming syntax in a product catalog managed via AppSheet by supplying the key identifying fields along with the new values.
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 where records will be updated. This should be URL-encoded if necessary. |
| Update Data | A JSON array of objects representing the records to update. Each object must include the key fields identifying the record and the fields to update. Example format: json<br>[{<br> "Product Group": "Existing Group",<br> "Product Group Short Code": "EG",<br> "Model Naming Syntax": "EG-{NewCode}"<br>} ]<br> |
| 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 a JSON array containing the response(s) from the AppSheet API after attempting to update the records. Each element corresponds to the result of an update action for a record or set of records.
The output structure depends on the API response but generally includes confirmation of the update or error details if the update failed.
This node does not output binary data.
Dependencies
- Requires an API key credential for authenticating with the AppSheet API.
- Needs the App ID of the target AppSheet application.
- The node uses HTTP POST requests to the AppSheet API endpoint constructed using the selected region, app ID, and table name.
- Proper JSON formatting of the "Update Data" input is mandatory.
Troubleshooting
Invalid JSON format errors:
If the "Update Data" property contains invalid JSON, the node throws an error indicating the JSON must be a valid array of objects. Ensure the JSON is correctly formatted and represents an array of objects with the required key fields.Unsupported operation error:
If an unsupported operation is selected, the node will throw an error stating the operation is not supported. Make sure to select "Update Record" for this functionality.API authentication issues:
If the API key or App ID credentials are incorrect or missing, the API request will fail. Verify that the correct credentials are configured in n8n.Incorrect table name or keys:
If the table name is wrong or the key fields in the update data do not match the AppSheet table schema, the update may fail or have no effect. Double-check the table name and key field names.