How to Get and Update specific Cell value in google spreadsheet?

[Technical_Land]

Can any one here please guide me how to Get or update Cell data in google spreadsheet.
please help somebody…!!!

[iaditya_nanda]

You can use Google spreadsheet extension

[Technical_Land]

yes i get that much but i dont know how to use it can you please help me how to link my app with my spreadsheet please

[tanishraj]

You 1st have to generate API Endpoint, and then you can use the spreadsheet component to CRUD data. Here are two tutorial videos on this component.

1. How to generate API Endpoint

How to Get API Endpoint of Spreadsheet Component | Niotron Buidler

2. How to CRUD data

Full Spreadsheet Totorial || Niotron || .AIA File || In Hindi

[Nkleet]

I have followed tutorial, but my sheet is not working. Also, I clicked on test link, that gave error too. Which details shall I submit?

[Spicy_Topics]

What error you are getting? Did you shate yhe sheet with minimum viewer permission?

[Nkleet]

i am facing issue with Spreadsheet. Actual i wish to add switch functionality to my app, so that i can enable or disable app. Here are my blocks. tell me where i am going wrong

Here is spreadsheet screnshot

Script -