Transfer Google Analytics Data to Airtable Database

This n8n workflow automates the process of extracting data from Google Analytics and storing it in an Airtable database. It simplifies the task of regularly updating your Airtable records with key analytics metrics, enabling easier reporting, analysis, or integration with other business processes.

What it does

This workflow performs the following steps:

1. Starts the workflow: The workflow is manually triggered or can be scheduled to run at specific intervals.
2. Retrieves Google Analytics Data: Connects to Google Analytics to fetch specified data.
3. Edits Fields: Transforms or renames the retrieved data fields to match the desired format for Airtable.
4. Adds/Updates Airtable Records: Inserts the processed data as new records or updates existing ones in a designated Airtable base and table.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account/Instance: A running n8n instance (cloud or self-hosted).
• Google Analytics Account: With access to the property and view from which you want to extract data.
• Airtable Account: With a base and table configured to receive the Google Analytics data.
• Google Analytics Credentials in n8n: An OAuth2 or Service Account credential for Google Analytics configured in your n8n instance.
• Airtable Credentials in n8n: An API Key or OAuth2 credential for Airtable configured in your n8n instance.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Click on the "Google Analytics" node and select your existing Google Analytics credential or create a new one.
   • Click on the "Airtable" node and select your existing Airtable credential or create a new one.
3. Configure Google Analytics Node:
   • Specify the View ID from which you want to pull data.
   • Define the Metrics and Dimensions you wish to retrieve (e.g., ga:sessions, ga:pageviews, ga:date, ga:source).
   • Set the Date Range (e.g., yesterday, 30daysAgo, startDate and endDate).
4. Configure Edit Fields Node:
   • Adjust the "Edit Fields" (Set) node to map the Google Analytics output fields to the desired field names for your Airtable table. For example, if Google Analytics outputs ga:sessions and your Airtable table has a field named Sessions, you would map ga:sessions to Sessions.
5. Configure Airtable Node:
   • Select the Base ID and Table Name where you want to store the data.
   • Ensure the Operation is set to Create or Update as per your requirement. If updating, specify the Key Field for matching records.
   • Map the fields from the "Edit Fields" node's output to the corresponding fields in your Airtable table.
6. Activate the Workflow: Once configured, activate the workflow. You can then execute it manually or set up a schedule using the "Start" node's settings for automated runs.