This card returns information about a worksheet within a spreadsheet on Google Sheets.
- Spreadsheet(Name): Drag down the options and select a spreadsheet.
- Worksheet Name(text): Type in the name of the worksheet of choice.
This card returns 6 values. These can be dragged to other cards to perform other functions.
Spreadsheet ID (text):
- Returns the ID to locate the Spreadsheet which the worksheet is located. This can be dragged to other cards to perform functions on the Spreadsheet.
Worksheet ID (text):
- Returns the ID to locate this worksheet. This can be used in other cards to perform functions on this worksheet.
Worksheet URL (text):
- Returns the specific URL to access this worksheet.
Sheet Type (Ex: Grid):
- Returns the format of the worksheet.
Row Count (integer):
- Returns the number of rows on the worksheet.
Column Count (integer):
- Returns the number of columns on the worksheet.