Is it possible to connect google sheets to a game to team certain people?

Hello fellow developers. I am part of a army group within Roblox, and we don’t have funds to create a actual group for the army. Instead, we use discord to rank our members. The only way to verify through Roblox that they are part of the army is that if they are in the group (Excelsior Development Studio) that the “General” owns. We can’t verify ranks, but we can verify if they are in the army.

Now lemme get to the point, that was some backstory. We use admin commands (Adonis, etc. idrk) and the admins have to team the enlisted constantly when they join, leave, then rejoin. That also means we can’t have a constant concurrent players because if there isn’t any admins online, they can’t be teamed, therefore, can’t roleplay. I have thought of connecting an outer source, such as google sheets, to team a person if they are part of the team list (in google sheets) if they click a certain UI button.

If it is not possible to connect google sheets to a Roblox game for that certain purpose, can you list an idea that would work? And if it is possible, can you reply some help that would get me started, or message me here on the devforum or on discord (Cr_8tiveDev#5908).

Thanks in advance!

This might have to be in discussion, I was debating, if this is in the wrong category, please list the right one, or move it. Thanks.

1 Like

I highly doubt you can use Google sheets. Why would you store it there instead of just storing the list of players directly in a script?

1 Like

Roblox’s HttpService is pretty powerful for accessing any non-roblox websites/ apis.
So you could always check out this for help creating a model utilizing HttpRequests to google sheets API.

But in the bounds of roblox, a good alternative would be utilizing Datastores. Of course, ranking would need to be done manually in your game. Set up a UI, which communicates with server to update players stats in your off the books group.

Can anyone help me get started with datastores and using it with certain ids of players?

1 Like