> For the complete documentation index, see [llms.txt](https://help.adalo.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.adalo.com/integrations/sheetbridge-for-google-sheets/create-update-and-delete-rows-with-sheetbridge-crud.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://help.adalo.com/integrations/sheetbridge-for-google-sheets/create-update-and-delete-rows-with-sheetbridge-crud.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.