Read Google Sheet WITHOUT API

Hello All,

I am trying to read from a google sheet in a way that I would read from Excel. Due to confidentiality, I do not have access to API,nor can it be installed. I need a work around.

I am successfully getting to the sheet I need to via an input tool, but then reading the data on the sheet in order to group it into a For Each activity is proving troublesome, as I can’t figure out how to read the data as I would if it were an excel sheet.

Downloading the sheet to the desktop is not an option.

Any advice?