Read Spreadsheet Info

Read information about a spreadsheet in your Google Sheets account. If you have spreadsheets with duplicate names, only the first result is returned.

Unless otherwise indicated, field types are text.

Options

Field Type: Choose from Name or ID. You must enter the spreadsheet name or the spreadsheet ID in the Input section depending on the option you chose.

Input

  • Spreadsheet

    • Name: spreadsheet name

    • ID: spreadsheet's unique ID, this can be found in the spreadsheet URL; for example, if the URL is https://docs.google.com/spreadsheets/d/1OKS-x2YGrFaRh4V51rG_YU4HLEO51Mvsrkvk/edit#gid=0, the spreadsheet ID is 1OKS-x2YGrFaRh4V51rG_YU4HLEO51Mvsrkvk.

Output

  • Spreadsheet

    • ID: spreadsheet's unique ID

    • URL: URL of the spreadsheet

  • Worksheets (object): collection of worksheets in the spreadsheet

    • Name: names of the worksheet tabs in the spreadsheet

    • ID(number): unique IDs of the worksheet tabs in the spreadsheet

See Also

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation