How to work speadsheet extension

[Me_Okkoma]

How to get all data from spreadsheet

[Techno_Vedang]

Which extension are you using?

[tanishraj]

Try Spreadsheet component…

[Me_Okkoma]

In build component? I want to know how to get all data from spreadsheet to app. Please give blocks image

[tanishraj]

@Me_Okkoma

In build component?

yes

You’ll have to generate API Endpoint for this component on Google Apps Script for free. Watch this tutorial for that…

How to Get API Endpoint of Spreadsheet Component | Niotron Buidler

After generating api endpont, Just use Get All Data blocks, It’ll sync data of all sheets of your spreadsheet and allow you to use get blocks offline as well.

[killer]

If you still need help then contact us on telegram

[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 -