This guide shows you how to import Google Analytics 4 data into Airtable using the Data Fetcher extension. You'll learn to connect GA4 to Airtable, automatically import key metrics like users, sessions, and new users, and set up scheduled data syncing.
Note: This guide covers Google Analytics 4 (GA4), which has replaced Universal Analytics (UA).
Install Data Fetcher Extension
1. Install Data Fetcher from the Airtable marketplace.
2. Create your free Data Fetcher account by entering a password, then click Create your free account →.
Create Google Analytics 4 Integration Request
1. On the Data Fetcher extension home screen, click Create your first request.
Requests in Data Fetcher are how you import data to or send data from your Airtable base.
2. For Application, select Google Analytics 4 to use the Google Analytics Airtable integration.
3. Under Authorization, click New Google Analytics 4 Connection.
Authorize Google Account Access
1. You'll be taken to a new tab where you need to authorize Data Fetcher to access your Google Analytics account. Select the Google account containing your GA4 data.
2. Click Continue.
3. On the permissions screen, enable See and download your Google Analytics data before clicking Continue.
4. You'll return to the Data Fetcher interface with your Google Analytics 4 connection established. Enter a name for your request, such as "Import GA4 Metrics".
5. Click Save & Continue.
Configure Google Analytics 4 Data Import
1. Select the Google Analytics 4 Account you want to import data from.
2. Select the Property you want to import data from.
3. Choose your Date range, such as "Last week", to specify which time period to import data for.
4. Select the Fields you want to import to Airtable from Google Analytics 4. Popular metrics include "Total Users", "New users", and "Sessions". You can select up to 10 fields per request. To import more than 10 fields, complete this request setup, then duplicate it and select additional fields in the second request.
5. Choose a Split by option to organize your data into separate records. Select "Date" to create individual records for each date in your range, or "Page location" for each URL.
6. Optional: Add Filters to only import specific data based on criteria you set. For example, you could filter to exclude pages with query parameters by setting "Page" does not contain "?".
7. Select the Output Table & View where you want to import your Google Analytics 4 data.
8. Click Save & Run.
Map Your Google Analytics Data Fields
1. Data Fetcher will run your request and open the Response Field Mapping modal. This is where you configure how Google Analytics 4 fields will map to your Airtable table.
2. For each Google Analytics field, decide whether to map them to an Existing field in your table or create a New field.
3. Set appropriate field types for new fields (Data Fetcher predicts these automatically, but you can adjust them as needed).
4. Once you're satisfied with your field mapping, click Save & Run.
5. Data Fetcher will create any new fields in your output table and import your Google Analytics 4 data into Airtable.
6. To run the request again with the same settings, simply click Run. You won't need to reconfigure the field mapping unless you change your selected fields.
Set Up Data Syncing for Updates
To ensure Data Fetcher properly syncs your Google Analytics data when you run the request again:
1. Navigate to Advanced settings in Data Fetcher.
2. For Update Based on Field(s), select the same field you chose for "Split by" (such as "Date" or "Page path"). This keeps your Airtable records properly synchronized with your Google Analytics data.
Schedule Google Analytics Airtable Integration
Currently, you need to manually click Run to import updated Google Analytics 4 data. You can schedule the integration to run automatically at regular intervals, so any new data from Google Analytics is imported into Airtable on your chosen schedule.
This is a paid Data Fetcher feature, so you'll need to upgrade your account if you haven't already.
Upgrade Your Account
1. In Data Fetcher, scroll to Schedule and click Upgrade.
2. Select a plan from the available options based on your needs and enter your payment details.
Set Up Automatic Scheduling
1. Under Schedule, click + Authorize.
2. A window will open allowing you to authorize the Airtable bases you want Data Fetcher to access.
3. Select All current and future bases in all current and future workspaces to avoid authorization issues in the future. Click Grant access.
4. You'll see Schedule this request is now toggled on. Select how often you want the request to run based on intervals of "Minutes", "Hours", "Days", or "Months".
5. Click Save. Your Google Analytics Airtable integration will now run automatically and import updated GA4 data on your chosen schedule.
Import Google Analytics Metrics for Specific URLs Only
If you want to import metrics for only a specific list of URLs (rather than all pages), follow these steps to set up URL-specific tracking.
Prepare Your URL List
1. Create a table in Airtable with your site's URLs that you want to track.
2. Ensure all URLs are formatted consistently. For example, make sure you don't mix HTTP and HTTPS protocols.
Configure Google Analytics Request for URL Tracking
1. Set up your Google Analytics request by following the previous instructions, but for Split by, select "Page location" instead of "Date".
2. Click Save & Run to run the request and open the Response field mapping.
3. On the Response field mapping, map the "Page location" field to your existing "URL" field in the table.
4. Click the right arrow to open the settings sidebar.
5. Then click to open the Advanced settings and ensure Update is selected under Write mode.
6. Toggle off Create records leftover after update. This ensures Data Fetcher only updates existing records in your table, without creating new ones.
7. Finally, under Update Based on Field, select the "URL" field.
8. Click Save & Run. The Google Analytics integration will now import metrics only for the URLs in your table.
Benefits of Connecting Google Analytics 4 to Airtable
Once you've connected Google Analytics 4 to Airtable, you can turn your website data into organized reports and automated workflows. Here's what you can do with this integration:
Track Marketing Campaigns: Import your campaign performance data and conversion numbers into Airtable tables. You can see which ads, emails, or social posts drive the most traffic and link this data directly to your campaign budgets and planning documents.
Analyze Content Performance: Pull metrics for your blog posts, landing pages, and product pages into Airtable. Match these numbers with your publishing calendar to quickly spot your best content and plan what to create next.
Track SEO Progress: Keep tabs on your organic search traffic and keyword rankings. Combine GA4 data with your SEO task lists and content plans to see what's working and what needs improvement.
Create Client Reports: If you manage websites for clients, automatically import their website metrics into Airtable. Set up scheduled imports and build reports that show analytics alongside project updates and deliverables.
