Roblox to Google Spreadsheet

sI0_th · August 20, 2022, 11:12am

Disclaimer: So, I have spent the last few hours trying to figure out how to setup OAuth 2.0 for google, to allow changing spreadsheets and such, but I came to a point where I couldn’t be bothered with the hassle as its a somewhat lengthy and complex process, and I have more important things to do, So all this example does is pull all the data from a spreadsheet.

I was recently asked about setting up Google Spreadsheets to work with roblox, and created this example/tutorial for them to use, and I thought I would share it with the Developer community since resources in this area seem to be lacking.

github.com

Helix0001/spreadsheet_api_example/blob/main/module.lua

--!strict

--[[ 
	Create your spreadsheet and set it up however you want,
	First get your spreadsheet ID, this is the string in the url after /d and before /edit
	Example: https://docs.google.com/spreadsheets/d/ASD8ASDLKJASD1KJ1LKJ/edit#gid=0
	The spreadsheet ID is ASD8ASDLKJASD1KJ1LKJ

	You then need to create an API key if you haven't already which can be done here:
	https://console.developers.google.com/apis/credentials

	Make sure, if you haven't already that you have the Spreadsheet API enabled for that specific project, otherwise requests will be denied:
	https://console.cloud.google.com/apis/api/sheets.googleapis.com

	If you don't know your project ID, enter the request URL in your browser,
	there will be a link provided which takes you straight to where you need to be to enable it.
	
	If you recieve an error: 403 The caller does not have permission, I fixed this by clicking "Share" at the top right in the spreadsheet,
	and setting the viewing mode to "Anyone who has a link"
]]

This file has been truncated. show original

Now I’m not saying Google spreadsheet’s should be used, or is a better alternative to using Datastore, quite the opposite actually, but if you can think of a use for this, then here you go

DeathToTheStadium · February 1, 2024, 9:28am

The Ability To Ping The Api Ever So Often and update data About the weapons in game without having to restart your Servers