Read Worksheet

This card returns information about a worksheet within a spreadsheet on Google Sheets.

Options

  • Spreadsheet(Name): Drag down the options and select a spreadsheet.

Input Fields

  • Worksheet Name(text): Type in the name of the worksheet of choice.

Output Fields

This card returns 6 values. These can be dragged to other cards to perform other functions.

  • Spreadsheet ID (text):

    • Returns the ID to locate the Spreadsheet which the worksheet is located. This can be dragged to other cards to perform functions on the Spreadsheet.
  • Worksheet ID (text):

    • Returns the ID to locate this worksheet. This can be used in other cards to perform functions on this worksheet.
  • Worksheet URL (text):

    • Returns the specific URL to access this worksheet.
  • Sheet Type (Ex: Grid):

    • Returns the format of the worksheet.
  • Row Count (integer):

    • Returns the number of rows on the worksheet.
  • Column Count (integer):

    • Returns the number of columns on the worksheet.

See Also

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation