🟩 HOWTO: Get A Range from a Google Sheet

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

3 Likes

(added to FAQ)

2 posts were merged into an existing topic: Perform a search from my app in a list of name in Excel and update

A post was merged into an existing topic: Perform a search from my app in a list of name in Excel and update