MIT App Inventor Community

Get a cell value from google sheet

MIT App Inventor Help

google-sheets

ABG December 3, 2020, 7:33pm 6

So this is too much for you?

HOWTO: Get A Range from a Google Sheet Tutorials and Guides

Assumes your google sheet has permissions set to "anyone with the link" as a minimum BLOCKS [blocks (9)] SCREEN [image] 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:

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled