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
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
Platform
Make
Category
Shipment Tracking
Price
$2.99
Creator
QualityWorkflows
automation
make
google-sheets
builtin
How to import this workflow into Make
1Purchase or download the workflow to get the Make blueprint JSON file.
2In Make, create a new scenario, click the three-dots menu, and choose "Import Blueprint".
3Reconnect each module to your own app connections when prompted.
4Run the scenario once to verify it, then set your schedule and turn it on.