Azure resources metrics and their utilizations to Google sheet

Question

Hello,

In order to identify whether the Azure resources/services is Idle/underutilized I am looking for a solution to fetch all the key metrics for all the resources types to a google sheet and automate the sheet to decide whether the resource is Idle/Underutilized.

Since there will be different metrics to be considered to analyze the utilization of different resource types. How we can identify which metrics to be considered for which resource type. Is it even possible to achieve when we have 1000s of resources in our azure subscription.

Final output I am trying to achieve:

1. Automate all the Azure Key metrics of all the resource types to a Google sheet
2. Automate the Google sheet to decide whether the resource is Idle/underutilized based on the metrics average
3. automate to send an email/alerts to the resource owner to take actions if any resources is Idle/underutilized

Thanks