Bear Brown
← All N8N workflows
Messaging & emailCodeGmailGoogle AnalyticsManual TriggerSchedule Trigger

Automate Google Analytics Reporting - AlexK1919

Configured with Gmail, Google Analytics, Schedule Trigger. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗19 nodes · MIT
Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerIntegrationGet Page EngagementStats for this weekGoogle AnalyticsIntegrationGet Page EngagementStats for prior weekGoogle AnalyticsIntegrationGet Google SearchResults for this weekGoogle AnalyticsIntegrationGet Country views datafor this weekGoogle AnalyticsCodeAggregate DataCodeIntegrationGet Google SearchResults for prior weekGoogle AnalyticsIntegrationGet Country views datafor prior weekGoogle AnalyticsCodeParse - Get PageEngagement This WeekCodeCodeParse - Get PageEngagement Prior WeekCodeCodeParse - Get GoogleSearch This WeekCodeCodeParse - Get GoogleSearch Prior WeekCodeCodeParse - Country ViewsThis WeekCodeCodeParse - Country ViewsPrior WeekCodeTransformSet urlStringsEdit FieldsCodeFormat DataCodeCodeInput AllCodeMessagingEmail the ReportGmailTriggerSchedule TriggerSchedule Trigger

Node categories in this workflow

  • Trigger
  • Integration
  • Code
  • Transform
  • Messaging

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
Get Page Engagement Stats for this weekIntegrationGoogle AnalyticsSee node parameters
Get Page Engagement Stats for prior weekIntegrationGoogle AnalyticsSee node parameters
Get Google Search Results for this weekIntegrationGoogle AnalyticsSee node parameters
Get Country views data for this weekIntegrationGoogle AnalyticsSee node parameters
Aggregate DataCodeCodeSee node parameters
Get Google Search Results for prior weekIntegrationGoogle AnalyticsSee node parameters
Get Country views data for prior weekIntegrationGoogle AnalyticsSee node parameters
Parse - Get Page Engagement This WeekCodeCodeSee node parameters
Parse - Get Page Engagement Prior WeekCodeCodeSee node parameters
Parse - Get Google Search This WeekCodeCodeSee node parameters
Parse - Get Google Search Prior WeekCodeCodeSee node parameters
Parse - Country Views This WeekCodeCodeSee node parameters
Parse - Country Views Prior WeekCodeCodeSee node parameters
Set urlStringsTransformEdit FieldsSee node parameters
Format DataCodeCodeSee node parameters
Input AllCodeCodeSee node parameters
Email the ReportMessagingGmailSee node parameters
Schedule TriggerTriggerSchedule TriggerSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • gmailOAuth2
  • googleAnalyticsOAuth2

Workflow notes

Aggregate Google Analytics data and Email the results

Aggregate Google Analytics data and Email the results

This workflow will check for country views, page engagement and google search console results. It will take this week's data and compare it to last week's data.

Credit to Keith Rumjahn for the original workflow, which I modified.

Property ID

Property ID

  1. Create your Google Analytics Credentials
  2. Enter your property ID or Choose from the List of Properties.
AlexK1919

AlexK1919

I’m Alex Kim, an AI-Native Workflow Automation Architect Building Solutions to Optimize your Personal and Professional Life.

Info

Automate Google Analytics Reporting - AlexK1919

Automate Google Analytics Reporting - AlexK1919

Purpose and structure

This folder contains the Automate Google Analytics Reporting - AlexK1919 workflow. Its executable nodes use code, gmail, googleAnalytics, manualTrigger, scheduleTrigger, set. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When clicking ‘Test workflow’, Schedule Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Googleanalytics/0475_Googleanalytics_Code_Automate_Scheduled.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Format the data and Email

More in Messaging & email

Addon for Workflow Nodes Update Check TemplateAge and number of the newsAI Email Filtering Automation