Automate google analytics reporting

Automate Google Analytics Reporting with n8n

This n8n workflow collects, processes, and formats Google Analytics data into a comprehensive HTML report. The report is segmented into three primary categories: Engagement Stats, Search Results, and Country Views. The formatted report can be emailed or saved as a document, and the workflow includes error handling and logging for better debugging.

Overview

Purpose

To automate the extraction, processing, and presentation of Google Analytics data in a visually appealing and structured format for easier insights and decision-making.

Features

• Data Parsing: Individual parsers process raw Google Analytics data for different time periods and categories.
• Data Aggregation: Combines parsed data into a single structured JSON object.
• HTML Report Generation: Formats the aggregated data into an HTML table with color-coded segments for better readability.
• Email or Document Output: The formatted report can be emailed or saved as a Google Doc (will need additional setup).
• Error Handling: Includes checks for missing data and detailed error messages for debugging.

Workflow Steps

1. Data Fetching:

   • Six separate Google Analytics data pulls:
     • Page Engagement Stats (This Week and Prior Week)
     • Google Search Results (This Week and Prior Week)
     • Country Views (This Week and Prior Week)

2. Data Parsing:

   • Each data pull is processed using a dedicated parser node to generate a URL-safe string.
   • Example nodes:
     • Parse - Get Page Engagement This Week
     • Parse - Country Views Prior Week

3. Data Aggregation:

   • Aggregates parsed data into a structured JSON object using the Aggregate Data node.
   • Ensures consistency and handles missing or malformed data.

4. HTML Report Generation:

   • Creates a formatted HTML report with color-coded tables for each segment:
     • Engagement Stats: Green
     • Search Results: Blue
     • Country Views: Orange
   • Includes headers and neatly formatted tables for each data set.

5. Output:

   • The report can be sent via email using the Gmail API or saved to Google Docs.
   • Example nodes:
     • Gmail node for email delivery.
     • Google Docs node for saving the report as a document.

Requirements

Prerequisites

• Google Cloud Setup:
  • Enable Google Analytics API.
  • Enable Gmail API (if using email output).
  • Generate OAuth credentials for API access.
• n8n Installation:
  • Self-hosted n8n instance with required nodes (Gmail, Google Docs, etc.).
  • Free Cloud-based n8n account.

Environment Variables

• Ensure API credentials and tokens are set up in the n8n environment.
• Update the respective nodes with client ID, client secret, and access tokens.

Configuration

Google Analytics

• Configure the Get Report nodes with the appropriate property ID and metrics.
• Ensure correct date ranges are selected for each node.

Formatting Node

• The Format Data node processes aggregated data and generates the HTML content.
• Customize the HTML styling and segment colors as needed.

Email Node

• Configure the Gmail node with OAuth credentials.
• Set the recipient email address and subject line dynamically.

Error Handling

Common Issues

1. Authentication Errors:

   • Ensure OAuth credentials are correct.
   • Verify that the APIs are enabled in the Google Cloud Console.

2. Empty Data:

   • Check the raw data from Google Analytics.
   • Validate the property ID and query parameters in the Get Report nodes.

3. Parsing Errors:

   • Ensure the parser nodes are correctly configured and match the expected input format.

Debugging

• Use debug logs in each node to identify data flow issues.
• Add error-handling nodes to capture and log issues during execution.

Example Usage

1. Run the Workflow
   • Trigger the workflow to fetch, process, and format Google Analytics data.
2. Verify Output
   • Check the formatted HTML output in the debug logs.
   • Ensure the email or Google Doc contains the correctly formatted report.

Future Enhancements

• Add support for additional metrics or dimensions.
• Integrate with Slack for notifications.
• Enable scheduling for automated reports.
• Add a visual dashboard for real-time analytics.