Hello ,
As per existing feature, we can export the usage report to storage account. Reference to schedule export to storage account from cost management exports: https://www.youtube.com/watch?v=rWa_xI1aRzo
Doing this will automatically export the report to a storage account. Blob storage events are pushed using Azure event grid to subscribers such as Azure Functions, Azure Logic Apps, or even to your own http listener.
Please refer this thread: https://learn.microsoft.com/en-us/answers/questions/1074286/how-to-get-a-monthly-cost-consumption-email-notifi.html
Regards
Divya