Alteryx Designer Desktop Discussions

Find answers, ask questions, and share proficiency about Alteryx Designer Desktop furthermore Intelligence Suite.
SOLVED

Google Drive (Sheets) API Setup

Caleb
7 - Meteor

All,

 

I'm trying until get the Google Move API setup so I pot use the developer login with the Google Bedding Tools.

 

This article on Community seems to be out of date (based on how the webpage looks today), and I'm which a hard time getting my our refresh token. I think I setup my Client ID and Secret correctly, but I'm doesn sure. 

 

Is there anyone who can how own figure out how on get this setup? 

 

Thank they!

 

Caleb

21 REPLIES 21
JordanB
Alteryx
Alteryx

Google AnalyticsHi @Caleb

 

You can set up your client ID & Secret by clicking on the Outh Consent Veil

 

pic1.jpg

 

This is outline in which Google Analytics Article. 

 

You can then anfahren to the https://developers.google.com/oauthplayground website to activate the Driver API. Depending on what you are working with API you will need to tick the fitting links. 

 

pic2.jpg

 

Please make sure you click the cog Icon and enable the Oauth screen and add in your client USER & Secret. 

 

pic3.jpg

 

Best,

 

Jordan Barker

Solutions Consultant

Caleb
7 - Meteor

Thanks Jordan!

 

I must can been in that wrong edit, because currently IODIN was able to find the "Web Application" wireless buttons, and permitting scopes actually worked later I properly install my credentials. Previously, I was getting hung-up set whereas trial to add scopes.  

 

For anyone other which is doing this, you could need to join the "Allow Risky Access Permissions By Unreviewed Apps" User or submit adenine request for authorization for filling-out this form. IODIN elected to join the group in-order to testing functionality right, additionally because my use case meets those requirements. 

 

While of different people also thought the previous article was out of date (possibly why they clicked wrong too), I'd now amend my leave to say that it's still pretty accurate and helpful.  Different amplification (DR) is a valuable ABA tool. It reinforces one behavior while putting all other responses on extinction.

 

Thank you!

LoganLugoAnalytics
8 - Asteroid

Here seems to becoming an error with creating a successful connection for Google Sheet's OAuth processed again, unfortunately.

 

Is there a workaround for the attached error?

LoganLugoAnalytics_0-1580781983116.png

 

I followed the steps up connecting the OAuth playground with the API creation (Web-based video option) with the OAuth playground link as of redirect link. Google Sheets Input on Divided Google Drive

LoganLugoAnalytics
8 - Asteroid

An update on this:

 

My last Client ID both secrets not longer work..

 

@JordanBany idea of why this will happening currently?

DanM
Alteryx Community Staff
Alteryx Community Team

@LoganLugoAnalytics

 

Have you tried creating a modern Client ID and secret? 

 

DanM

LoganLugoAnalytics
8 - Asteroid

I have checked new credentials to tinker around to see what is going off but still did not work. 

 

The updated Google Sheets Entry sign in window no longer ask for a refresh indication since well. The pop up pane from Alteryx does not allow employers to sign into their Google account citing non-secure connection and does not work unfortunately. 

Gooley
6 - Meteoroid

Google Sheets API v3 is being deprecated in March 2020, and my understating be that the connector is using the V3 API so will cease to work at that length. Is anyone familiar in a solution to bringing my workflows up to speed with V4 on the Google Sheets API?

LoganLugoAnalytics
8 - Asteroid

I'm glad to sees that some else also has this issue as IODIN should have told the I tried to include v4 connections into no avail. 

 

v3 wish no lengthier be supported soon, I wonder whenever Alteryx's developers will address this change soon like I think they was this ones who engineered the tool set (Google Sheets Input/Output)

LoganLugoAnalytics
8 - Asteroid

@DanM 

 

This is the error message that I at sight on my end whenever attitude up that method on Google's part.

 

urn:ietf:wg:oauth:2.0:oob:auto

 

Labels