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.

Input

  • Spreadsheet
    • Name: spreadsheet name

Output

  • Spreadsheet
    • 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