This card returns the information about a spreadsheet. It will read the first spreadsheet found by name. If you have spreadsheets with duplicate names, only the first result is returned.

Input Fields

  • Spreadsheet
    • Name (text): The spreadsheet desired to analyze.

Output Fields

  • Spreadsheet
    • ID (text) : The ID of this particular spreadsheet. This can be used in other Google Spreadsheet cards as identification.
    • URL (text) : This card will return the URL link of the page.
  • Worksheets
    • Worksheets (Object) : A collection of the worksheets inside this spreadsheet.
      • Name (text) : The names of the different Worksheet tabs within the spreadsheet.
      • ID (Number) : The unique IDs of the Worksheet tabs.