# 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.gaiodataos.com/tools/tasks/etl/insert-row.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.