Online Leaderboard with google spreadsheet - is this possible?

Hi! Some time ago i found great tutorials about sending data to google spreadsheet (by dop2000 https://www.construct.net/en/tutorials/sending-data-construct-23-1447) and creating online database with google spreadsheet (by MarmisDev https://www.construct.net/en/tutorials/create-online-database-google-1373.

I thought I could combine both of them to create online leaderboard. Here is my .capx file:

https://drive.google.com/file/d/13bmqwIaEDE4UPWs-mPNPBY0KTb-WLL_1/view?usp=sharing

and here is my google sheet:

https://docs.google.com/spreadsheets/d/1qHm_tRXZ5pCDciBYT31dJVLODgITNwA5ewImsI4TgXk/edit?usp=sharing

(left part saves data from construct and right sorts them by column B, and then constuct loads top 10 results)

At first sight everything looks O.K. When I send new data for the first time, it automatically shows in leaderboard layout in my game preview. Unfortunately, this does not happen every time. Sometimes new data is saved in the google sheet, but leaderboard layout shows old scores. You can see it easily by sending new data twice, then going back to main menu and clicking leaderboard button again several times. It's quite annoying :(. If anyone has an idea how to prevent this, I would be very grateful.

P.S. I'm not sure but this problem could be simmilar to this topic:

https://www.construct.net/en/forum/construct-2/how-do-i-18/clear-ajax-lastdata-104963 Maybe there is a way to use simmilar trick with google spreadsheet url?

You need to save the project as a single .capx file and share it, .caproj file is not enough.

Ooops, I uploaded wrong file :P Thanks for catching that :)

Here is real .capx file:

https://drive.google.com/file/d/1-cBU_pEtZ4lI8JFU6bAsZdbUeaJA-MTs/view?usp=sharing

My guess is that Google Spreadsheets API is not suitable for tasks like this. It probably takes some time to update data on their servers.

Why did you decide to use spreadsheets? There are lots of services much better suited for leaderboards - Firebase, Playfab, Gamesparks etc.

I choosed this because I thought it would be simple :D I was searching for other methods too, but when I browsed tutorials on construct.net I found that many of them no longer works :(. If you could recommend me other solution that works for construct 2 I would be grateful.

I tried Gamesparks addon about a year ago and it was working fine. There are also paid addons for Playfab - they should be working too.

Thanks! I will try this :)