Google sheets Reader node read automatically a google spreadsheet file from Google Drive?

KNIME Analytics Platform
8

Okay :thinking:, I will give it another go and describe every step (in a lot of detail for future reference):

How to authenticate and use the REST nodes for Google Drive using this workflow: google_sheet_and_drive_rest_api.knwf (255.2 KB)
EDIT: Correct workflow: google_sheet_and_drive_rest_api.knwf (255.2 KB)

  1. Create a new project in Google APIs
  2. Activate the Google Drive API here
  3. Create an OAuth2 client here
  4. Grab the JSON for that client using the little download button on the far right side (look for this:image)
  5. From the JSON get the necessary credentials for the authentication metanode. These are the client_id and the client_secret.
  6. Put the client_id into this URL:
    https://accounts.google.com/o/oauth2/v2/auth?client_id=<Your_Client_ID>&redirect_uri=urn:ietf:wg:oauth:2.0:oob&response_type=code &scope=https://www.googleapis.com/auth/drive.metadata.readonly
  7. Copy this URL to the browser of your choice and follow the instructions
  8. Copy the authentication token to you authentication metandode.
  9. Make sure that Refresh token is not selected.
  10. You should now be able to execute the first three nodes.
  11. From the third node you will receive the refresh token through the output table.
  12. Copy the refresh token to the first metanode and select Refresh token. This way your authentication will renew as long as you don’t revoke access to your account via the Connected Apps Settings
  13. Now the workflow should be executable.

This might be way to detailed, but if others have the same problem this will help them as well. I really hope it works now, I tried this procedure multiple times and it worked for me.

4 Likes