Assumes your google sheet has permissions set to "anyone with the link" as a minimum
BLOCKS
SCREEN
AIA
gsGetARange.aia (3.0 KB)
URL
https://docs.google.com/spreadsheets/d/\
1pCRdJZSTFma8-RoXqHz6I5Z_xqcNAbi95r8cSGtZzyE\
/export?format=csv\
&gid=0\
&range=A1:A11
If you put this in a browser address bar it will download a csv file.
If you want to keep your sheet private, then you will need a web app to help you, see here:
Query Any Google Sheet with a Web App