Workflow Table

A workflow table aims to keep the extracted data from a website. It is analogous to a spreadsheet. However, every column in the table is a strict data type.

Adding Columns

Before you insert data in the table, you need to set a column for the table.

Open a workflow, then click the table icon () in the upper right corner. Enter the column name, then select the Add button. Next, you can choose the type of column data near the column you added.

There are 4 types of data you can choose from: Text, Number, Boolean, Array, and Any.

Entering Data

You can enter data into the table using blocks used to extract data from a website: Get Text and Attribute Value blocks. To enter data using these blocks, click the Edit button, enable the "Insert in Table" option, and choose one of the columns.

Each time you enter data in the table, it will be pushed to the end row of the column. For instance, it happens when you fill a table with such data:

title

price

urls

available

Car

4000

["https://en.wikipedia.org/wiki/Car"]

true

Motorcycle

2000

["https://en.wikipedia.org/wiki/Motorcycle"]

false

The table would look like this when the workflow runs a Get Text block and inserts the data into the title column:

name

price

urls

available

Car

4000

["https://en.wikipedia.org/wiki/Car"]

true

Motorcycle

2000

["https://en.wikipedia.org/wiki/Motorcycle"]

false

Boat

In the workflow, the table kept an array of objects.

[
  {
    "name": "Car",
    "price": 4000,
    "urls": ["https://en.wikipedia.org/wiki/Car"],
    "available": true
  },
  {
    "name": "Motorcycle",
    "price": 2000,
    "urls": ["https://en.wikipedia.org/wiki/Motorcycle"],
    "available": false
  },
  {
    "name": "Boat"
  }
]

Exporting Table Data

Use the Export Data block to export the table to a file. You can choose to export the table in "Text", "CSV", or "JSON" file format.

Last updated