AppSheet

Interact with the AppSheet API to add, read, update, delete records, or invoke a custom action on table records.

Overview

The AppSheet node's "Update Record" operation allows you to update one or more records in a specified AppSheet table. You provide the table name and a JSON array of objects representing the records to update, including both key fields (to identify the record) and the fields with new values. This is useful for automating updates to your AppSheet data from n8n workflows.

Common scenarios:

  • Bulk updating product information in an inventory management app.
  • Modifying user details in a CRM built on AppSheet.
  • Automating corrections or status changes in operational tables.

Example:
You have a table called Products and want to update the "Price" and "Stock" fields for several products at once.


Properties

Name Type Meaning
Region options The AppSheet region domain to use in the API URL. Choose between Global or EU endpoints.
Table Name string Name of the AppSheet table (URL-encoded if needed). Required.
Update Data json JSON array of objects representing the record(s) to update. Each object must include key fields and the fields to update. Example:

json<br>[{<br> "Product Group": "Existing Group",<br> "Product Group Short Code": "EG",<br> "Model Naming Syntax": "EG-{NewCode}"<br>}]<br>
Locale string Locale used for formatting dates and numbers (e.g., en-US).
Location string Geographical coordinates (e.g., 47.623098, -122.330184).
Timezone string Timezone used for date/time formatting.

Output

  • The output is a JSON array containing the response(s) from the AppSheet API for each update request.
  • The structure of each item in the output array depends on the AppSheet API's response for the "Edit" action. Typically, this includes:
    • Status of the update (success/failure)
    • Any error messages
    • Details about the updated records

Example output (structure may vary):

[
  {
    "status": "SUCCESS",
    "updatedRows": [
      {
        "Product Group": "Existing Group",
        "Product Group Short Code": "EG",
        "Model Naming Syntax": "EG-{NewCode}"
      }
    ]
  }
]

Note: The actual fields depend on your AppSheet table and API configuration.


Dependencies

  • External Service: Requires access to the AppSheet API.
  • API Key: You must configure AppSheet API credentials (appSheetApi) in n8n, including:
    • apiKey: Your AppSheet Application Access Key.
    • appId: Your AppSheet App ID.
  • n8n Configuration: No special environment variables are required beyond the credential setup.

Troubleshooting

Common Issues:

  • Invalid JSON format in Update Data:
    If the "Update Data" field contains invalid JSON, the node will throw an error:
    "Invalid JSON format in Update Data. It must be a JSON array of objects."

    • Resolution: Ensure your input is valid JSON and matches the expected array/object structure.
  • Missing required fields:
    If key fields required by your AppSheet table are missing in any object, the update may fail or be ignored by AppSheet.

    • Resolution: Include all necessary key fields in each object within the "Update Data" array.
  • Authentication errors:
    If your API Key or App ID is incorrect or missing, the node will fail to authenticate with AppSheet.

    • Resolution: Double-check your AppSheet API credentials in n8n.
  • Operation not supported:
    If an unsupported operation value is provided, you'll see:
    "Operation "..." not supported!"


Links and References

Discussion