Get analytics of a website and store it Airtable

Get analytics of a website and store it in Airtable, enabling users to effortlessly track website performance metrics like sessions over specified date ranges. This automated workflow integrates Google Analytics for data retrieval and Airtable for organized storage, simplifying the process of monitoring and analyzing web traffic.

7/8/2025
4 nodes
Simple
manualsimplegoogleanalyticsairtable
Categories:
Manual TriggeredSimple WorkflowData Processing & Analysis
Integrations:
GoogleAnalyticsAirtable

Target Audience

This workflow is ideal for:
- Digital Marketers looking to analyze website traffic and performance metrics from Google Analytics.
- Business Owners who want to track their website's engagement and visitor demographics.
- Data Analysts needing a streamlined method to transfer analytics data into Airtable for further analysis.
- Non-technical Users who prefer a manual trigger for running reports without needing to set up complex automation.

Problem Solved

This workflow addresses the challenge of manually collecting and storing website analytics data. By automating the retrieval of key metrics such as Sessions and Country from Google Analytics and storing them in Airtable, users can:
- Save time by eliminating repetitive data entry tasks.
- Ensure data accuracy and consistency by automating the data transfer process.
- Easily access and manage analytics data for reporting or decision-making purposes.

Workflow Steps

  • Manual Trigger: The workflow starts when the user clicks the 'execute' button, initiating the data retrieval process.
    2. Google Analytics Node: It fetches analytics data from Google Analytics using the specified viewId. The data includes:
    - Metrics: Total Sessions over a defined date range (from December 31, 2019 to August 30, 2020).
    - Dimensions: Visitor Country information.
    3. Set Node: The retrieved data is then structured into a format suitable for Airtable:
    - The Metric is set to the total sessions value.
    - The Country is set to the corresponding country value.
    4. Airtable Node: Finally, the structured data is appended to a specified table in Airtable, allowing for easy tracking and management of website analytics data.

    • Customization Guide

    To customize this workflow:
    - Modify Date Range: Adjust the startDate and endDate in the Google Analytics node to fit your reporting needs.
    - Add More Metrics: Expand the metricsUi section to include additional metrics such as Pageviews or Bounce Rate by adding more metric values.
    - Change Dimensions: Customize the dimensions in the dimensionUi to analyze different aspects of your audience, like City or Device Category.
    - Update Airtable Table: Change the table parameter in the Airtable node to point to a different table where you want to store the data.
    - Adjust Credentials: Ensure that the correct credentials are set for both Google Analytics and Airtable to maintain secure data access.