How to build an Automated leaderboard in SharePoint based on user activity on the SharePoint site...???

Hi @Subba Reddy,

Thanks for reaching out to us. We are very pleased to support you.

Unfortunately, SharePoint doesn't have an out-of-the-box way to add leaderboards to a site or page at this time.

Here are a few steps you can take:

1. Provide Feedback to Microsoft: We are always looking for ways to improve SharePoint, and your feedback and suggestions are very valuable. We suggest that you can make suggestions on this SharePoint Feedback portal for Automated leaderboard in SharePoint. Your contribution will be highly appreciated.
2. Use SPFx to create your leaderboard web part: It is recommended that you use SPFx to customize SharePoint web parts. If you are new to SPFx, you can start learning SPFx from this article. You can also visit this Partner Community to ask your questions. Most of the users in this forum are more specialized in SPFx who can help you better.
3. Third-party tools You can seek out other third-party tools to see if they can solve your problem. Here I have found a third-party tool that you can see if it helps you. https://keepthescore.com/docs/sharepoint/ Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

Certainly, if you have any concerns or questions, please do not hesitate to reach me. Please kindly note: we will always be standby to support you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. It will be beneficial to more community members reading here. Your contribution will be highly appreciated.