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.