Advise on sending a daily report from GCP

Google Cloud Cloud Foundations & Onboarding
1

Hi Team,

I have a requirement to send daily report as emai on

  1. No of projects in the organisation
  2. Resources that exist outside a specific region.
  3. Security recommendations from active assist.

This may slightly increase.

Can someone please shed some light the better way of doing. What I am thinking is as below

A. Use cloud run functions with python code which make api calls to get the data

B. Format that data as HTML table.

C. Email it

Thank you.

Regards,

Prad