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. |
Text | 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. |
Text | TRUE |
Output
| Field | Definition | Type |
|---|---|---|
|
ID |
Unique ID of the spreadsheet. |
Text |
|
URL |
URL of the spreadsheet. |
Text |
|
Worksheets |
Collection of worksheets in the spreadsheet. |
Object |
|
Name |
Names of the worksheet tabs in the spreadsheet. |
Text |
|
ID |
Unique IDs of the worksheet tabs in the spreadsheet. |
Number |