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.

   
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.

   
3. In SheetBridge, paste your Google Spreadsheet URL (or ID) into the SheetBridge field to create your Bridge.

   
4. Confirm the connection. Go back to Adalo Builder and select Get My Bridges.

   
5. Confirm Sheets are showing.

   
6. Select Sheets to add and Run Test to verify test is successful.

   
7. Connect to complete setup.

   
8. Adalo will detect the sheet columns and add them as properties.

   

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.