How to get analytics of a SharePoint file via email report?

[Ukhan]

Hi Community,

We have a specific requirement where we need to get detailed analytics of a particular excel file hosted on our SharePoint Online site over email every day. We would like to get the number of views and usernames for the file.

We would like to know if there is a way to achieve this using the SharePoint inbuilt feature or using a script + SharePoint/Graph API. We would also like to mention that the report needs to be in a specific format, and we have some security constraints.

Is there anyone who has done this before and could guide us on how to achieve this?

Thank you in advance for your help!

[#2 · Accepted solution]

@Ukhan I had the same question couple of months ago 
I went through this article and set this up with Azure App registration it's working perfect since you have access to more resources in Graph.
Check this:
https://microsoft365.today/automating-sharepoint-file-analytics-reports-via-email-using-azure-functi...

Review this and let me know if you have any questions. 

[#3]

Thanks Jennifer,

I followed all the steps from above article you shared.
I am getting python dependency errors. I created requirements.txt but it doesn't seem to be working. I am runing script in __init__.py
Here is the error screen
https://prnt.sc/4Vwhq9oOFcvT
here is requirements.txt
https://prnt.sc/Q2IW7aU88zF0
Any help would be highly appreciated
Thanks