How to make leaderboard system with google sheet

[App_maker3 (App Maker)]

Hello Friends
i am working on App
And i want to impement a leaderboad system in my app with google Sheet

the probleam is that i want to get only top 10 payers (According to their score ) data in decending order

Please Help me

[Aarush_BH (Aarush)]

you can use firebase, then add temporary values in it, then use if then for changing the values

[Kevinkun]

I used leancloud for leaderboard:

Server side

1. register/login to https://leancloud.app/

2. create an app and open it;

3. go to Settings → App keys, get appId, appKey, MasterKey, ServerURL,

4. go to Play → LeaderBoard → Data ->Create Leaderboard.

   MemberType, select ‘Entity’

   VersionChangeInterval, select ‘never’

Kodular/App Inventor side

below block images are draggable (drag it onto your block view directly)

[Decoder_360 (The Decoder 360)]

The Simple Method is use gviz if you are doing with Google Spreadsheet

Here is an example

https://docs.google.com/spreadsheets/u/0/ your spreadsheet id/gviz/tq?tqx=out:csv&tq=select  A,B,C, order by A desc LIMIT 10

Select A,B,C is the column name 

order by A ( put your score column alphabet )

Output
 
https://docs.google.com/spreadsheets/u/0/d/Your Spreadsheet Id/gviz/tq?tqx=out:csv&tq=select A,B,C order by A desc LIMIT 10

[App_maker3 (App Maker)]

Thankyou So much

[App_maker3 (App Maker)]

Thankyou So Much

[TimAi2 (metricrat)]

You could also create another sheet on your spreadsheet and setup a similar query function there (using the =QUERY(), then you just call the query output to your app.