Search API Connector Documentation

Print

Import Brokermint Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Brokermint API directly into Google Sheets, using the API Connector add-on.

We'll first get an API key from Brokermint, and then set up a request to pull in metrics to your spreadsheet.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Brokermint API Token

To connect Brokermint with API Connector, you will need to request your API token from Brokermint support ([email protected])

Once Brokermint responds with your token details, move onto the next section.

Part 2: Pull Brokermint API Data into Sheets

For this API request, we'll fetch transactions. Other data types can be found in the documentation. Here's the request setup:

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://my.brokermint.com/api/v2/transactions?count=1000&api_key=your_api_token
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see Brokermint data populate your sheet.
    brokermint-response

Part 3: API Documentation

Official API documentation: https://brokermintsupport.zendesk.com/hc/en-us/articles/360055896812-API-Reference#section/BASICS

Leave a Comment

Jump To