Skip to main content

How to connect your app to an external data source

Connect your app to real-time external data using Web APIs or Google Sheets with Datasource Builder.

S
Written by Support
Updated this week


Overview

Datasource Builder enables you to create a real-time bridge between your app and external data. Use it to connect APIs or Google Sheets to dynamically power features like listings, status updates, or user directories.

Any changes made to your external data source will automatically sync with your app wherever the datasource is connected.


How to use Datasource Builder

  1. Log in, go to Settings > Integrations > Data Sources.

  2. Click New Datasource.

  3. Choose your datasource type: Web API or Google Sheet.

  4. If using Web API:

    • Enter a Datasource ID — a unique identifier used to reference this datasource.

    • Enter the Request URL — the endpoint you want to pull data from.

    • Select your method: GET (retrieve data) or POST (send data).

    • Enter any necessary Request Headers — used for authentication or specifying data format.

    • Enter the Params — any URL parameters needed to customize the data call.

    • Click Fetch Data to test your setup.

    • Click Save.

  5. If using Google Sheets:

      • Create a new project or select an existing one.

      • Navigate to APIs & Services > Library.

      • Search for Google Sheets API and click Enable.

      • Navigate to APIs & Services > Credentials.

      • Click + Create Credentials, then select API key.

      • Copy your API key.

      • Click Restrict Key, and under API restrictions, select Google Sheets API

      • Save your changes.

      • Make sure the API key is restricted and enabled for the Google Sheets API.

    • Enter a Datasource ID — a unique identifier used to reference this datasource.

    • Enter the Sheet ID — found in the share URL of your sheet (between /d/ and /edit)

      • Example: 123abc in docs.google.com/spreadsheets/d/123abc/edit?usp=sharing.

    • Enter the Sheet Name — the tab name inside your Google Sheet.

    • Enter your Google API Key.

    • Click Fetch Data to test your setup.

    • Click Save.


Troubleshooting tips

  • Error fetching data: Double-check your API key, sheet ID, and permissions.

  • Data not updating: Make sure the external source is live and accessible.

  • Invalid headers or params: Verify your formatting and any required authentication tokens.

Did this answer your question?