Import BigCommerce Data to Google Sheets

Last Updated OnMarch 5, 2023

byAna

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.

Before You Begin

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

Log in to BigCommerce and go to Settings › API Accounts
Under API accounts, click +Create API account
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.
Select the scopes to which you'd like your token to have access (info).
Click Save and note the value in the Access token field. Keep it handy as you'll need it in a moment.
Congrats! You're now ready to use the BigCommerce API.

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.

Open up Google Sheets and click Extensions > API Connector > Open > Create request.
In the request form enter the following:
- Application: Custom
- Method: GET
- Request URL: https://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
Create a new tab and click Set current to use that tab as your data destination.
Name your request and click Run. A moment later you’ll see data populate your sheet.