Assumes your google sheet has permissions set to "anyone with the link" as a minimum
gsGetARange.aia (3.0 KB)
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