Read Table
Read Table
Reads the values of a specific table in a sheet of the spreadsheet, returning the data in a structured form.
Options
Sheet name
Enter the sheet that holds the table.
Table name
Enter the name of the table to read.
Advanced Options
Does the table have headers?
Yes or no, whether the table has a header row.
Returns
Javascript code
js
actions["action-id"].values // values of every cell in the table (Any)
actions["action-id"].size // number of rows in the table (Number)
Field selection
- values — values of every cell in the table (Any)
- size — number of rows in the table (Number)
Rules and Conditions
- Every field is required.