Extract Website Analytics and Store in Airtable
detail.loadingPreview
Automate the extraction of website analytics (sessions per country) from Google Analytics and store it directly into an Airtable base.
About This Workflow
This workflow automates the process of fetching website analytics data from Google Analytics and storing it in a structured format within Airtable. It leverages the Google Analytics node to retrieve metrics like sessions, broken down by country, over a specified date range. The retrieved data is then processed by a Set node to format it before being appended to a designated Airtable table using the Airtable node.
Key Features
- Connects to Google Analytics API to retrieve website data.
- Configurable date ranges for data extraction.
- Ability to specify metrics (e.g., Sessions) and dimensions (e.g., Country).
- Uses a Set node to structure and rename retrieved data fields.
- Appends the processed data directly to an Airtable table.
How To Use
- Trigger: The workflow starts manually by clicking 'execute' on the
On clicking 'execute'node. - Fetch Analytics: The
Google Analyticsnode retrieves data. Ensure theviewId,credentials, anddateRangesUiare correctly configured for your Google Analytics property. Metrics and dimensions can be customized within theadditionalFieldsparameter. - Format Data: The
Setnode processes the output from the Google Analytics node. It renamesga:countryto 'Country' and the aggregated session metric (likely namedtotalbased on common Google Analytics node output, though this should be verified) to 'Metric'. Adjust the expressions={{$json["total"]}}and={{$json["ga:country"]}}if the output field names from the Google Analytics node differ. - Store in Airtable: The
Airtablenode appends the formatted data to your specified Airtable table. Ensure your Airtablecredentialsandtablename are correctly set.
Apps Used
Workflow JSON
{
"id": "9b52033e-4c4a-48d5-adc5-47cfc71ad50c",
"name": "Extract Website Analytics and Store in Airtable",
"nodes": 12,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 9b52033e-4c4a...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.