# Working with Google Sheets

{% hint style="danger" %}
Note! 

For better performance with your data, upload it to MaviBot tables. This way, your bots will work much faster and avoid errors related to requests to Google Sheets.
{% endhint %}

## For working with column letters 

c2n() | n2c() | addCols()

<details>

<summary>Description</summary>

<mark style="background-color:blue;">**To get a column number by its letter**</mark>

**c2n(str)**

Parameters:\ <mark style="color:red;">**!**</mark> **str** - column number in letter notation

<mark style="background-color:blue;">**To get a column letter by number**</mark>

**n2c(n)**

Parameter:\ <mark style="color:red;">**!**</mark> **n**- column number as a numeric value

<mark style="background-color:blue;">**To get a column letter by offset from a given column**</mark>

**addCols(str, n)**

Parameters:\ <mark style="color:red;">**!**</mark> **str** - column letter\
**n** - offset; to get a column number to the left of the specified one, pass a negative offset value.

</details>

<details>

<summary>Examples</summary>

<div data-with-frame="true"><figure><img src="/files/70Klu6REnOU7rMonZzKm" alt="" width="563"><figcaption></figcaption></figure></div>

<div data-with-frame="true"><figure><img src="/files/ReqAq1yy9mWRgAgHM73o" alt="" width="375"><figcaption></figcaption></figure></div>

</details>

<details>

<summary>Examples</summary>

```
number=c2n('AAB')
string=n2c(54)
offset=addCols('AA',-1)
```

</details>


---

# 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.mavibot.ai/chatbot/functions/calculator/sheets.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.