Google Sheet
zzner7
Member Posts: 4
Is there a way to display data from a Google Sheet document? As in have the app/game pull data from an online Google sheet and display it in the app?
Comments
This is possible, but it's been a loooooooooooong time since I've done it. If I remember right, Firebase can pull the data from the sheet, and then you can pull the data from Firebase using a server (at the time I was hosting it on Glitch iirc). I'm sorry I can't help with more details, it's been a long time and this is not something I have much expertise in. But it is possible using the network behaviours and an external server (and Google).
Contact me for custom work - Expert GS developer with 15 years of GS experience - Skype: armelline.support
There may be some changes to the "How To" for enabling this script, but I believe the script itself works still:
https://forums.gamesalad.com/discussion/comment/611542/#Comment_611542
Instead of Tools > Script Editor you now go to Extensions > AppScripts
Even easier than I remembered!
Contact me for custom work - Expert GS developer with 15 years of GS experience - Skype: armelline.support
@zzner7 the main thing to remember here is that there are limits to how often / how much you can pull data from the google sheet.
If the google sheet is a read only data source (i.e. players don't push data to it), you can put the google sheets URL behind a caching proxy and avoid overusing google doc's system.
If you mean for users to write to a google sheet as part of the app, then a private small scale app (like an internal app for employees or an app used as part of a presentation), then you should be fine.
But if it's for a publically release game, I'd do what @Armelline is suggesting. Push the google sheet data to firestore or another similar database. Then set up an API that pulls the stored data and sends it in the GameSalad table format.
Doesn’t have to be google Sheets at all, I was just curious. Thank you both