> For the complete documentation index, see [llms.txt](https://docs.gaiodataos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gaiodataos.com/tools/tasks/etl/insert-row.md).

# Insert Row

<figure><img src="/files/OiQPrmepTgfukj9GWZhZ" alt=""><figcaption></figcaption></figure>

The **Insert Row** task in **Gaio DataOS** allows you to manually insert a new row into an existing table. It is especially useful for adding static records, parameterized values, or dynamic data generated through formulas or computed fields.

***

## &#x20;How to Use

### **1. Open the Task**

* In the **Studio**, go to the left menu and navigate to:\
  **Tasks > ETL > Insert Row**

***

### **2. Fill Out Basic Information**

* **Task label**: (optional) Provide a name for this task within your flow.
* **Table**: Select the **target table** where the new row will be inserted.

***

### **3. Select Columns**

* In the **Columns** field, choose which columns you want to populate.
* After selecting, a list of input fields will be displayed below for each column.

***

### **4. Define Type and Value for Each Column**

For each selected column, configure the following:

**Type:** Choose the input type:

* `Value`: insert a fixed/static value (e.g., "Product A", 123)
* `Parameter`: use a previously defined project parameter
* `Computed`: define a formula or function (e.g., `now()`, `today()`, `1+1`) |

**Value:** Enter the corresponding value based on the type selected.&#x20;

**Examples:**

* `col_1`: Type = `Value`, Value = `"New Client"`
* `col_2`: Type = `Parameter`, Value = `@client_id`
* `date_one`: Type = `Computed`, Value = `today()`

***

### **5. Execute or Save**

* **Run**: Runs the task without saving it to the flow.
* **Save**: Saves the task for use in the current flow without executing it.
* **Save and Run**: Saves and immediately runs the task.

***

#### Use Cases

* Manually insert a single row into a table
* Log events or markers during execution
* Populate test values during flow development
* Use computed fields for timestamps, UUIDs, or calculated values