Import Tracktry Data to Google Sheets

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

Contents

• Before You Begin
• Part 1: Get Tracktry API Key
• Part 2: Pull Tracktry API Data into Sheets
• Part 3: Handle Pagination
• Part 4: API Documentation

Before You Begin

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

Part 1: Get Your Tracktry API Key

1. Log in to Tracktry
2. Navigate to https://my.tracktry.com/setting#apikey
3. Your API key will be available on that page. Copy it and keep it handy as we'll use it shortly.
   

Part 2: Pull Tracktry API Data into Sheets

For this example, we'll get a list of trackings. Substitute in your own API key where it says your_api_key.

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.tracktry.com/v1/trackings/get?limit=2000
   • Headers
     • Tracktry-Api-Key: your_api_key
3. Optionally apply other parameters to filter on create time, status, etc, as shown in the documentation.
4. Create a new tab and click Set current to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see shipment trackings populate your Google Sheet.
   
   

Part 3: Handle Pagination

By default, the Tracktry API will only return 100 records. To get more, set the limit parameter to 2000. To get even more than that, you can loop through multiple pages of data using pagination handling:

• Pagination type: page parameter
• Page parameter: page
• Run until: choose when to stop fetching data
  

Part 4: API Documentation

Official API documentation: https://www.tracktry.com/api-track-list-all-track.html#get