# Prepare your Google Sheet for SheetBridge

*Skill Level: Expert*

### **Introduction**

SheetBridge reads your first row as column headers and turns each column into a property in Adalo. A clean header row and consistent data makes setup faster and prevents sync errors.

***

### **Before You Begin**

* Make a copy of your spreadsheet before making structural changes (recommended).
* Ensure each tab you plan to connect uses a single header row (the first row) and a consistent structure.
* Column Headers should have ***unique names***. Duplicate Column names will result in missing data.
* Sheet Tabs should have ***unique names***. Duplicate Tab names will result in missing data.
* Remove Blank Rows at the bottom of the Google Sheet.

***

### **Set up your Header Row**

<div align="center"><img src="/files/MpHeK3iuXuCeI8okf7gw" alt="image.png" width="563"></div>

1. Open your Google Spreadsheet and choose the tab you want to use as a collection.
2. Make sure row 1 contains your column names (for example: name, email, status).
3. Use one header per column. Avoid merged header cells.
4. Avoid duplicate header names. Each header should be unique.
5. **Consistent data types:** Each column should maintain a single data type (text, number, date, or boolean)
6. **Normalize related data:** Separate customer information from order details into distinct sheets for better relationships

***

### **Understand the SheetBridge ID column**

SheetBridge automatically creates a ***sheetbridge\_id*** column to uniquely identify each row. This ID is used for updates and deletes.

{% hint style="danger" %}
**Important: The sheetbridge\_id column is system-managed. Do not rename, edit, or delete it, or the connection can break.**
{% endhint %}

***

### **Best practices**

* Use clear, simple header names (letters, numbers, and spaces).
* Keep data types consistent within a column (for example, do not mix dates and text).
* Avoid fully blank rows in the middle of your data.
* If you need to rename a column, verify any places in Adalo that reference it (Lists, Forms, Actions) are still connected properly.


---

# 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/prepare-your-google-sheet-for-sheetbridge.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.
