List Google Sheets (Cloud Connectivity)
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).