Articles on: Integrations

Ship24 Order Tracking for Google Sheets

Introduction

Ship24 Order Tracking allows you to create, update and refresh shipment trackers directly from Google Sheets using the Ship24 API.

Ship24 supports tracking across 1500+ couriers and marketplaces worldwide, helping you manage delivery updates in one place.

This add-on is designed for sellers who manage orders in spreadsheets and want to retrieve tracking updates in bulk without leaving Google Sheets.


Google sheet Add-on

In this article

What does the Add-on do?

Requirements

Setup

Sheet structure requirements

Individual actions

Bulk actions

Limits and safeguards

Troubleshooting


What does the Add-on do?

Ship24 Order Tracking makes it easy to create and manage shipment tracking directly from your Google Sheet, without switching between tools or copying tracking numbers manually.


With Ship24 Order Tracking, you can:

  • Create shipment trackers from tracking numbers
  • Create a tracker only (without retrieving results)
  • Create and instantly retrieve tracking results
  • Refresh tracker status updates
  • Update existing trackers
  • Run bulk operations on selected rows

All actions are triggered manually from the sidebar inside Google Sheets.


Requirements

Before using the Add-on, you will need:

  • A Ship24 API key
  • A Google Sheets document
  • A properly structured header row

You can insert the required headers automatically using the Setup action inside the Add-on.


Setup


Set API Key

To create trackers using the Ship24 API, you first need to link the Add-on to your Ship24 account.

You can find your API key at: https://dashboard.ship24.com/integrations/api-keys


From your tracking Google Sheet:

  1. Open Extensions → Ship24 Order Tracking.
  2. In the Setup section, click Open Settings.
  3. Enter your Ship24 API Key.
  4. Click Save API Key

Set API Key

Insert required headers

To ensure your tracking sheet is compatible with the Add-on, first insert the required headers using the built-in tool.

  1. Open Extensions → Ship24 Order Tracking.
  2. In the Setup section, click Insert required headers.

The add-on will:

  • Insert the required header row
  • Freeze row 1
  • Prepare the sheet for tracking operations

Important:

  • Start with a blank sheet before inserting headers.
  • You may add, remove or rearrange columns later, but the header names must remain unchanged.

Insert required headers

Once you have your API Key set and your Google Sheet has the correct headers, you are ready to start using the Add-on.


Sheet structure requirements


Column reference guide

The list below details each required column name and what it represents. The name shows how it should appear in row 1 of your sheet. These names must match exactly.


  • trackingNumber - The shipment tracking number provided by the courier or marketplace. Required to create a tracker.
  • shipmentReference - Your internal reference for the shipment, such as an order ID or invoice number. Optional.
  • clientTrackerId - A custom identifier assigned by you to link the tracker to your own system. Optional.
  • originCountryCode - Two-letter ISO3166 country code of the shipment origin, for example US, GB, FR. Optional but can improve tracking accuracy.
  • destinationCountryCode - Two-letter ISO3166 country code of the shipment destination. Optional but recommended for international shipments.
  • destinationPostCode - Destination postal or ZIP code. Recommended as certain couriers require it to retrieve the tracking events.
  • shippingDate - The shipment dispatch date. Please ensure the provided shipping date aligns closely with the actual shipment date, give or take a few days. 
  • courierCode - The Ship24 courier code if known, for example dhl, fedex, ups. Recommended as it helps avoid collecting events from unrelated parcels that use the same tracking number.
  • courierName - Courier name and/or service
  • trackingUrl - A direct tracking URL for the shipment. Optional.
  • orderNumber - Your internal order number related to the shipment. Optional.
  • restrictTrackingToCourierCode - If set to true, the tracker will only track the courier specified in the courierCode field. Otherwise, Ship24 may extend the tracking to other providers in case the shipment is handled by additional couriers.
  • apiStatus - Displays the result of the last API action, including success, skipped, or error messages. Written automatically by the add-on.
  • trackerId - The unique Ship24 tracker identifier created after a successful tracker creation. Required for refresh and update actions.
  • statusCode - The latest shipment status code returned by Ship24, for example delivery_delivered. Written automatically by the add-on.
  • statusCategory - High-level shipment status category such as Delivered, In Transit, or Exception. Written automatically by the add-on.
  • statusMilestone - Shipment milestone description, such as Out for delivery or Delivered. Written automatically by the add-on.
  • isSubscribed - If TRUE, enables tracking event subscriptions for the tracker. Used only for updating the tracker to notify Ship24 to resume/stop checking for events.
  • lastCheckedAt - Date and time when the tracker was last refreshed. Automatically populated by the add-on.
  • lastCheckedBy - Indicates which action performed the last refresh, for example trackerId or track. Automatically populated.


Key points:

The Add-on matches columns by header name, not position.

If headers are renamed or removed, actions may fail.


Individual actions

Individual actions apply to the currently selected row only. You can select the whole row or any cell on the row.

  • Create Only - Creates a tracker using the bulk endpoint but does not retrieve shipment results.
  • Create & Track - Creates a tracker and retrieves the latest shipment status immediately.
  • Refresh - Retrieves the latest tracking results using the trackerId.
  • Update - Updates tracker settings such as subscription status, destination data, or courier information.

Important:

Make sure you select a data row, not the header row.


Bulk actions

Bulk actions apply to the currently selected rows. You can select the whole row or any cell on the row.

  • Create Only - Creates trackers for selected rows without retrieving results.
  • Create & Track - Creates trackers and retrieves shipment results for selected rows.
  • Refresh - Refreshes shipment status for selected rows using trackerId.

To use bulk actions:

  1. Open the Add-on
  2. Select multiple data rows
  3. Click the desired bulk action

Bulk Actions

Limits and safeguards

To ensure stable performance and reduce API pressure:

  • Bulk Create Only is limited to 100 rows per run
  • Other bulk actions are limited to 25 rows per run
  • Delivered shipments are automatically skipped during refresh
  • Shipments refreshed within the last 3 hours are skipped
  • Rows created using Create Only can be refreshed immediately
  • API calls include short delays between rows
  • If a row fails, processing continues for remaining rows

If a limit is exceeded, you will see a message indicating the maximum allowed rows per run.


Troubleshooting

Headers are missing

  • Ensure the header names match exactly
  • Use the Insert required headers action on a blank sheet


Bulk action stops unexpectedly

  • Reduce the number of selected rows
  • Limits: Create Only: 100 rows, other bulk actions: 25 rows


API key error

  • Open Settings in the add-on
  • Confirm your Ship24 API key is saved


Tracking data not updating

Check that:

  • trackerId exists
  • The shipment is not already delivered
  • The 3 hour refresh cooldown has passed
  • The row was not created using Create Only and never refreshed



If you continue experiencing issues, contact the Ship24 support team.

Updated on: 20/02/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!