Search API Connector Documentation
Import ShipStation Data to Google Sheets
In this guide, we’ll walk through how to pull data from the ShipStation API directly into Google Sheets, using the API Connector add-on for Sheets.
We'll first get credentials from ShipStation, and then set up a request to pull in data to your spreadsheet.
- Before You Begin
- Part 1: Get ShipStation API Credentials
- Part 2: Pull ShipStation API Data into Sheets
- Part 3: View Data in a Grid
- Part 4: Handle Pagination
- Part 5: API Documentation
Before You Begin
Click here to install the API Connector extension from the Google Marketplace.
Part 1: Get ShipStation API Credentials
- Sign in to ShipStation and click the Settings icon in the main navigation menu
- In the sidebar on the left, click Account > API Settings
- In the API Settings section, click the Generate API Keys button
- You'll now see an API Key and API secret.
- One last step: Because the ShipStation API requires Basic Authentication, we need to encode our authentication info to base 64. You can do this by entering your your credentials in the format
API_KEY:API_SECRETinto this form (i.e. your API key, then a colon, and then your API secret).
The encoding script runs in your browser, and none of your credentials are seen or stored by this site.
- Keep this value handy as we'll use it in the next step to fetch data from ShipStation.
Part 2: Pull ShipStation API Data into Sheets
You can connect to any of the request URLs provided in ShipStation's API documentation. Here's a complete sample request to show how it works:
Request configuration example
- Request URL:
Part 3: View Data in a Grid
By default, data will print out with one row for each order ID. Each item in the order will get its own column. If you prefer, you can have each item print down into subsequent rows instead of columns by switching to grid style and flattening headers (as otherwise each option value produces a new row).
- Output options > Report style > grid (tick the 'unwind data' box)
- Output options > Flatten field to header > custom
- Path to header:
- Path to value:
- Path to header:
Part 4: Handle Pagination
By default, the Shipstation API will only return 100 records. To get more, set the
pageSize parameter to 500. To get even more than that, you can loop through multiple pages of data using pagination handling (paid feature):
- Pagination type:
- Page parameter:
- Run until: choose when to stop fetching data
Part 5: API Documentation
Official API documentation: https://www.shipstation.com/docs/api/