Import D-iD API Data to Google Sheets

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


Before You Begin

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

Part 1: Get Your D-ID API Key

  1. Log in to D-ID, open the left-hand sidebar, and click Settings & API.
  2. Click Generate new key
  3. Copy the key to your clipboard.
  4. One last step: Because the D-ID API requires Basic Authentication, we need to encode our API key to base 64. You can do this by entering your API key into this form.

    The encoding script runs in your browser, and none of your credentials are seen or stored by this site.


Part 2: Pull D-ID API Data into Sheets

You can run a request to any of the endpoints shown in the documentation. For this simple example, we'll fetch the number of credits remaining in our account. Substitute in your own encoded credentials where it says your_encoded_credentials.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URL
    • Headers
      • Authorization: Basic your_encoded_credentials
  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 data from your test request populate your Sheet.

Part 3: API Documentation

Official API documentation:

Leave a Comment

Jump To