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 updat
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
Download the blueprint JSON file after purchase.
Open Make.com → go to Scenarios → click Import Blueprint.
Select the downloaded JSON file and confirm.
Connect your app credentials in each module.
Run once manually to test, then activate the schedule.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.