Extracting content of a single cell in Google Sheets into a text box

MIT App Inventor Help
2

This is the easiest way

  1. Set your spreadsheet to Public, anyone on the internet can find and view
  2. Drag out a web component
  3. Blocks as follows

image
image842×378 36.9 KB

Look in the address url bar when your spreadsheet is open to get the spreadsheet ID and the gid ID (number of specific sheet)

Just calling a single cell returns a value in responseContent

2 Likes