Actions84
- Admin (V1Alpha) - Account Actions
- Admin (V1Alpha) - Account Access Binding Actions
- Admin (V1Alpha) - Account Summary Actions
- Admin (V1Alpha) - AdSense Link Actions
- Admin (V1Alpha) - Audience Actions
- Admin (V1Alpha) - BigQuery Link Actions
- Admin (V1Alpha) - Calculated Metric Actions
- Admin (V1Alpha) - Channel Group Actions
- Admin (V1Alpha) - Custom Dimension Actions
- Admin (V1Alpha) - Custom Metric Actions
- Admin (V1Alpha) - Data Stream Actions
- Admin (V1Alpha) - Display & Video 360 Advertiser Link Actions
- Admin (V1Alpha) - Display & Video 360 Advertiser Link Proposal Actions
- Approve Display & Video 360 Advertiser Link Proposal
- Cancel Display & Video 360 Advertiser Link Proposal
- Create Display & Video 360 Advertiser Link Proposal
- Delete Display & Video 360 Advertiser Link Proposal
- Get Display & Video 360 Advertiser Link Proposal
- List Display & Video 360 Advertiser Link Proposals
- Admin (V1Alpha) - Event Create Rule Actions
- Admin (V1Alpha) - Event Edit Rule Actions
Overview
This node integrates with the Google Analytics API, specifically targeting the Admin (V1Alpha) resource for managing BigQuery Links. The "Create BigQuery Link" operation allows users to create a link between a Google Analytics property and BigQuery, enabling the export of analytics data to BigQuery for advanced analysis and reporting.
Common scenarios where this node is beneficial include:
- Automating the setup of BigQuery exports for Google Analytics properties.
- Integrating Google Analytics data into data warehouses or BI tools via BigQuery.
- Managing multiple properties programmatically to streamline data workflows.
For example, a marketing analyst can use this node to automatically create BigQuery links for new properties as part of an onboarding workflow, ensuring data is available in BigQuery without manual configuration.
Properties
| Name | Meaning |
|---|---|
| Property ID | The identifier of the Google Analytics property for which the BigQuery link will be created. This is required. |
| Query Parameters | Optional parameters to customize the request. Includes options like Calculated Metric ID, Entity, Filter, Names, Page Size, Page Token, Show Deleted, Universal Analytics Property ID, Update Mask. |
| Request Body | JSON object containing the details of the BigQuery link to create. This should conform to the expected API schema for creating a BigQuery link. |
Output
The output is a JSON array where each element corresponds to the response from the Google Analytics API for the create BigQuery link request. The JSON structure represents the created BigQuery link resource, typically including fields such as the link's unique ID, linked project details, and status.
No binary data output is involved in this operation.
Dependencies
- Requires valid Google Analytics API OAuth2 credentials configured in n8n.
- The node uses the Google Analytics Admin API endpoint
https://analyticsadmin.googleapis.com/v1alpha. - Proper permissions on the Google Analytics property and BigQuery project are necessary to create links.
Troubleshooting
- Missing Credentials Error: If the node throws "Missing Google Analytics API Credentials," ensure that OAuth2 credentials for Google Analytics API are properly set up and connected.
- Required Parameter Errors: Errors like "Property ID is required" indicate missing mandatory input. Verify that the Property ID is provided.
- API Errors: Errors returned from the Google Analytics API will be surfaced with messages prefixed by "Error calling Google Analytics API." Check the error message and stack trace for details.
- Permission Issues: Insufficient permissions on the Google Analytics property or BigQuery project may cause failures. Confirm that the authenticated user has the necessary roles.
Links and References
- Google Analytics Admin API - BigQuery Links
- Google Analytics API OAuth2 Setup
- BigQuery Documentation
This summary focuses on the "Admin (V1Alpha) - BigQuery Link" resource and the "Create BigQuery Link" operation as requested.