Grabbing a string from Google Sheets to Roblox SurfaceGUI Text

[SmallGrep]

Hi. I am making a feature in-game whereby the bus timings would be projected onto a screen with textboxes using Google Sheets so that my team & I can edit the “database” that roblox is pulling from. Is it possible to do so in roblox?

I look forward to your help!

[TheDevvy (Eldon)]

I believe there is a service you can use for communication across different game-server instances. If I were to approach this problem I’d use a vip server for admins that contains a gui to edit the timings. Then use this service to communicate with all the other games. I’ve never used it, and don’t know how optimized it is, but I’d give it a shot. Cross-Server Messaging | Documentation - Roblox Creator Hub messaging service

[SilvRHat]

Totally possible; you’d just need to combine the HttpService on your game with the Google Sheets API.
Heres an older forum post describing the process in depth:

Using HttpService with Google Sheets

EDIT: Please note this tutorial is quite dated, and may not work as expected. It is also recommended to not use as a database, unless for experimental/testing purposes. decided to write this up around 3am in the morning, so excuse my weird grammar So I thought I’d create a thread of an unusual way on how to record pretty much anything that you want to in your game such as players purchasing developer products, script errors, or even the chat history using HttpService. The coolest thing about t…

Heres some additional references which might be useful:
Google sheets API REST Reference sheet (Useful for constructing your http requests)
Roblox API HttpService:RequestAsync() Method (Roblox side of things)