Forum Discussion
Import data from google sheet using api key
Hi! I tried to connected my google sheet and excel sheet. The problem is in permitions. My google sheet have not viewed by anyone and i should use some authentication. I choose api key and created th...
api key
What is OData and relative api?
Does the google sheet provide api to acheive data by formula?
Any official document available about this api?
I found this documentation about OData:
https://learn.microsoft.com/en-us/powerquery-m/odata-feed
Looks like i have wrong serviceUri link... I should use this one i think:
https://developers.google.com/sheets/api/reference/rest?hl=ru
I'll try this format, hope it'll work:
/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
https://learn.microsoft.com/en-us/powerquery-m/odata-feed
Looks like i have wrong serviceUri link... I should use this one i think:
https://developers.google.com/sheets/api/reference/rest?hl=ru
I'll try this format, hope it'll work:
/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo