Google Sheets Add-on

Connect to APIs directly from Google Sheets.
With the Databar Google Sheets extension, you can connect to our full catalogue of APIs without any configuration or setup. Pull in datasets and enrich your data directly from your spreadsheet.


Step 1: Install the Google Sheets add-on

To install the Google Sheets add-on, head over to this link and click Install.
Once you click install, you will be asked to verify access to your account. Click Allow.
About out access levels & permissions
  • View an manage spreadsheets that this application has been installed in
    • Used to add data to the spreadsheets where the extension has been installed.
    • This access level only includes spreadsheets where you're using the extension. We do not have access to all of your spreadsheets.
  • Connect to an external service
    • Used to pull data from APIs.
  • Allow this application to run when you are not present
    • Used for scheduled requests.
  • Display and run third-party web content in prompts and sidebars inside Google applications.
    • Used for the extension to work & display data in the sidebar.
We will never view, download, or access unauthorized data from your Google Drive or Google Sheets. The only purpose of access levels is to allow the extension to paste data into your Google Sheet.

Step 2: Open the add-on

Once you've installed the add-on, you must open it from your Google Sheet. Hover over Extensions, then go to API connector > Open Widget.
Open the extension
The extension should open in a sidebar on the right side of your spreadsheet:
If you're seeing a white screen for a long time (>1 minute), you may need to clear your cache. This is an issue with all Google Sheets extensions that often appears if you're logged into multiple accounts. To fix it, you can open the spreadsheet in an incognito window or log out from your other accounts.

Step 3: Connect your Databar account

Before making API requests, you'll need to connect your Databar account to the Google Sheets extension. To do that, click on Log in in the bottom right of the extension, paste your Databar API key, and click Activate.
You can find your API key in your profile at (must be logged in).
Now your Databar account is connected to Google Sheets!

Step 4: Make your first request

To connect to APIs, select any of the APIs in the Query tab or Enrichments in the Enrichments tab. The home page by default displays curated collections from our team. You can also use the search bar to find any particular APIs or connectors that interest you.
Once you've selected a connector, click on it, fill in the parameters, and click Run! You should see data automatically appear in your spreadsheet.
Happy crunching!


If you have any questions about the extension or would like to submit feedback, please reach out to us at [email protected].