Zoho Analytics icon

Zoho Analytics

Consume the Zoho Analytics API

Actions6

Overview

The Zoho Analytics node for n8n allows you to interact with the Zoho Analytics API. Specifically, when using the Default resource and the Add Row operation, this node enables you to add a new row of data to a specified table within your Zoho Analytics workspace. This is useful for automating data entry into analytics tables, integrating data from other sources, or updating dashboards in real time.

Common scenarios:

  • Automatically logging sales transactions into an analytics table.
  • Syncing form submissions or CRM entries into Zoho Analytics for reporting.
  • Integrating third-party data sources (e.g., Google Sheets, databases) with Zoho Analytics.

Example:
When a new order is placed in your e-commerce system, use this node to add the order details as a new row in your Zoho Analytics "Orders" table.

Properties

Name Meaning
Organisation Name or ID Organisations to get data from. Choose from the list, or specify an ID using an expression.
Workspace Name or ID Workspace to get data from. Choose from the list, or specify an ID using an expression.
Views Name or ID Views to get data from. Choose from the list, or specify an ID using an expression.
Column Data Add field data. You can add multiple columns. Each column requires:
- Column Name or ID: Select or specify the column.
- Data Type: Only "String" is supported.
- Column Value: The value to set.

Output

The output will be a JSON array containing the response data from Zoho Analytics after adding the row. Each item in the output corresponds to the result of the row addition and typically includes information such as the status of the operation and any identifiers or metadata returned by Zoho Analytics.

Example output structure:

[
  {
    "status": "success",
    "details": {
      "rowId": "1234567890"
    }
  }
]

Note: The actual fields may vary depending on the Zoho Analytics API response.

Dependencies

  • External Service: Requires access to the Zoho Analytics API.
  • Authentication: Needs OAuth2 credentials (zohoAnalyticsApiOAuth2Api) configured in n8n.
  • n8n Configuration: Ensure that the Zoho Analytics node is properly installed and credentials are set up in your n8n instance.

Troubleshooting

Common issues:

  • Invalid Credentials: If authentication fails, ensure your OAuth2 credentials are correct and have the necessary permissions.
  • Missing Required Fields: If required properties (like Organisation, Workspace, View, or Column Data) are not provided, the node will throw an error.
  • API Limitations: Exceeding Zoho Analytics API rate limits may result in errors; check your Zoho account's API usage.
  • Incorrect Column Names: Providing a column name or ID that does not exist in the target view/table will cause the operation to fail.

Error messages and resolutions:

  • "Invalid organisation/workspace/view": Double-check that the selected IDs/names exist and are accessible with your credentials.
  • "Missing required parameter: columns": Ensure at least one column is specified in the Column Data property.
  • "API request failed": Review the error details for more information; it could be due to network issues, invalid data, or permission problems.

Links and References

Discussion