# Troubleshooting SheetBridge Connection
## **Before You Begin**
* If you are seeing a connection error, first confirm you can open the spreadsheet in Google Sheets with the same Google account you used to connect.
* Re-test the Connection in your External Collection.
### **Test Your Connection**
Run the test of your SheetBridge setup. If there's an error, you'll see the error message from Sheetbridge and can go back and adjust your setup. If everything works, you'll see the response, and you can close the setup modal.
.gif?alt=media\&token=0dfb6506-3551-408a-a631-8015b19b5e67)
### **Common issues**
1. I can connect, but no data appears in Adalo
1. Make sure the first row of your sheet contains headers and your tab has at least one data row. If the tab is empty, add a sample row and try again.
2. I changed my headers and now fields are missing or wrong.
1. Changing header names changes the property names. If you rename a header, you will need to test the external collection for it to update properly.
3. Updates are not showing in real time.
1. Refresh the preview and confirm you are looking at the correct collection. If the issue persists, disconnect and reconnect the spreadsheet to re-establish permissions.
4. I edited or deleted the sheetbridge\_id column.
1. The sheetbridge\_id column is required for stable updates and deletes. Undo the change in Google Sheets if possible. If you cannot restore it, reconnect the spreadsheet and allow SheetBridge to recreate the ID column.
5. Permission / access errors
1. Ensure the spreadsheet is owned by or shared with the connecting Google account. If your organization restricts third-party app access, your admin may need to allow SheetBridge.
6. I do not see all of my spreadsheet tabs in Adalo.
1. Each spreadsheet tab acts like a separate External Collection. Create a new SheetBridge External Collection for each tab you want to use in Adalo, and confirm the tab has a header row and at least one data row.
2. Each Spreadsheet tab should have a ***unique name***. Tabs with the same name will not load correctly.
7. I see unexpected blank values.
1. Check for merged cells, hidden columns, or formulas that return empty values. Keep each column consistent and avoid merged cells in the header row.
8. I am getting duplicate or inconsistent rows.
1. Avoid copy-pasting entire rows that include the sheetbridge\_id column. If you need to duplicate data, paste values into a new row and let SheetBridge generate a new sheetbridge\_id.
9. Writes from Adalo fail or do not appear in Sheets.
1. Confirm the connecting Google account has edit access to the spreadsheet, and that the sheet is not protected in a way that blocks edits. If the issue persists, reconnect to refresh permissions.
### **FAQs**
1. Does SheetBridge sync in real time?
1. Changes made from Adalo are written to Google Sheets immediately (or shortly after via queue). Changes made directly in Google Sheets will appear in Adalo within a few seconds depending on connection.
2. Is SheetBridge read-only or read/write?
1. SheetBridge is read/write. You can create, update, and delete rows (CRUD) from Adalo and those changes are reflected in Google Sheets.
3. Are there limits on rows, columns, or requests
1. Specific limits may apply. When working with very large sheets, you may see performance impacts depending on Google Sheets quotas and your network connection. If you experience rate limiting **`(HTTP 429 errors)`**, reduce the frequency of requests.
4. Can I use PATCH to update my Google Sheet?
1. PATCH is not currently supported.
5. Can I query individual records?
1. Yes, you can fetch a single row by its **`sheetbridge_id` **
### **Next steps**
Now that your collection is connected, build a List to display rows, and add Forms to create and edit records. If you need to connect additional tabs, repeat the Add Collection flow for each tab.
---
# 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/troubleshooting-sheetbridge-connection.md?ask=
```
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.
.png?alt=media&token=4f80ad03-6cc0-41e1-ba66-18b4c3ff7f86)