Read Worksheet
This card returns information about a worksheet within a spreadsheet on Google Sheets.
Options
- Spreadsheet (Name): Drag down the options and select a spreadsheet.
Input Fields
- Worksheet Name (text): Type in the name of the worksheet of choice.
Output Fields
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.