KNIME Google Authentication API Key Walkthrough

KNIME Analytics Platform
1

Hello, noticing there’s a few threads on KNIME community that are related to KNIME Google Authentication node leading to an error.

" Sign in with Google temporarily disabled for this app "…

This app has not been verified yet by Google in order to use Google Sign In…

So i tested it and…

38%20PM

After reading a ton of community threads, I realized I needed to begin using the API Key node, and I need to be able to repeat the setup on my computer, as-well as client computers…

Will admit, I got confused by all the threads and blogs online related to setting up Google APIs…

So I documented every step with screenshots, which helps with adding Google Sheets API, Google Analytics API, and Google Drive API, in a walkthrough designed for business users who need an end to end walk through. Posted here - KNIME Google Authentication API Key.

Reason for blog - noticed the “querying google analytics” post might be a little out of date, as these nodes look like a previous install and I’m new.
image

Here are the core threads that helped me dig deeper, thanks in advance for any future feedback on this thread to help future developers implement this solution in production.

Hope the walk through helps others utilize Google Sheets and Google Analytics via Google Authentication API Key. Used the walkthrough twice, both successful usages in KNIME.

Great work knime team, thanks for helping unlock this data source. I’m helping a customer who does quarterly reports to 4 web customers, they get CSV google analytics and spreadsheets on their desktop, then push that to a pdf file. They print this file, walk it to the business, and discuss their marketing campaign success. Now they can give them data whenever they need data. This will change the way these companies do business. Going from 4 refreshes a year to 365…

They only do quarterly reports because it takes so long for them to get all the data together… Now it’s instant. Game changer

Happy friday, coffee ftw.

Best,
Tyler

7 Likes
2

@Tyler,

This is great! Thank you for sharing…it is very helpful. Do you know if this would also work when working with Google Big Query?

Thanks,
Haystack

1 Like
3

@Haystack, yes I believe it will work with Google big query. During the “API Library” walk through, replace 1 of those 3 APIs with the Google Big Query API.

Found in library.

29%20PM
29%20PM979×964 60.8 KB

4

Nice one @Tyler!
Just modified your post with right link for last topic - Google Authentication Error :wink:
Ivan

1 Like
5

Thank you @ipazin, I appreciate the extra help.

1 Like
6

Hi,

Is it the OAuth consent screen need it ?
I have configured in the past without that

Thansk !

1 Like
7

@Tyler thanks for the tutorial. I have a new issue. I had to Restore mi PC the last days and when I tried to run my workflow again, the Authentication API Key and the Google Sheet Connetion ran, but when I try to read a Sheet the node at the configuration says “Could not retrieve spreadsheets. Check connection.”, but The Autentication and Connection nodes are green. What sould I do? Tanks in advance.

1 Like
8

If you restored your pc, did you download the p12 file again? Otherwise your authentication won’t be possible, and that could be the issue. Hard to say without looking at the workflow and talking to you about what’s happening.

best,
T

9

Made a new project, skipped oauth, seems to be not necessary based on latest setup. A bit of oversight on my behalf, will go back and update blog when i get time away from client work.

Best,
T

2 Likes
10

Yes Tyler is exactly right - must have the p12 key downloaded to work.

2 Likes
11

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.