Add/Update data to Google sheets

[Jason_Samuels]

Hi

I would like to update or add data from an app i am building in Thunkable x. The user will input data on the app with textboxes and with the press of a button the data will be added or updated on a google sheet.

You can update or add data via Cloudstitch but i would like to know if it is possible to do it without cloudstitch (i constantly have access/security issues with Cloudstitch) by creating a WebApi in Google Sheets.

I have created a WebApi and done the follwoing so far

But i don’t know what i need to do next. How do i add the parameters? And the text i want to add?

In classic Thunkable you can do something like this,

Any help will be much appreciated.

[cttricks]

You can update or add data via Cloudstitch but i would like to know if it is possible to do it without cloudstitch (i constantly have access/security issues with Cloudstitch) by creating a WebApi in Google Sheets.

Upload user details to Spreadsheet with/without Cloudstitch

[ Solved Cloudstitch 502 Bad Gateway ]Now Get Cloudstitch Spreadsheet API Endpoint Easily

Hello everyone !! Few days ago i have posted a solution on How to Store Users data to Spreadsheet without using Cloudstitch, Airtable or Any other API But today i’m going to tell you how you can fix Cloudstitch 502 Bad Gateway error easily Follow these Steps : Step 1 : Go to Cloudstitch Dashbord { https://cloudstitch.com/dashboard } & Create a new project. [Screenshot%20(176)] Note : You can Also use old one instead of new! Step 2 : After creating the project [ here i’m creat…

or watch this tutorial video : Store users data to spreadsheet without using Cloudstitch, Airteble or any other API

/Ct tricks

[Jason_Samuels]

Hi

I managed to get Cloudstitch to work but now i would like to know how do i use the API in Thunkable X. Do i create an API? Or should i use the spreadsheet component? And how should my blocks roughly look like?

Thanks,

Jason

[Mark]

Jason,

Have you thought about using Airtable, which is supported by our Spreadsheet component?

-Mark

[Jason_Samuels]

Hi

Thank you i managed to to get Airtable to work when adding records but what blocks do i use to get data from airtable and present it in a Text Input or Label?

Jason

[Choofa]

Hi, you just use Get function.
Here’s an example I just made quick, sorry for the many blocks, but X in really unstable

[actech]

Hi,

To access Google sheets, you can use php (or another server technology or services with API, that knows how to work with them). But this way is quite complicated and now it is better to use AirTable, as it is advised here.