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 |