Categories

Versions

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).