This is amazing! I can get around the lack of support for Google Sheets for Education.
I set the sharing permissions on the Google Sheet to “anyone with the link can view” and used these blocks to format the JSON response correctly, display it in a Text Input so it can be copied and pasted into Best JSON Viewer and JSON Beautifier Online, and then parsed the formatted response to get the value in row 2, column 1 and in row 3, column 2 (subtract one from the row number you want, assuming you have header names for your columns):
And these blocks, when added right after the set label's text blocks above, will get the first and second column values from each row and join them as a list item and then display all rows in a list viewer:
