# Manually export Google Analytics sessions and user countries to Airtable
This automation template fetches key website traffic metrics — number of sessions and user countries — from Google Analytics and stores them in Airtable. Designed for marketers and analysts who need reliable, no-code data collection without manual exports. Enables centralized logging and streamlined reporting.
## Who it´s for
- Marketers tracking geographic distribution of website traffic.
- Analysts consolidating historical Google Analytics data.
- Project managers using Airtable for reporting and dashboards.
- Teams integrating multi-source data into a single workspace.
## What the automation does
- Triggered manually when needed (e.g., post-campaign or monthly).
- Retrieves session count and user country data from Google Analytics for a specified period.
- Transforms data using the Set node to match Airtable schema.
- Sends processed records to a designated Airtable table.
- Supports consistent, error-free data accumulation over time.
## What´s included
- Ready-to-use n8n workflow.
- Manual trigger logic and data processing nodes.
- Integrations with Google Analytics API and Airtable API.
- Basic setup and adaptation guide.
## Requirements for setup
- Active n8n account (cloud or self-hosted).
- Google Analytics access with read permissions.
- Airtable account and a base with matching field structure.
- Valid API credentials for both services.
## Benefits and outcomes
- Eliminates manual data export and copy-paste errors.
- Centralizes traffic analytics in Airtable.
- Speeds up reporting on geographic performance.
- Provides a single source of truth for team collaboration.
- Scales easily with new campaigns or time periods.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet