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.

Note: Deleting rows removes them from the sheet. Consider using a "status" column for soft-delete workflows if you want to keep historical records.