Hello! I am making an Obby Game, I have a DataStore to store all the players data, I would like to know if there is a way where I can link my DataStore to a Google Spread Sheet, If this is possible could somebody please make me a script for it?
Thanks!
Well, As far as I’m aware; Google Spreadsheets does NOT support Webhooks, correct me if I’m wrong.
However, If you setup a request from Roblox to a script OUTSIDE Roblox to update the spreadsheet, it may be possible.
Do you know how I would be able to do that?
Well, I’d use webhooks to update the datastore.
and since I don’t specialize in JavaScript for Google Spreadsheets, I wouldn’t know much on how to help you update that from the third party.
You’d need to use a webhook to some external resource, mostly likely converting the Datastore into JSON and potetionally vice versa. Probably you’d have to program the web application yourself due to the specificity of your request.
I do know it’s possible to READ data from a google spreadsheet, using Share > Publish to Web, but even then, they do not provide a JSON format (next best is .CSV) which means another step would be required.