Hello,
I cannot seem to use a Developer Login for the Google Sheets Input tool. I followed the instruction found here exactly (multiple times), but always get the same error:
Does anybody know how to generate a refresh token that the input tool doesn't think is expired, even when it's entered merely seconds after creation?
Thanks.
Solved! Go to Solution.
Hi @rpaugh
When setting up in the Google Oauth Playground make sure that all of the below options are selected.
Remember to also add your ClientID and Client Secret into the setting using the cog icon in the top right side of the Oauth page.
You can then authorize the api and get the Refresh token.
Let me know how you get on!
Best,
Jordan Barker
Solutions Consultant
Thanks, Jordan. Turns out I didn't have the third option selected.
Hey @JordanB thanks for this thought out response. I triple-checked that I had all those scopes enabled and I am still getting an "Error Code 401: Unauthorized" message.
Pre-Emptive Edit: Ok, I actually quad-checked the original oAuth/Google Sheet help doc, and I always miss this, so I am leaving it here for posterity.
Make sure you click on the Gear icon in the top right page section and select "Use your Own Credentials" and input your Client ID and Client Secret into the corresponding input fields:
I'm also having the same issues as well, it worked perfectly fine until I picked up this project again and ran into the same 401 unauthorized error.
Any updates on possible fixes so far?
Hi @JordanB
I tried your settings ( all 3 API - Drive, Google Sheet, Spreadsheet) . I tried putting my client id and client secret in the settings too. Even then Access Token is showing 60 minutes access in the screen. How to avoid this 60 minutes counter.
Is the checkbox below this counter is going to help us from this 60 minutes counter?
what I want is that I should not be entering access token again and again in the configuration window and I should schedule it from my desktop too.
Please guide.
I have been strugglling with this since last 5 days now.
Rgds
Hi @rpaugh
Have you done it? Have you resolved this 60 minute recursive entry problem of the access token?
I have to enter Access Token every 60 minute in Alteryx. Please help me for the same in case you have done it .
What i have done :
1: selected all three apis : Drive, Google sheet, spreadsheet.
2: gear box : I have enterted client id and secret there already.
3. I have one refresh token and 1 acess token for 60 minutes now. How to use this for infinite time?
please help.
Regards
@arpit_tyagi Yes, I've done this. You just need to create a common break in your query logic and get a new token at that point. And you can accomplish this via an iterative macro:
In the macro itself, you place your callout to get a new access token and take in a new Google URL as the parameter. In my example, I passed in a parent folder Id and and retrieved a new access token when passing that folder's items back into the iterative macro to retrieve additional information: