Download data spreadsheet from kodular

[Bayu_adit]

i have data in google spreadsheet and i will download spreadsheet from kodular, anyone can help me show this code block? thanks

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

try like this, so you will get your google sheet values into csv manner

https://docs.google.com/spreadsheets/d/(your spreadsheet id)/export?format=csv

[Bayu_adit]

failed to use it

this is my code block, would you correct my code

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

no no… i said to download the content only. actually what you wanna achieve? need to download the google sheet as excel sheet in to your device or as pdf?

[Bayu_adit]

i want download file as excell

[dora_paz (Dora)]

Try to set download url to https://drive.google.com/uc?export=download&id=Your_id_here and see if it works for you. File will download as xls

[Bayu_adit]

okee i will try it

[dora_paz (Dora)]

Example blocks, spreadsheet is set to shareable (anyone with link)

[Bayu_adit]

failed download

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

have you enabled the share option the google sheet?

[sugarlesscreator]

https://docs.google.com/spreadsheets/d/1MnxQijJek3qPQOHxJuZGhhAljc4WyKCL86iLlzxKEdk/export?format=xlsx

Edit url After id to export link my sample export?format=xlsx

[Bayu_adit]

[Bayu_adit]

still fail

[Bayu_adit]

thanks, its work