# Create, update, and delete rows with SheetBridge (CRUD)

### **Introduction**

Once your SheetBridge External Collection is set up, you can use it like a standard Adalo collection. Forms and Actions can create, update, and delete rows in Google Sheets in real time.

***

### **Before You Begin**

* Your SheetBridge connection must be working, and the sheet must have a sheetbridge\_id column.
* You will need edit permission to the Google Spreadsheet to write changes back to Sheets.
* You cannot have a column titled ***‘id’*** or it will throw an error when updating the row.
* Write operations (create/update/delete) are queued and asynchronous in production which may result in a delay displaying newly created or updated data. 

***

### **Create a new row**

1. Add a Form in Adalo that creates a record in your SheetBridge collection.
2. Map each form input to the matching property (column) from your sheet.
3. Preview your app and submit the form.
4. Check your Google Sheet - a new row should appear with a generated sheetbridge\_id.

***

### **Update an existing row**

1. Use an Edit Form or an Update Action on a record from your SheetBridge collection.
2. Update one or more fields and save.
3. Confirm the changes appear in Google Sheets.

***

### **Delete a row**

1. Add a Delete Action (or a button with a Delete action) for a record in your SheetBridge collection.
2. Confirm the row is removed in Google Sheets.

{% hint style="warning" %}
**Note: Deleting rows removes them from the sheet. Consider using a "status" column for soft-delete workflows if you want to keep historical records.**
{% endhint %}


---

# 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://help.adalo.com/integrations/sheetbridge-for-google-sheets/create-update-and-delete-rows-with-sheetbridge-crud.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.