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]

@Jason_Samuels

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

http://community.thunkable.com/t/solved-cloudstitch-502-bad-gateway-now-get-cloudstitch-spreadsheet-api-endpoint-easily/45861?u=cttricks

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.