Print

Import Ship24 Data to Google Sheets

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

Contents

Before You Begin

Click here to install the API Connector extension from the Google Marketplace.

Part 1: Get Your Ship24 API Key

  1. Log into your account on ship24.com
  2. From the main dashboard, click Tracking API Keys
    ship24-apikey
  3. An API key will already be generated for you, or you can choose to generate a new one. Click Copy.
    ship24-apikey-copy
  4. This key will be used in a request header, and should be prefaced by the word Bearer. More on that below.

Part 2: Pull Ship24 Courier Data into Sheets

For our first API request, we'll get a list of couriers.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • Application: Custom
    • Method: GET
    • Request URL: https://api.ship24.com/public/v1/couriers
    • Headers:
      • Authorization: Bearer your_api_key
  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 a list of couriers populate your sheet.
    ship24-response

Part 3: Pull Ship24 Tracking Data into Sheets

In the request form enter the following:

  • Application: Custom
  • Method: POST
  • Request URL: https://api.ship24.com/public/v1/trackers/track
  • Request body: {"trackingNumber": "your_tracking_number"}
  • Headers:
    • Authorization: Bearer your_api_key
ship24-trackers-respones

For the request body, optionally include additional information using the shipmentReference, originCountryCode, destinationCountryCode, destinationPostCode, shippingDate, and courierCode keys. Tracking numbers are not unique, so providing more information helps ensure you track the correct shipment.

Part 4: API Documentation

Postman documentation: https://documenter.getpostman.com/view/14877026/Tz5s4Gtu


Leave a Comment

Jump To