Search API Connector Documentation

Print

Import CoachAccountable Data to Google Sheets

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

Contents

Before You Begin

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

Part 1: Get Your CoachAccountable API Key

  1. Log in to CoachAccountable and click your profile icon > Settings > System > API Access from the right sidebar (or just navigate to https://www.coachaccountable.com/app/API directly).
    coachaccountable-api-access
  2. You should now see your API ID and private API key.
    coachaccountable-api-key

  3. Keep these handy as you’ll need them shortly. Congrats! You’re now ready to use the CoachAccountable API.

Part 2: Create Your API Request

We’ll first set up a pull to view your clients. This API uses the same URL for all requests: https://www.coachaccountable.com/API/. Different types of requests are defined in the request body using the “a” parameter.

To get a list of clients, we’ll need a request body like this:

{"APIID":"your_app_id",
"APIKey":"your_api_key",
"a":"Client.getAll"}

Part 3: Pull CoachAccountable API Data into Sheets

We can now enter this into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. Choose the POST method from the dropdown method selector.
    coachaccountable-method
  3. Enter https://www.coachaccountable.com/API/ into the URL field.
    coachaccountable-url
  4. We don’t need extra authentication so just leave OAuth as None. We don’t need any Headers either, so just skip that section.
  5. Under the request body, enter the request body we created above.
    coachaccountable-request-body
  6. Create a new tab and click Set current to use that tab as your data destination.
  7. Name your request and click Run. A moment later you’ll see your CouchAccountable client data populate your Google Sheet.
    coachaccountable-results

Part 4: More Example API Requests

You can view the full set of endpoints in the (excellent) API documentation, but if you just want to get started, try out the following example request bodies. Just substitute in your own APIID and APIKey values.

  • Add a new client
    {"APIID":"your_api_id",
    "APIKey":"your_api_key",
    "a":"Client.add",
    "firstName":"Peter",
    "lastName":"Piper",
    "email":"[email protected]"}
  • Get all actions for a client
    {"APIID":"your_api_id", "APIKey":"your_api_key", "a":"Action.getAllProjects", "ClientID":"your_client_id"}
  • Get all metrics for a client
    {"APIID":"your_api_id", "APIKey":"your_api_key", "a":"Metric.getAll", "ClientID":"your_client_id"}
  • Get invoice payments
    {"APIID":"your_api_id", "APIKey":"your_api_key", "a":"Invoice.getPayments"}

Part 5: API Documentation

Official API documentation: https://www.coachaccountable.com/APIDocs#introduction

Previous Import Clickbank Data to Google Sheets
Next Import CoinAPI Data to Google Sheets

Leave a Comment

Table of Contents