Do any of these enable a drop dead simple web api to access the spreadsheet?

For example, simple urls that could GET the data for a sheet, a row, selected area, etc. This could even be useful for non-developers.

Last time I checked MS made made oauth part of accessing sheets in excel, which seems to add too much addiotnal complexity. It seems like a no auth option would be useful, and even for protected spreadsheets the experience could be much less complex.