Widgets
Data
Transform
Visualize
Model
Evaluate
Unsupervised
Spectroscopy
Text Mining
Survival Analysis
Bioinformatics
Single Cell
Image Analytics
Networks
Geo
Educational
Time Series
Associate
Explain
Google Sheets
Read data from a Google Sheets spreadsheet.
Outputs
- Data: data set from the Google Sheets service.
Description
The widget reads data from the Google Sheets service. To use the widget, click the Share button in a selected spreadsheet, copy the provided link and paste it into the widget’s URL line. Press enter to load the data. To observe the data in real time, use the Reload function.
- Enter the link to the spreadsheet. Press Enter to load the data. Set reload if you wish to observe the updates in real time.
- Information on the data set: name and attributes.
- If Commit Automatically is ticked, the data will be automatically communicated downstream. Alternatively, press Commit.
Example
This widget is used for loading the data. We have used the link from the Google Sheets: https://goo.gl/jChYki. This is a fictional data on hamsters and rabbits, of which some have the disease and some don’t. Use the Data Table to observe the loaded data in a spreadsheet.
