Skip to main content

List Google Sheets

Synopsis​

This operator lists all sheets of a given Google Sheets spreadsheet.

Description​

The operator outputs a single table with each row representing a sheet of the spreadsheet. The table includes information such as the sheet title (name), type, and visibility. Please take note that only sheets of type GRID can be read and updated from RapidMiner.

Input​

Output​

data​

The list of sheets in the Google Sheets spreadsheet.

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.

Request timeout​

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