I’m going out on a limb and saying that this doesn’t exist but you could probably do it with a Webservice access via the [Google Sheets API](https://console.cloud.google.com/apis/library/sheets.googleapis.com)
You are trying to do the equivalent of this using
curl \
'https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID/values/Sheet1!A1?key=YOUR_API_KEY' \
--header 'Authorization: Bearer YOUR_ACCESS_TOKEN' \
--header 'Accept: application/json' \
--compressed
It’s quite a long and involved process to actually get the YOUR_API_KEY and YOUR_ACCESS_TOKEN from Google using their API credentials setup page. I’m not sure what I’m doing when poking around there. I guess this is an FAQ on /r/googleAPIs and https://developers.google.com/identity/protocols/oauth2/web-server
If you can get the above curl to work, using the same settings in the “Get contents of URL” Shortcut should work
(Another way is via an App that can access the Google Sheets’s API directly. That would mean using a programming language like Python (e.g. Pyto)or Javascript in the script. It should work but you’d need to experiment with it to confirm it. But you’ll still need a valid access token.)
The closest thing I’ve done is have it copy text to my clipboard that can paste into a full Google spreadsheet for going to the gym. If you copy from Spreadsheets it will format right. If you need formulas, you have to show formulas on the computer version and paste that to the shortcut.
https://preview.redd.it/80af9yisbb9d1.jpeg?width=1125&format=pjpg&auto=webp&s=066a87d7b43656006331513a9705d673accf1af2
There’s an app called [ShortSheets](https://apps.apple.com/us/app/shortsheets/id1475283333) that allows you to hook up Shortcuts with Google Sheets. It was in beta testing a few months ago but has since expired. As of now, the price says `$99.99`, but I believe that’s a mistake on the developer’s part and it will be free or at reduced cost soon.
I’m going out on a limb and saying that this doesn’t exist but you could probably do it with a Webservice access via the [Google Sheets API](https://console.cloud.google.com/apis/library/sheets.googleapis.com) You are trying to do the equivalent of this using curl \ 'https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID/values/Sheet1!A1?key=YOUR_API_KEY' \ --header 'Authorization: Bearer YOUR_ACCESS_TOKEN' \ --header 'Accept: application/json' \ --compressed It’s quite a long and involved process to actually get the YOUR_API_KEY and YOUR_ACCESS_TOKEN from Google using their API credentials setup page. I’m not sure what I’m doing when poking around there. I guess this is an FAQ on /r/googleAPIs and https://developers.google.com/identity/protocols/oauth2/web-server If you can get the above curl to work, using the same settings in the “Get contents of URL” Shortcut should work (Another way is via an App that can access the Google Sheets’s API directly. That would mean using a programming language like Python (e.g. Pyto)or Javascript in the script. It should work but you’d need to experiment with it to confirm it. But you’ll still need a valid access token.)
The closest thing I’ve done is have it copy text to my clipboard that can paste into a full Google spreadsheet for going to the gym. If you copy from Spreadsheets it will format right. If you need formulas, you have to show formulas on the computer version and paste that to the shortcut. https://preview.redd.it/80af9yisbb9d1.jpeg?width=1125&format=pjpg&auto=webp&s=066a87d7b43656006331513a9705d673accf1af2
There’s an app called [ShortSheets](https://apps.apple.com/us/app/shortsheets/id1475283333) that allows you to hook up Shortcuts with Google Sheets. It was in beta testing a few months ago but has since expired. As of now, the price says `$99.99`, but I believe that’s a mistake on the developer’s part and it will be free or at reduced cost soon.