Google Analytics icon

Google Analytics

Use the Google Analytics API

Actions236

Data (V1Alpha) - Audience List → Export Audience List to Google Sheet

AI-generated

Overview

This node integrates with the Google Analytics API, specifically supporting a wide range of administrative and data operations across different versions (v1alpha, v1beta) and resource types. For the selected Resource "Data (V1Alpha) - Audience List" and Operation "Export Audience List to Google Sheet," the node exports an audience list from Google Analytics to a Google Sheet.

This functionality is useful for marketers, analysts, or developers who want to automate exporting audience data directly into Google Sheets for reporting, sharing, or further analysis without manual downloads. For example, you can export a specific audience list tied to a property to a Google Sheet to share with your marketing team or integrate with other workflows.

Properties

Name Meaning
Property ID The identifier of the Google Analytics property that owns the audience list.
Audience List ID The identifier of the audience list to be exported.
Query Parameters Optional parameters to filter or paginate results; includes options like calculatedMetricId, entity, filter, names, pageSize, pageToken, showDeleted, universalAnalyticsPropertyId, updateMask.
Request Body JSON object for additional request payload if required by the operation (not typically used for export).

Output

The node outputs a JSON array where each element corresponds to the response from the Google Analytics API call. For the "Export Audience List to Google Sheet" operation, the output JSON contains the result of the export request, which typically includes metadata about the export task or confirmation details.

No binary data output is indicated for this operation.

Dependencies

  • Requires valid Google Analytics API OAuth2 credentials configured in n8n.
  • The node makes authenticated HTTP requests to Google Analytics API endpoints.
  • No additional external dependencies beyond the Google Analytics API and OAuth2 credential setup.

Troubleshooting

  • Missing Credentials Error: If the node throws "Missing Google Analytics API Credentials," ensure that OAuth2 credentials for Google Analytics are properly set up and connected.
  • Required Parameter Errors: The node validates required IDs such as Property ID and Audience List ID. Missing these will cause errors like "Property ID is required" or "Audience List ID is required." Provide these parameters correctly.
  • API Call Failures: Errors returned from the Google Analytics API are wrapped and shown with the message prefix "Error calling Google Analytics API." Check the error message and stack trace for details. Common issues include invalid IDs, insufficient permissions, or quota limits.
  • Pagination Issues: When using query parameters like pageSize and pageToken, ensure correct handling of pagination tokens to retrieve all data if needed.

Links and References

This summary focuses on the "Data (V1Alpha) - Audience List" resource and the "Export Audience List to Google Sheet" operation, describing its purpose, inputs, outputs, dependencies, and common troubleshooting points based on static code analysis.

Discussion