Print

Import BigCommerce Data to Google Sheets

In this guide, we’ll walk through how to pull data from the BigCommerce 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 BigCommerce API Key

  1. Log in to BigCommerce and go to Settings › API Accounts 
  2. Under API accounts, click +Create API account
  3. Set the token type to V2/V3 API token, and enter a name. Note the ID in the API Path, we'll refer to this as your_path_id later.
    bigcommerce-path
  4. Select the scopes to which you'd like your token to have access (info).
  5. Click Save and note the value in the Access token field. Keep it handy as you'll need it in a moment.
    bigcommerce-accesstoken
  6. Congrats! You're now ready to use the BigCommerce API.

Part 2: Pull BigCommerce API Data into Sheets

For this example, we'll get a list of orders. Substitute in your own path ID and access token where it says your_path_id and your_access_token.

  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://api.bigcommerce.com/stores/your_path_id/v2/orders?min_date_created=2023-03-01
    • Headers:
      • Content-Type: application/json
      • X-Auth-Token: your_access_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 data populate your sheet.
    bigcommerce-response

Part 3: API Documentation

Official API documentation: https://developer.bigcommerce.com/docs/418a24b0d810a-orders-overview

Leave a Comment

Jump To