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.

Options

Field Definition Type Required
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. Dropdown TRUE

Input

Field Definition Type Required
Name Spreadsheet name String TRUE
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. String TRUE

Output

Field Definition Type
ID Unique ID of the spreadsheet String
URL URL of the spreadsheet String
Worksheets Collection of worksheets in the spreadsheet Object
Name Names of the worksheet tabs in the spreadsheet String
ID Unique IDs of the worksheet tabs in the spreadsheet Number

Related topics

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation