# KNIME Google Authentication API Key Walkthrough **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [January 17, 2020, 8:06pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512 "2020-01-17T20:06:21Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Tyler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tyler/32/5220_2.png) [@Tyler](https://forum.knime.com/u/Tyler)\ **Post date:** [January 17, 2020, 8:06pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/1 "2020-01-17T20:06:21Z")
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](https://forum-cdn.knime.com/uploads/default/original/2X/a/ad269e578f2d4ec019b6f915aae8ff11e40ff25f.png) 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](https://knime.dev/google-api/knime-google-authentication-api-key/). Reason for blog - noticed the “[querying google analytics](https://www.knime.com/blog/querying-google-analytics-in-knime)” post might be a little out of date, as these nodes look like a previous install and I’m new. ![image](https://forum-cdn.knime.com/uploads/default/original/2X/a/a4d25fb27d5a26d73c09fe85d8bc0c812594538a.png) 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. - [Problems with Google Query](https://forum.knime.com/t/problems-with-google-query/7065) - [Google API](https://www.knime.com/forum/knime-general/google-api) - [Need help connecting google reader sheet node](https://forum.knime.com/t/need-help-connecting-google-sheets-reader-node/15362) - [Google Authentication Error](https://forum.knime.com/t/google-authentification-error/20022) 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 ---
**Author:** ![Haystack](https://forum-cdn.knime.com/user_avatar/forum.knime.com/haystack/32/36583_2.png) [@Haystack](https://forum.knime.com/u/Haystack)\ **Post date:** [January 17, 2020, 9:10pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/2 "2020-01-17T21:10:49Z")
@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 ---
**Author:** ![Tyler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tyler/32/5220_2.png) [@Tyler](https://forum.knime.com/u/Tyler)\ **Post date:** [January 17, 2020, 9:22pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/3 "2020-01-17T21:22:18Z")
@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](https://forum-cdn.knime.com/uploads/default/original/2X/8/867500fc64b7b5c225802f05fe657f9b819a02d9.png) ---
**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\ **Post date:** [January 20, 2020, 10:37am UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/4 "2020-01-20T10:37:22Z")
Nice one @Tyler! Just modified your post with right link for last topic - _Google Authentication Error_ 😉 Ivan ---
**Author:** ![Tyler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tyler/32/5220_2.png) [@Tyler](https://forum.knime.com/u/Tyler)\ **Post date:** [January 22, 2020, 2:20am UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/5 "2020-01-22T02:20:47Z")
Thank you @ipazin, I appreciate the extra help. ---
**Author:** ![geppopompo](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/a6a055/32.png) [@geppopompo](https://forum.knime.com/u/geppopompo)\ **Post date:** [February 25, 2020, 10:41am UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/6 "2020-02-25T10:41:38Z")
Hi, Is it the OAuth consent screen need it ? I have configured in the past without that Thansk ! ---
**Author:** ![lsandinop](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/53a042/32.png) [@lsandinop](https://forum.knime.com/u/lsandinop)\ **Post date:** [February 27, 2020, 7:02pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/7 "2020-02-27T19:02:11Z")
@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. ---
**Author:** ![Tyler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tyler/32/5220_2.png) [@Tyler](https://forum.knime.com/u/Tyler)\ **Post date:** [March 13, 2020, 9:32pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/8 "2020-03-13T21:32:03Z")
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 ---
**Author:** ![Tyler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tyler/32/5220_2.png) [@Tyler](https://forum.knime.com/u/Tyler)\ **Post date:** [March 13, 2020, 9:33pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/9 "2020-03-13T21:33:12Z")
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 ---
**Author:** ![webstar](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/w/a6a055/32.png) [@webstar](https://forum.knime.com/u/webstar)\ **Post date:** [June 19, 2020, 6:26am UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/10 "2020-06-19T06:26:10Z")
> [@lsandinop](#): > > e. 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. Yes Tyler is exactly right - must have the p12 key downloaded to work. ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [December 18, 2020, 6:35pm UTC](https://forum.knime.com/t/knime-google-authentication-api-key-walkthrough/20512/11 "2020-12-18T18:35:18Z")
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.