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