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 2500+ 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.

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 valid Ship24 plan and API key
• A Google Sheets document
• A properly structured header row

You can insert or update headers automatically using the Setup section 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

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.

Add missing headers (for existing sheets)

If you already have a sheet in use and new fields are introduced:

1. Open Extensions → Ship24 Order Tracking
2. Click Add missing headers

The add-on will:

• Detect missing required columns
• Append only the missing columns to the end of the sheet
• Leave existing columns, order, and custom fields unchanged

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.
• title - Shipment title (max 100 characters)
• recipientEmail - Recipient email for notifications
• recipientName - Recipient name
• recipientPhone - Recipient phone number (international format)
• note - Additional note (max 500 characters)
• 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.

System / output fields:

• apiStatus - Result of last action
• trackerId - Ship24 tracker ID
• statusCode - Latest shipment status code
• statusCategory - High-level status
• statusMilestone - Shipment milestone
• latestEventStatus - Latest tracking event description
• latestEventDatetime - Latest event date/time
• isSubscribed - Subscription status
• lastCheckedAt - Last refresh timestamp
• lastCheckedBy - Action that last updated the row

Key points:

• The Add-on matches columns by header name, not position
• You can reorder columns freely
• You can add custom columns
• Missing required columns can be added using the Setup tool

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 Status - Retrieves the latest tracking results using the trackerId.
• Update Details - 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 Status - 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

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 or Add missing headers action

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

Validation errors shown in apiStatus

• Review the message returned (e.g. invalid email, tracking number format)
• Correct the input and retry

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

Updated on: 08/04/2026