Read data from Google Sheets

Read data from Google Drive

Authenticate your Google account via login

Step 1: Drag the "Google Authenticator" node into the workflow.

Step 2: Click on the node to open the configuration window. Specify the "Scopes of access" to determine the level of permission you give (e.g., read-only or full access). Add scopes if needed (e.g., the "Google Authenticator" node allows to define access scopes for multiple Google services at the same time).

Step 3: Under "Authentication", click on "Login". A browser tab will open which lets you sign in to your Google account. Execute the node to finish the authentication.

Read data from Google Drive using Reader nodes

Step 1: Drag the appropriate Reader node into the workflow based on the file type.

Step 2: Click the + on the left side of the node. This will add a blue color port. Connect this port to the output of "the Google Drive Connector" node.

Step 3: Click on the node to open the configuration window. Under "Source", specify the file path. Click the yellow folder button to browse your files. Select "Google drive" to access data from your Google Drive.

Connect to Google Drive

Step 1: Drag the "Google Drive Connector" node into the workflow.

Step 2: Click on the node to open the configuration window. Specify the "Working directory" (click the yellow folder button to browse your Google Drive).

Step 3: Click "Apply" and execute the node.

Step 1: Drag the "Google Sheets Connector" node into the workflow and connect it with the output port of the "Google Authenticator" node.

Step 2:Execute the node to establish the connection with the Google Sheets associated with the user's account.

Step 3: Connect the "Google Sheet Reader" node to the output port of the "Google Sheets Connector" node. Click on the node to open the configuration window. Select the "Spreadsheet" and "Sheet". Execute the node to read the Google Sheet.

Read Data: From Google Drive and Google Sheets

This workflow demonstrates how to read data from Google Sheets and data files from Google Drive (.xlsx, .csv, .txt).

Note: Follow the steps described below to connect to your own data or upload the sample files provided in the data folder in "01 Read" to your private Google Drive.

Workflow complete!

Keep the momentum going by exploring Just KNIME It! on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.