Automated data collection system for analytics in Google Sheets

An automated system has been developed that integrates data from various sources into a structured Google Sheets document. The system updates data every hour, providing convenient analysis of metrics.

Functionality:

- Integration with Google Analytics: Automatic collection of the number of visitors for each page (the list of pages can be quickly supplemented).
- Integration with Short.io: Tracking data based on a specified list of identifiers.
- Google Analytics Events: A function has been added to track events and send them to Google Analytics.

Implementation Features:

- Flexibility in configuration: Easy addition of new pages, identifiers, or metrics through an intuitive interface.

- Scalability: Support for new data sources with minimal changes to the system.
Documentation: Technical documentation provided to simplify further maintenance or adaptation.

Technologies:
- Google Sheets API
- Google Analytics API
- Google Events Report
- Short.io API

#DataAutomation #GoogleSheetsAPI #AnalyticsIntegration #ShortioAPI #AutomationPortfolio #APIDevelopment