Skip to main content
Go to the Studio
Tables

List tables

List tables

Lists the tables (named ranges) existing in a spreadsheet.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet whose tables will be listed. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Returns​

Javascript code​

js
actions["action-id"].tables // List with the name, tab and range of each table (List)

Field selection​

  • tables — list with the name, tab and range of each table. Each item holds name, sheet, startRow, endRow, startColumn and endColumn (List)

Rules and Conditions​

  • The Google Sheets connection and Spreadsheet ID fields are required.
  • If the spreadsheet has no table created, the tables field returns an empty list.
  • The endRow and endColumn fields of each item may not be returned when the table has no defined row or column limit.
  • Use this action to discover the names and ranges of the existing tables before referencing them in other actions, such as Create table, Add column, Delete column and Rename column.