How can i read a google sheet from roblox?

Help and Feedback Scripting Support
#1

the title says everything, i looked for everywhere and i only found about using google sheets used as database and turning sheets into folders :frowning:

image
image1110×80 11 KB

pls help, i would like to have this table at least so i can say for example get values from for example cell A1

1 Like
#2
  1. Enable the Google Sheets API: Go to the Google Cloud Console, create a new project, and enable the Google Sheets API for that project. This will give you the necessary credentials to access the API.
  2. Obtain API credentials: Once the API is enabled, create API credentials (OAuth 2.0 client ID) for your project. Download the credentials file, which will be in JSON format. This file contains the necessary information to authenticate your requests to the Google Sheets API.
  3. Import the HttpService module: In your Roblox game, import the HttpService module by adding the following line of code at the top of your script:
  4. Make a request to the Google Sheets API: Use the HttpService’s GetAsync or PostAsync method to make a request to the Google Sheets API. You’ll need to provide the URL of the API endpoint along with the necessary authentication headers.
local HttpService = game:GetService("HttpService")

local spreadsheetId = "YOUR_SPREADSHEET_ID"
local sheetName = "YOUR_SHEET_NAME"
local apiKey = "YOUR_API_KEY"

local url = string.format("https://sheets.googleapis.com/v4/spreadsheets/%s/values/%s?key=%s", spreadsheetId, sheetName, apiKey)

local response = HttpService:GetAsync(url)
local data = HttpService:JSONDecode(response)

-- Process the data
if data.values then
    for _, row in ipairs(data.values) do
        for _, cell in ipairs(row) do
            print(cell)
        end
    end
end

Note that you’ll need to properly configure the access permissions for your Google Sheet and ensure that it is publicly accessible or that you have the necessary authentication credentials to access it.

3 Likes
#3

This user is providing AI-generated solutions, so they may or may not work.

6 Likes
#4

nah i write my own solution and just run in through chatgpt to make it look like im smart asf, im not good with english :confused:
srry

1 Like
#5

Actually i was looking for a module or some to avoid doing that stuff

1 Like
#6

hey i tried ur solution but i get HTTP 400 BAD REQUEST ERROR pls help

local documentID = "11quUIzrLOQLWdDIzoIz4trsxwKUFKQnWgueXHKaHGIQ"
local url = "https://docs.google.com/spreadsheets/d/11quUIzrLOQLWdDIzoIz4trsxwKUFKQnWgueXHKaHGIQ/edit#gid=0"
local page = "351828127"
local sheetName = "CARS"
local apiKey = --i put the last string of the json string that i downloaded when configuring autho2.0

local urlTrasnform = string.format("https://sheets.googleapis.com/v4/spreadsheets/%s/values/%s?key=%s",documentID,sheetName,apiKey)
local http = game:GetService("HttpService")

local response = http:GetAsync(urlTrasnform) --ERROR
local data = http:JSONDecode(response)
if data.values then
	for _, row in ipairs(data.values) do
		for _, cell in ipairs(row) do
			print(cell)
		end
	end
end

what am i doing wrong?