Create or refresh Ship24 tracking results in Google Sheets

Track shipments more efficiently by connecting Google Sheets with Ship24. This template scans your sheet for active tracking numbers, creates or updates Ship24 trackers, retrieves the latest shipment status, and writes the results back into your spreadsheet. It’s ideal for small fulfilment teams, marketplace operators, or anyone who wants a simple way to monitor deliveries without manual checking.

The workflow includes three main steps:

1. Detect active shipments The scenario searches your Google Sheet for rows that contain a tracking number and where the latest status is not “Delivered”. This ensures that only shipments still in transit are processed.

2. Create a Ship24 tracker and fetch results For each active row, the template calls Ship24’s “Create Tracker and Get Tracking Results” endpoint. If your sheet includes a courier code, it is passed through for improved accuracy; otherwise, Ship24 tries to automatically detect the courier.

3. Update your Google Sheet The scenario updates the row with the newest tracking event and the timestamp of the check, keeping your spreadsheet up to date.

Before you begin Your Google Sheet should include at least the following columns: • Tracking Number • Latest Status • Last Check • (Optional) Courier Code

You may rename these columns, but your scenario mappings must be updated accordingly after importing the template.

This template was created by Ship24. For support, feedback or guidance, visit https://www.ship24.com