How to work speadsheet extension

How to get all data from spreadsheet

1 Like

Which extension are you using?

Try Spreadsheet component…

1 Like

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


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

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.


1 Like

If you still need help then contact us on telegram

1 Like

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 -