Load data from google sheets - oauth2.0 error

Question

Hello everyone,

I am trying to load data from google sheets via OAuth 2.0...I enable drive api and enable sheet api, also I have credentials created (client ID,client secret)

but when I copy and paste it (beware to typo) I got following error

any idea how to fix it? In google environment is everything enabled

I used these link for 'How to do it'

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-How-to-Guide-to-Google-Sheets/ta-p/20354

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Create-Google-API-Credentials/ta-p/11834

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-google-sheets/m-p/152071#M8063

but it doesn t work

many thanks for ideas !!

TrevorS · Answer

When you try to navigate to the direct Google Sheets page it throws an error?

Can you please share the error text as well as a screenshot?

Thanks!

petr__ · Answer

Hello @TrevorS

Yes I double check all permissions and api drive and api sheet is enabled..when I go directly to the page it cause an error,

i am not expert on API, but do you have any ideas?

TrevorS · Answer

Hello @petr__ 
Did you try to access the link within the error message?
This appears to be related to an unauthorized visit issue and may require updating on Googles side.

Thanks!
TrevorS