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 |