Icon

03_​Read_​Data_​from_​Google_​Drive

Read Data from Google Sheets and Google Drive

This workflow demonstrates how to read data from Google Sheets and data files (Text, Excel and CSV) from Google Drive.






Read Data from Google Sheets Read Data from Google Drive Authenticate your Google Account via Sign inStep 1: Drag the "Google Authentication" node to KNIME AnalyticsPlatformStep 2: Double Click on the node to open Dialog box. In the"Authentication" tab Click on the Option "Sign in with Google" and anew tab will open in the browser. Use the browser to sign in. Step 3: Select the scope of the authentication and then click "Ok"and execute the node to finish the authentication. Connect to Google DriveStep 1: Drag the "Google Drive Connector" node to KNIMEAnalytics PlatformStep 2: Double Click on the node to open Dialog box. Select the"Working directory" using Browse Option. Step 3: Click "Ok" and execute the node Read Data from Google Drive using ReadernodesStep 1: Drag the appropriate Reader node based on the filetype.Step 2: Click on the 3 dots on the reader node and select "AddFile System Connection Port" option. This will add a blue colorport to the input of the node. Connect this port to the output of"Google Drive Connector" nodeStep 3: Double Click on the node to open Dialog box. Select thefile using the "Browse" option in "file" section. Click "Ok" andthen execute the node to read the file. Read Data from Google SheetsStep 1: Drag the "Google Sheet Connection" node to KNIMEAnalytics Platform and connect it with the output of "GoogleAuthentication" nodeStep 2: Execute the node to establish the connection with theGoogle Sheets associated with the user's account.Step 3: Connect the "Google Sheet Reader" node to output of"Google Sheets Connection" node. Double Click on the node toopen the dialog box. Select the "Spreadsheet" and "Sheet" andclick "Ok". Execute the node to read the Google Sheet. AuthenticateGoogle AccountSelect the Sheetthat has to be readConnect withGoogle SheetsConnect with Google DriveRead .txt file from Google DriveRead .xlsx file from Google DriveRead .csv file from Google Drive GoogleAuthentication Google SheetsReader Google SheetsConnection Google DriveConnector File Reader Excel Reader CSV Reader Read Data from Google Sheets Read Data from Google Drive Authenticate your Google Account via Sign inStep 1: Drag the "Google Authentication" node to KNIME AnalyticsPlatformStep 2: Double Click on the node to open Dialog box. In the"Authentication" tab Click on the Option "Sign in with Google" and anew tab will open in the browser. Use the browser to sign in. Step 3: Select the scope of the authentication and then click "Ok"and execute the node to finish the authentication. Connect to Google DriveStep 1: Drag the "Google Drive Connector" node to KNIMEAnalytics PlatformStep 2: Double Click on the node to open Dialog box. Select the"Working directory" using Browse Option. Step 3: Click "Ok" and execute the node Read Data from Google Drive using ReadernodesStep 1: Drag the appropriate Reader node based on the filetype.Step 2: Click on the 3 dots on the reader node and select "AddFile System Connection Port" option. This will add a blue colorport to the input of the node. Connect this port to the output of"Google Drive Connector" nodeStep 3: Double Click on the node to open Dialog box. Select thefile using the "Browse" option in "file" section. Click "Ok" andthen execute the node to read the file. Read Data from Google SheetsStep 1: Drag the "Google Sheet Connection" node to KNIMEAnalytics Platform and connect it with the output of "GoogleAuthentication" nodeStep 2: Execute the node to establish the connection with theGoogle Sheets associated with the user's account.Step 3: Connect the "Google Sheet Reader" node to output of"Google Sheets Connection" node. Double Click on the node toopen the dialog box. Select the "Spreadsheet" and "Sheet" andclick "Ok". Execute the node to read the Google Sheet. AuthenticateGoogle AccountSelect the Sheetthat has to be readConnect withGoogle SheetsConnect with Google DriveRead .txt file from Google DriveRead .xlsx file from Google DriveRead .csv file from Google Drive GoogleAuthentication Google SheetsReader Google SheetsConnection Google DriveConnector File Reader Excel Reader CSV Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: mpatt
Created at: 2022-03-23
On NodePit since: 2023-06-17
Last update: 2024-11-17
Created with KNIME version: v4.5.2
Tags: Google Drive ConnectorGoogle Sheets ReaderFile ReaderExcel ReaderCSV ReaderBeginnerBeginner Cheat SheetBeginners Space

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!