Get Website Analytics and Store in Airtable

Name: Get Website Analytics and Store in Airtable
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

42 views

0 downloads

Community Contributedairtableanalyticsdata integrationgoogle analyticsreporting

Fetch website analytics from Google Analytics and store them in an Airtable base.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of retrieving website traffic data from Google Analytics and populating it into a specified Airtable base. It's designed for users who want to centralize their website performance metrics.

Key Features

Connects to Google Analytics API to fetch data.
Allows customization of metrics and dimensions (e.g., sessions, country).
Sets specific values for 'Metric' and 'Country' based on analytics results.
Appends data to an Airtable table.
Includes error handling for robust execution.

How To Use

Import the workflow into your n8n instance.
Configure the Google Analytics node with your Google Analytics Account, Property, and View ID, and set the desired date range, metrics (like 'Sessions'), and dimensions (like 'Country'). Ensure the 'analytics-dev' Google Analytics credential is set up.
Configure the Airtable node by selecting your Airtable API credential (e.g., 'Airtable Credentials n8n') and specifying the target 'Table 1' where the data should be stored.
Manually execute the workflow by clicking the 'Execute' button on the Manual Trigger node.

Apps Used

airtable

analytics

data integration

google analytics

reporting

Workflow JSON

{
  "id": "6ac6abe1-08dc-41c5-a130-00b8d3d44f5b",
  "name": "Get Website Analytics and Store in Airtable",
  "nodes": 0,
  "category": "Community Contributed",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.