Overview
The Zoho Analytics node's "Export Data" operation allows you to extract data from a specific table (view) within a Zoho Analytics workspace and organisation. This is useful for automating the retrieval of analytics data, integrating it with other systems, or backing up records. Common scenarios include exporting filtered datasets for reporting, synchronizing Zoho Analytics data with external databases, or feeding analytics results into downstream n8n workflows.
Example use cases:
- Exporting sales data for a particular region and time period to generate custom reports.
- Pulling filtered customer data to sync with a CRM or marketing tool.
- Automating regular exports of analytics tables for archival or compliance purposes.
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. |
| Criteria | Criteria for modifying select rows, e.g., (( "Region"='East' and "Sales"<1000) or ("Sales"."Region"='West' and "Sales"<2000)). Used to filter which rows are exported based on conditions. |
Output
- The output is a JSON array where each item represents a row from the selected view (table) in Zoho Analytics that matches the specified criteria.
- Each object in the array contains key-value pairs corresponding to the columns and their values in the exported data.
- Example output structure:
[
{
"Region": "East",
"Sales": 950,
"Customer": "Acme Corp"
},
{
"Region": "West",
"Sales": 1800,
"Customer": "Beta Inc"
}
]
- No binary data is produced by this operation.
Dependencies
- External Service: Requires access to the Zoho Analytics API.
- Authentication: Needs valid OAuth2 credentials configured in n8n under the name
zohoAnalyticsApiOAuth2Api. - n8n Configuration: Ensure the credentials are set up in your n8n instance before using this node.
Troubleshooting
Common Issues:
- Invalid Credentials: If authentication fails, ensure your OAuth2 credentials are correct and have sufficient permissions.
- Missing or Incorrect IDs: Supplying incorrect or missing Organisation, Workspace, or View IDs will result in errors or empty outputs.
- Criteria Syntax Errors: Malformed criteria strings can cause API errors. Double-check the syntax according to Zoho Analytics documentation.
- No Data Returned: If the criteria do not match any rows, the output will be an empty array.
Error Messages:
- "Request failed with status code 401" – Indicates authentication issues; check your credentials.
- "View not found" or "Workspace not found" – Check that the provided IDs/names are correct and accessible.
- "Invalid criteria" – Review the criteria string for syntax errors.