# Connect a Google Sheet to Adalo with SheetBridge

### **Introduction**

This guide walks through connecting your Google Sheet Document using SheetBridge and creating an External Collection in Adalo for each of your Google Sheets. After setup, each spreadsheet tab appears as an External Collection you can use in Lists, Forms, and Actions.

***

### **Before You Begin**

* You will need a Google Spreadsheet URL (or the spreadsheet ID).
* You will need edit access if you want to create or update rows from Adalo (read-only access is sufficient for viewing data).
* Verify your Google Sheet Properties in our Mapping Property Types in Sheetbridge Help Doc.

***

### **Create your first SheetBridge External Collection**

1. In Adalo, open your app and click the Database tab in the left toolbar.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2F66y9FF35dbnmn2DhMrWO%2FCleanShot%202026-01-20%20at%2008.59.28%402x.png?alt=media&#x26;token=3b8961d5-c9f1-4002-8458-f8ee86eb04d8" alt="" width="188"><figcaption></figcaption></figure></div>
2. If you don’t have a SheetBrige account, you will first complete the Google Sign-In Permissions flow and approve access to the spreadsheet.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2Fja7IcrnI9rTqum1B7eG2%2FScreenshot%202026-01-21%20at%2010.38.00%E2%80%AFAM.png?alt=media&#x26;token=ffe3b1ac-a0a4-44a8-952f-720994c66a17" alt="" width="375"><figcaption></figcaption></figure></div>
3. In SheetBridge, paste your Google Spreadsheet URL (or ID) into the SheetBridge field to create your Bridge.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2F3A0oVbEZYEkmZN5oF88y%2FCleanShot%202026-01-20%20at%2009.02.31%402x.png?alt=media&#x26;token=df86b815-ef96-4dfb-962b-59c3e63b7a0a" alt="" width="375"><figcaption></figcaption></figure></div>
4. Confirm the connection. Go back to Adalo Builder and select ***Get My Bridges.***

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2F2ypbvJXkYOBsDTHDlfj2%2FScreenshot%202026-01-21%20at%2010.40.05%E2%80%AFAM.png?alt=media&#x26;token=2fc56c1e-5d6e-431a-920b-3f77334fb008" alt="" width="375"><figcaption></figcaption></figure></div>
5. Confirm Sheets are showing.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2FuPCK0qTGgy0CrgGraOay%2FCleanShot%202026-01-20%20at%2009.04.06%402x.png?alt=media&#x26;token=31219632-bcb8-41a3-a839-aa1b4c758178" alt="" width="375"><figcaption></figcaption></figure></div>
6. Select Sheets to add and ***Run Test*** to verify test is successful.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2FUdkuJxDq4CJugqYpaoGs%2FCleanShot%202026-01-20%20at%2009.04.53%402x.png?alt=media&#x26;token=f21ccd2e-f669-479b-b5b5-7a9c349fc124" alt="" width="375"><figcaption></figcaption></figure></div>
7. ***Connect*** to complete setup.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2FiBztkkSwJYrKjXP5JpD4%2FCleanShot%202026-01-20%20at%2009.05.42%402x%20(1).png?alt=media&#x26;token=5d6d5263-12d7-42e4-b677-160157d1cc69" alt="" width="375"><figcaption></figcaption></figure></div>
8. Adalo will detect the sheet columns and add them as properties.

   <div align="left"><figure><img src="https://3467607506-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LhGHkPsv15svPIU5I7C%2Fuploads%2FC90gzH2IGL4HwtQH4GSK%2FScreenshot%202026-03-26%20at%2011.20.25%E2%80%AFAM.png?alt=media&#x26;token=d98fb372-818d-4c60-ab27-2ca7b0fa1381" alt="" width="228"><figcaption></figcaption></figure></div>

***

### **Add additional tabs as collections**

If your spreadsheet has additional tabs (pages), create a separate External Collection for each tab you want to use in Adalo.

* Repeat steps 3-8 of the Add Collection flow for each additional Google Sheets tab you want in Adalo.
* Use clear collection names that match your tab names (for example: Customers, Orders, Inventory). These can be changed by editing the settings in the external collection.

### **Test that it is syncing**

1. Add a new row in Google Sheets (below your header row).
2. In Adalo app, refresh list of collection
3. Confirm the new row appears in List

### Add/Update Columns in Google Sheets

1. Add a new Column in Google Sheets.
2. In Adalo app, External Collections>Edit Collection>Run Test
3. Confirm the new property appears in response. Verify in Properties in External Collection
4. Column names must be unique in Google Sheet. If multiple share a name, only the 2nd will load.