# Data

This category encompasses integrations for seamless data syncing to both spreadsheets and databases, essential for maintaining up-to-date records across teams and systems. The options provided cater to various data manipulation needs including creating new records, updating existing ones, and setting specific cell values, without the requirement for coding.

## **Insert a New Row**

This integration lets you automatically insert new rows into either a spreadsheet or database, enabling efficient data management and record-keeping. You can specify the destination and map data fields directly, streamlining the process without the need for manual coding.

### Options

* **Destination**:
  * For spreadsheets: Specify the *Spreadsheet ID* and *Sheet Name* you wish to connect.
  * For databases: Provide the *Collection* or *Table Name*.
* **Data to Send**: Map the data fields from your source to the target column names or table fields for insertion. For spreadsheets use column names such as "A", "B". Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).

### **Apps**

[Google Sheets](https://monitoro.co/apps/google-sheets), [Airtable](https://monitoro.co/apps/airtable), [Supabase](https://monitoro.co/apps/supabase), [Webflow](https://monitoro.co/apps/webflow), [Bubble](https://monitoro.co/apps/bubble)

## **Update an Existing Record**

This integration lets you automatically update existing rows into either a spreadsheet or database, or do nothing if no matching row is found, enabling efficient data management and record-keeping. You can specify the destination and map data fields directly, streamlining the process without the need for manual coding.

### Options

* **Destination**:
  * For spreadsheets: Specify the *Spreadsheet ID* and *Sheet Name* you wish to connect.
  * For databases: Provide the *Collection* or *Table Name*.
* **Conditions**: Set the criteria to locate the row(s) needing updates. Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).
* **Data to Send**: Map the data fields from your source to the target column names or table fields to update them. For spreadsheets use column names such as "A", "B". Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).

### **Apps**

[Google Sheets](https://monitoro.co/apps/google-sheets), [Airtable](https://monitoro.co/apps/airtable), [Supabase](https://monitoro.co/apps/supabase), [Webflow](https://monitoro.co/apps/webflow), [Bubble](https://monitoro.co/apps/bubble)

## **Update or Insert a New Row**

This integration tries to update existing rows in either a spreadsheet or database, or insert a new row if none are found, enabling efficient data management and record-keeping. You can specify the destination and map data fields directly, streamlining the process without the need for manual coding.

### Options

* **Destination**:
  * For spreadsheets: Specify the *Spreadsheet ID* and *Sheet Name* you wish to connect.
  * For databases: Provide the *Collection* or *Table Name*.
* **Conditions**: Set the criteria to locate the row(s) needing updates. Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).
* **Data to Send**: Map the data fields from your source to the target column names or table fields to update them. For spreadsheets use column names such as "A", "B". Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).

### **Apps**

[Google Sheets](https://monitoro.co/apps/google-sheets), [Airtable](https://monitoro.co/apps/airtable), [Supabase](https://monitoro.co/apps/supabase), [Webflow](https://monitoro.co/apps/webflow), [Bubble](https://monitoro.co/apps/bubble)

## **Insert a New Timeseries Entry**

This integration lets you send new timeseries entries into a specified bucket. This operation is crucial for efficiently managing and updating timeseries databases with new entries, utilizing specified tags and fields for precise data mapping.

### Options

* **Measurement**: Name of the bucket where to send a new timeseries entry.
* **Tag set**: Map the tags for the timeseries entry. Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).
* **Field set**: Map the fields for the timeseries entry. Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).

### **Apps**

[InfluxDB](https://monitoro.co/apps/influxdb)

## **Set the Value of a Specific Cell**

### Options

* **Cells and Data**: Map the data fields from your monitor to the specific cells to update. Use standard spreadsheet notation such as A1, B2, C3. Refer to the Data Connector documentation in [Actions](/reference/automations/actions.md).

### **Apps**

[Google Sheets](https://monitoro.co/apps/google-sheets)

***

## Need help?

{% content-ref url="/pages/1lnlBLH6HfwEK7PvqADD" %}
[Common questions (FAQ)](/resources/common-questions-faq.md)
{% endcontent-ref %}

{% content-ref url="/pages/dKtMy5pNOGJkipAL18ta" %}
[Troubleshooting](/resources/troubleshooting.md)
{% endcontent-ref %}

{% content-ref url="/pages/Vuu3jOA6KDUwIos8cci0" %}
[Support](/resources/support.md)
{% endcontent-ref %}


---

# 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.monitoro.co/reference/automations/actions/data.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.