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

2 thoughts on “Import Brokermint Data to Google Sheets”

  1. will data continue to live sync into google sheets once this is turned on? Or only when I submit a get request?

    Reply
    • Data will update only when you click Run, or set up a scheduled request to run in the background. It won’t automatically flow into your sheet.

      Reply

Leave a Comment

Jump To