Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Load data from google sheets - oauth2.0 error

petr__
7 - Meteor

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

 

petr___0-1612192921356.png

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/t...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Create-Google-API-Credential...

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

 

but it doesn t work

 

many thanks for ideas !!

 

 

 

3 REPLIES 3
TrevorS
Alteryx Alumni (Retired)

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

Community Moderator
petr__
7 - Meteor

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
Alteryx Alumni (Retired)

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!

Community Moderator
Labels