Track shipments automatically and update Google Sheets every 3 hours

Keep your shipment data up to date with this automated tracking workflow using Google Sheets and Ship24. This template identifies new shipments, creates Ship24 trackers for them, and refreshes tracking results every 3 hours for active (non-delivered) shipments. It is ideal for ecommerce sellers, fulfilment teams, and operational workflows where timely status updates are essential.

The scenario follows two automated routes:

1. Create new trackers

The workflow looks for rows where the Last update column is empty, meaning these shipments have not yet been checked. It calls Ship24’s “Create Tracker and Get Tracking Results” endpoint, retrieves the latest tracking event, and updates the row with the tracker ID, current status, and the timestamp of the check.

2. Refresh tracking results every 3 hours

For rows that have been checked previously, the template examines the Last update column. If more than 3 hours have passed and the shipment is not marked as “Delivered”, Ship24 is queried again to pull any new events. The Google Sheet is updated with the latest status and a refreshed check time.

Before you begin

Your Google Sheet should include at least the following columns:

• Tracking Number

• Latest Status

• Last Update (timestamp of last check)

• Tracker ID (created automatically)

Additional optional columns such as Courier Code may also be included.

This template was created by Ship24. For support, questions, or feedback, visit:

https://www.ship24.com