Skip to main content

Read Google Sheets

Synopsis​

This operator reads a single sheet or range from a Google Sheets spreadsheet.

Description​

The operator can be used to read both entire sheets and individual ranges from a Google Sheets spreadsheet. Sheets are identified by name, e.g., the name of the first sheet in a spreadsheet is by default Sheet1.

Ranges can be used to limit the columns and rows to read from a sheet. E.g., Sheet1!A:C and Sheet1!1:3 will limit the lookup to the first three columns and rows respectively. And the combined expression Sheet1!A1:C3 will limit the lookup to the first 3×3 cells.

By default, date and time cells will be converted to their corresponding types in RapidMiner using the time zone of the spreadsheet. Furthermore, the time of the day is rounded to milliseconds. Both the time zone and the rounding precision can be changed in the advanced parameters of the operator.

Input​

Output​

data​

Tha data table read from the sheet or range.

Parameters​

Connection entry​

This parameter is used to specify a repository location that represents a connection entry.

Spreadsheet id​

The id of the Google Sheets spreadsheet. The id is part of the spreadsheet URL.

Range​

The name of the sheet to read followed by an optional range.

First row as names​

Whether to read the first row as column names.

Date time precision​

Precision of the conversion from Google Sheets time values to RapidMiner time values (milliseconds by default). For sub-second units, the time is simply rounded to the given unit. However, for lower temporal resolutions such as minutes or days, the time is first rounded to milliseconds and then rounded down to the given unit. Eg, 00:14:59.9994 and 00:14:59.9995 would be rounded to 14 and 15 minutes respectively.

Time zone​

The time zone used for converting Google Sheets calendar types to RapidMiner date time types (instants of time without a time zone). By default, the operator will use the time zone specified in the spreadsheet. However, this time zone can be overridden in case the user input does not match the spreadsheet settings.

Request timeout​

Specifies how long to wait for the Google Sheets API to respond to a request (in seconds).