How to create a custom points leaderboard?

The basics on how to fetch and process data from an API.

This sounds like you are jumping in the deep end and have no prior knowledge of any programming language.

What you describe is fairly complex and this suggests you have no knowledge on how to fetch and process data.

Twitch isn’t a “tipping” or “donations” platform. (Tips go to streamers, donations go to charity).

So the correct api for “tips” will depend on whose system you are using.

Everthing else is just a matter of choosing one of the API notification methods, pubsub, eventsub, webhooks, chat, all provide real time data for channel point rewards(*), subs, bits usage etc.

(*) not all custom rewards notify chat.

First you need to decide what programming language to do, and learn the basics of that language, then you can move on to something more complicated such as API interaction.