# How to work with Mavibot sheets
The **"Sheets"** section in MaviBot is a tool for convenient data storage and management within the platform. You no longer need to switch between different services—all your sheets are now available in a single project.
**Features:**
* Create sheets with any number of rows and columns.
* Store and edit data without third-party tools or services.
* Enter values, edit rows and columns, or delete them directly through the chatbot using functions.
**Advantages:**
* **Simplifies data management:** you can enter information into a table directly from the bot.
* **Flexible and easy to use:** create as many tables as you need and customize them for your business tasks.
{% hint style="success" %}
#### **Manage your tables without leaving Mavibot**
Tables help businesses structure their data and speed up processes.
{% endhint %}
## How to create sheets
To get started, go to the **"Sheets"** section in the required project:
Next, you will see the **"Create a sheet"** button. Click it to open a modal window where you need to enter the table name:
Enter a name for the table and click **"Done"**. The new table will then be created in the project and appear in the **"Sheets"** section.
### Sheets settings
After creating the sheet, you need to add rows and columns. To do this, find the "Go to" button on the desired table and click it:
You'll see the following settings:
1. Function for adding columns:
а) to add lettered columns
The button adds columns labeled A to Z to the table.
b) to add columns with custom names
Clicking the button opens a modal where you can name the new column.
Enter a name and click **"Done"** to add the column to the table.
2. Button for adding strokes:
3. Sheet export
Allows you to export the sheet in CSV format with all data and values, for example, to move the sheet to another Mavibot project or to another spreadsheet service.
4. The **Import CSV** feature enables you to upload data from an external service.
### Other features
There is a dropdown menu that allows you to quickly browse sheets without leaving the main section.
You can also create new tables directly from the side menu.
To delete a sheet, go to the main section:
Then, find the **Delete** button on the card of the table you want to remove.
{% hint style="danger" %}
Warning!
Deleted tables cannot be restored.
{% endhint %}
### How to enter values into the sheet
You can enter values into the sheet manually:
Or by using functions in the chatbot.
### **How to find a sheet ID**
You will need a Sheet ID to use chatbot functions related to this table.
1. **Navigate to your table.** Find the desired table in the list and click on its name to open it.
2. **Locate the Table ID in the address bar.** Click on the address bar of your browser — the Table ID is the unique string of characters at the end of the URL.
3. **Example:**\
In a URL like `https://mavibot.ai/projects/11111/table/2`\
the Table ID is **`2`**.
4. **Copy the ID**\
Select and copy this number from the address bar to use in your chatbot configuration.
### How to create a new record in the sheet
new\_record(table\_id, data) – create a new entry in the table with the specified values.
table\_id – the ID of the table
data – a dictionary containing the data to be entered. Example: {"column\_name1": "value1", "column\_name2": "value2"}. If a column does not exist, it will be created. Response: the ID of the new entry
### Example
### How to edit an existing record in the sheet
edit\_record(table\_id, record\_id, data)
table\_id – the ID of the table
record\_id – the ID of the entry to be edited
data – a dictionary containing the data to be updated. Example: {"column\_name1": "value3", "column\_name2": "value4"}. If a column does not exist, it will NOT be created.
Response: Returns the full data of the edited entry in the format {"column\_name1": "value3", "column\_name2": "value4"}
### Example
### How to delete a sheet record by its ID
delete\_record(table\_id, record\_id)
table\_id – the ID of the table
record\_id – the ID of the entry to delete
Response:
{'message': 'Deleted entries: 1'}
### How to find the first record with the specified value in a sheet
find\_record(table\_id, value, find\_in, return\_from)
table\_id – the ID of the table
value – the value to search for
find\_in – optional. The name of the column to search in. If not specified, the search will be performed across all columns
return\_from – optional. The name of the column from which to return the value
Response: If return\_from is specified, the value of the specified column will be returned (if it exists in the table). If return\_from is not specified or the column does not exist, the full data of the found entry will be returned: {"column\_name1": "value3", "column\_name2": "value4"}
### Example
### How to get values from the specified record
get\_record\_data(table\_id, record\_id, return\_column )
table\_id – the ID of the table
record\_id – the ID of the entry to retrieve values from
return\_column – optional. The name of the column from which to return the value
Response: If the entry is found, returns a dictionary like {"column\_name1": "value1", "column\_name2": "value2"}. If return\_column is provided and the column exists, only the value from that column will be returned.
### How to retrieve all values when searching across multiple columns
find\_records\_multiple\_cols\_list(table\_id, column\_data, return\_col, with\_index, delimiter, algorithm) – Use this function when you need to search across multiple columns at once and retrieve a list of values from a column in rows where all values are found. (This is similar to the sheet\_search\_in\_multiple\_cols\_return\_list function for Google Sheets.)
**table\_id** — the ID of the table
**column\_data** — the search query, i.e., what you want to find
**return\_col** — the column number from which to return values
**with\_index** — index or numbering in the list of found values (0 – numbering (1, 2, 3,…); 1 – row index; "" – list of values on new lines without indexes or numbering)
**delimiter** — separator between the index and the value
**algorithm** — search algorithm (F – exact match, K – keyword match, R – regular expression, 1–100 – similarity percentage (see details above))
Example:
table\_id = 7
data = {"age": "26", "city": "New York"}
return\_col = "name"
with\_index = 1
delimiter = " - "
algorithm = "F"
res = find\_records\_multiple\_cols\_list(table\_id, data, return\_col, with\_index, delimiter, algorithm)
res\_list = res\["list"]
If the query executes successfully, the response is a dictionary containing the status and all cells with values:
{"status":true,"rows\_index":\[2,3],"quantity":2,"list":"2 - John\n3 - Anna"}
**status** — the search result
**rows\_index** — an array with the numbers of the found rows
**quantity** — the number of rows found
**list** — a string with all values from the selected column
If an error occurs, the response will be status: false along with an error description: {"status": false, "error": "Error or description"}
### How to retrieve the first value when searching across multiple columns
find\_first\_record\_multiple\_cols\_row(table\_id, column\_data, algorithm) – use this function when you need to search across multiple columns at once and retrieve the first matching row. (This is similar to the sheet\_search\_in\_multiple\_cols\_return\_row function for Google Sheets.)
**table\_id** — the ID of the table
**columns** — the search query, i.e., what you want to find
**algorithm** — the search algorithm (F – exact match, K – keyword match, R – regular expression, 1–100 – similarity percentage (see details above))
Example:
table\_id = 7
data = {"age": "26", "city": "New York"}
algorithm = "F"
res = find\_first\_record\_multiple\_cols\_row(table\_id, data, algorithm)
row\_data = res\["row\_data"]
row\_id = row\_data\["ID"]
row\_name = row\_data\["name"]
row\_age = row\_data\["age"]
If the query executes successfully, the response is a dictionary containing the status and all cells with values.
{"status":true,"rows\_index":\[2,3],"quantity":2,"row\_data":{"ID":2,"name":"John","age":"26","city":"New York"},"row":2}
**status** — the search result
**rows\_index** — an array with the numbers of the found rows
**row\_data** — data from the found row
**row** — the number of the found row
If an error occurs, the response will be status: false along with an error description: {"status": false, "error": "Error or description"}
