The final product will be a dynamic Google Sheet that will fetch metrics via API for our list of clients. We want to setup a website auditing system that will automatically fetch a series of metrics API and display them next to the appropriate client for analysis. We would like to the data to be fetched once a month on the same day.
We are working with 4 APIs, we'll need to pull 4 or 5 metrics from each service. APIs include Google Analytics, Google Search Console, GT Metrics, and DeepCrawl.
We'll need a simple process for adding new clients month after month. We'd also like to have a button that will allow us to get updated data immediately.