Display a sheet2 as a csv file in google sheet

[Lourdes_Filipina_Uycoque (LFCU)]

This post was flagged by the community and is temporarily hidden.

[dora_paz (Dora)]

See here

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

Picture taken from https://ai2.metricrat.co.uk/

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

Update:
My excel sheet

If i follow this pattern-1,

I will get result in my app as bellow

If i follow this pattern-2,

I will get result inmy app as bellow…

Note: If you use range you will get particular rabge of cell value only. If you do not use any range then whole shet value will appear…

But you need to give minimum permission for your gsheet to viewer to all as below.

.

[dora_paz (Dora)]

@Lourdes_Filipina_Uycoque

how to display sheet 2 in csv format using google sheet

@Still-learning “gid” is needed