Best Practice for Google Account Authentication in KNIME Hub Data App

Dear KNIME Community,

I’m developing a data app on KNIME Hub that needs to retrieve a Google Sheet file, and I’m looking for the most user-friendly and secure authentication method.

Specifically, I want to guide a KNIME Hub user (i.e. consumer) through:

  • Authenticating their Google account
  • Granting necessary permissions to access their Google Sheets
  • Retrieving a specific spreadsheet

What would you recommend as the most straightforward approach? I’m considering options like:

  • Google Authenticator node
  • OAuth 2.0 flow
  • Credential management within the app
  • Any other methods you’ve successfully used

Any insights, workflow examples, or best practices would be greatly appreciated.

Thank you,

Gio