google analytics-cant get ID, secret or refresh token

HI,

I am having to redo google client id, secret and refresh token in my google analytics workflows as my google user ID was helpfully deleted by my IT department.

Anyway , i am using the help pages on the community, and they seem to bear little relation to the pages i am seeing on the screen. I am guessing this MIGHT be because google has changed things since they were written.

the main one is this, https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-How-to-Guide-to-Google-Analytics/ta-p/15137

I would be very grateful if someone could tell me how on earth to do it.

donation to the charity of your choice!

Google Analytics

Accepted answers

SabrinaCB

Hello @markstephens ,

Thank you for your perseverance. (And thank you @BrandonB for helping!) You are correct in that Google has changed various times their console and how credentials are created. The application type should now be "Desktop App". This is the most up to date article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-retrieve-the-Client-ID-and-Secret-code-from-the-Google/ta-p/545864

If you want to learn about the new Connection token functionality you may also want to review this article as this functionality allows you to get less refresh tokens from Google:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-use-the-quot-Connection-Token-quot-for-the-Google-Sheets/ta-p/565533

Lastly please do not hesitate to contact Alteryx Support. We would be happy to help with using the Google Analytics Connector.

Have a great week,

Sabrina

markstephens

Eventually i had a three way teams call with an alteryx guy, david thorpe , and one of our ICT guys who is the webmaster and between us it was all fixed.

The alteryx guy was v helpful.

but not thing i want to go through again! it straddles knowledge of alteryx, google, web development etc i just clicked when i was told to!

i'll click as solved,

cheers

Mark

All comments

BrandonB

Hi @markstephens

Did you end up getting this figured out? This article may help a bit more: https://community.alteryx.com/t5/Alteryx-Designer/How-to-enable-Google-Analytics-APIs-for-OAuth2/ta-p/581440

markstephens

Hi,

thanks for checking up on this, and no i did not.

the screen shots eventually differ from what i see on my screen, so eventually i just lose the will to live and give up

i have zero idea what OATH and developers consoles are, so i am just blindly clicking as I have no sense of what is happening on the screen or is supposed to be happening, so i dont know what is "wrong" to make it right!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335