Read information about a spreadsheet in your Google Sheets account. If you have spreadsheets with duplicate names, only the first result is returned.
Unless otherwise indicated, field types are text.
- Name: spreadsheet name
- ID: spreadsheet’s unique ID
- URL: URL of the spreadsheet
- Worksheets (object): collection of worksheets in the spreadsheet
- Name: names of the worksheet tabs in the spreadsheet
- ID (number): unique IDs of the worksheet tabs in the spreadsheet