Forum Discussion

emiagin's avatar
emiagin
Copper Contributor
May 29, 2023

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...
excel
Excel for web
peiyezhu's avatar
peiyezhu
Bronze Contributor
May 30, 2023
https://developers.google.com/sheets/api/reference/rest?hl=ru

I know oData is a restful api but I can not open url like above from google.com because of the network forbidden.


https://techcommunity.microsoft.com/t5/excel/post-api/td-p/3762681

Here is sample api service without key.

you can try it with webservice formular or oData to test.
http://e.anyoupin.cn/?s2=select%20%20*%20from%20Second_to_last_value_from_table_with_condition

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get
if possible,post the contents of above url,we can do research together.
emiagin's avatar
emiagin
Copper Contributor
Jun 01, 2023
I think i just can't get it with google sheets, it need using google oauth, it's hard for me 😞 i found this problem on stack overflow:
https://stackoverflow.com/questions/71818373/signing-in-to-google-sheets-from-excel-power-query
I need to somehow connecting by using oauth or it will be network forbidden...