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 2,500+ 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?


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 your 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 in your Ship24 dashboard.


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, and prepare the sheet for tracking operations.


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 to an existing sheet


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, and leave your existing columns, order, and custom fields unchanged.


Once your API key is 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 ISO 3166 country code of the shipment origin, for example US, GB, FR. Optional but can improve tracking accuracy.
  • destinationCountryCode - Two-letter ISO 3166 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 tracking events.
  • shippingDate - The shipment dispatch date. Make sure it 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 service.
  • trackingUrl - A direct tracking URL for the shipment. Optional.
  • orderNumber - Your internal order number related to the shipment. Optional.
  • title - Shipment title, maximum 100 characters.
  • recipientEmail - Recipient email for notifications.
  • recipientName - Recipient name.
  • recipientPhone - Recipient phone number in international format.
  • note - Additional note, maximum 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 and output fields


  • apiStatus - Result of the 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 and 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.


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 keep performance stable and reduce the number of API calls:


  • 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 the 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
  • Remember the 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, for example invalid email or tracking number format
  • Correct the input and retry


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

Updated on: 14/08/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!