YouTube data

[calloni]

Hello community

Does anyone have a workflow to connect to YouTube metrics data that could share?

Also if you went through the Google API hassle for generating credentials, could you share also some step-by-step procedure for that?

Thanks in advance

Rodrigo

[BrandonB]

 

@calloni you can find the YouTube API documentation here: https://developers.google.com/youtube/v3/getting-started

I believe that it uses the same Oauth flow that other Google tools use so you may be able to copy the Oauth macro that exists within the Google Analytics tool. This will return an authorization token which you pass into a subsequent download tool to pull the YouTube data from an endpoint. 

[BrandonB]

https://community.alteryx.com/t5/Alteryx-Designer/How-to-enable-Google-Analytics-APIs-for-OAuth2/ta-...

Here is the information for the credentials

[calloni]

Hi @BrandonB 

Thanks for the reply. I wonder how can I "open" the Google Analytics tool to get the Macro out of it? I see you have it as a yxmc file in the image you shared.

Thanks in advance

Rodrigo

[BrandonB]

You can drop a Google Analytics tool onto the canvas, right click it, and "Open Macro". This will show you the underlying tools that make up the connector. 

 

[calloni]

Hey @BrandonB 

Just to give an update. The credentials stuff worked like a charm and after I went through the Google API hassle to get Client ID, Secret and Refresh Token (this is tricker) I got the flow working.

I also got some API URL syntaxes from the YouTube API page and I got some data into Alteryx now.

I will leave this tread open because I am going to work on this workflow so I can share it to community at the end.

Thanks a lot!!!

Rodrigo

[BrandonB]

Great work @calloni!

[calloni]

Finally I was able to finish the Youtube connector so I am sharing with the community (and maybe Alteryx?)

@BrandonB how can I make this available for more people?

Any suggestions or ideas to improve, please let me know 🙂

Rodrigo

[BrandonB]

Nice work! Rather than zipping it up in a zip file, you may want to save the main workflow as a packaged workflow by going to Options -> Export workflow from the main workflow. That way you can package all of the dependencies up into a yxzp so that when someone else opens it up it will maintain all of the macro references. Otherwise it will look like this:

 

[calloni · Accepted solution]

OMG that's really bad. Of course Alteryx had a solution for that lol. I am impressed the amount of times I think "oh how can I do that" and then boom answer is already in product.

Does this look better now?

Rodrigo