Get column from Google Spreadsheet with extension

[shashank (Shashank Gahtori)]

Hello.
I want to get a column from my google spreadsheet. But I am not sure how to do it.
I have tried both ways-
Through Web
Through extension

If anyone knows, please tell.

[_FTTX (Ali Abo Wardi 0 iraq)]

How to use Google Spreadsheet without any extensions?

karar (1).aia (702.2 KB) https://script.google.com/d/1qQINxtJjSyGn4omZvbXNeyv8Tb6-EHrBKUe5j8fd3dfkcDomfGB6ikHM/edit?usp=sharing

[_FTTX (Ali Abo Wardi 0 iraq)]

Here is the aia project, the kocl script, and also the table that you can test and work on. It is also open that anybody can see

[dora_paz (Dora)]

See examples

METRIC RAT AI2 - Use gviz to get and query google sheet data

or

METRIC RAT AI2 - Use gviz to get or query PRIVATE google sheet data

[Still-learning (1-2-3-4...)]

can you share us what you have tried…? Let we correct where the mistake you commit…

[shashank (Shashank Gahtori)]

Hello.
What is tbQuery text in the blocks in the first image in the link?

[TimAi2 (metricrat)]

That is a textbox where you will enter your query to send to the spreadsheet, for example:

SELECT D

would return all the items in Column D

[shashank (Shashank Gahtori)]

When I click on Students List Button, I have set it to initialize ColinTreeListView, but nothing happens and the app freezes.

These are the blocks:

[Still-learning (1-2-3-4...)]

Two times you are using same web url but in the get block alone is getting different. Pls see here

Also no need to use this block at here

[TimAi2 (metricrat)]

@Still-learning

Also no need to use this block at here

It is recommended to uriEncode the SELECT statement for more complex queries, therefore it is best to include it by default.

[Still-learning (1-2-3-4...)]

Please use list from CSV table to text at here and try. Try to remove split text block too

[shashank (Shashank Gahtori)]

I tried List View with Image to get the data from the Spreadsheet, but it only shows 4 records and the space between the items is very much.

Here is the screenshot of the spreadsheet:

Here are the blocks:

Here is the app screenshot:

[shashank (Shashank Gahtori)]

@Still-learning

Please use list from CSV table to text at here and try. Try to remove split text block too

I tried as you said. It solved the gap problem, but now I am getting ( ) brackets and no image.

Here are the blocks:

And here is the result:

[Still-learning (1-2-3-4...)]

Use for each item block and in the index use number.
For name index as 1
For image index as 5

[Still-learning (1-2-3-4...)]

see my gsheet , blocks and app response

https://docs.google.com/spreadsheets/u/1/d/<spreadsheet ID>/gviz/tq?tqx=out:csv&sheet=Sheet1

[Still-learning (1-2-3-4...)]

@shashank , You can avoid multiple blocks . Just by using minimum blocks we can achieve our need.

[sugarlesscreator]

Wow… 1303 rows…
Try this aia gsheetcolmn.aia (9.3 KB)
fill in your spreadsheet_id and see the results.