📑

Get Sheet

This option will let you get the data of your entire sheet of your spreadsheet . Below it's explained how you can do it too...
To get list of Sheet present in your Spreadsheet, you will need the GetSheet Blocks
We just have to add the block to any event, am using a button. You can also use it at initialize or at any other event
This is how the block will look like
Now we navigate to the GotSheet blocks
We will first check if the response code is 200 or not, if it’s not 200 then we will inform the users that there is some error
If it is 200 then we proceed, am using a global variable here, you can use any other component as well. Global variable will be initialized with make empty list block
This is how our block should look like
This completes the process of getting the data of entire sheet with the CloudsheetsClassic Extension
This data will be in form of Json, you can extract rows and columns from this json by using the extract column or extract row blocks
Documentation by Team Cloudsheets