Get analytics of a website and store it Airtable

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.

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.

1. 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.