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.

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