How to change info in table in google sheets

[htyfn1231101 (Xalanawer)]

Module for Google Sheets

Hello everyone, I was looking for how to get information from Google Sheets for a self-updating LocalizationTable and decided to share it, information taken from this video: [Exportar datos de Google Sheets a JSON en tiempo real] How to use You create or open a file in Google Sheets. You press Share and in change you press Anyone with the link. Copy link, and you go to Roblox, remember to allow HTTPS requests. Download the module or get it by its asset id and in a script write th…

i use module google sheets, for get info.
i want know, how i can change info in table using script?

[htyfn1231101 (Xalanawer)]

It’s been 3 hours I can’t find the answer, if you can help me I will be very grateful to you
Any help is helpful

[Doomcolp (dxxmed)]

use HTTPService… yeah

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…

[htyfn1231101 (Xalanawer)]

It didn’t work for me
There is outdated information written there. Or am I doing something wrong?

[Doomcolp (dxxmed)]

Do you have Third Party APIs enabled in your game’s settings? If you do, then gimme a second to do some research

[htyfn1231101 (Xalanawer)]

I need replace info only used HTTP service

[Doomcolp (dxxmed)]

I mean Allow HTTP Requests in your game’s settings mb

[htyfn1231101 (Xalanawer)]

Yea, i already enabled it. What i can do?

[Doomcolp (dxxmed)]

Hm well just gimme a few minutes to do some research and I’ll reply when i have it

[Doomcolp (dxxmed)]

Really sorry for the 3 hour wait cuz I was at school typing this and still am but I found sum stuff

HttpService | Documentation - Roblox Creator Hub

and

Method: spreadsheets.values.append  |  Google Sheets  | ...

---

But I’m pretty sure you just send a POST request here to this URL
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append

and you uh just go from there

also, I’m sure you add what you wanna post in the body section

-- EXAMPLE CODE
local url="toolazytotype"
local contentType = Http:RequestAsync({
   ["Url"] = url,
   ["Headers"] = {
      ["Content-Type"] = "application/type"
      ["Body"] = {
         ["values"] = {["Example"] = "Ex"}
      }
   },
})

and idk if the above works so yeah. Oh and if it does, make sure to check if the response was a success

[htyfn1231101 (Xalanawer)]

Its really helps me! Tysm for help!

[Doomcolp (dxxmed)]

Ya sure? I’m not sure if u tried it cuz you responded kinda fast but maybe idk lol

[htyfn1231101 (Xalanawer)]

I think you helped me anyway. You’re doing great!
I’m just starting to learn this and these links and your tips will help me a lot!