How to make leaderboard system with google sheet

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

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

I used leancloud for leaderboard:

Server side

  1. register/login to

  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)

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

Here is an example 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 Spreadsheet Id/gviz/tq?tqx=out:csv&tq=select A,B,C order by A desc LIMIT 10


Thankyou So much

1 Like

Thankyou So Much :slightly_smiling_face:

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.

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.