Track shipments automatically and update Google Sheets every 3 hours
Make.com6 modulesv1.0Keep 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
At a glance
Track shipments automatically and update Google Sheets every 3 hours is a ready-made Make.com workflow you import as a blueprint JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- Make.com
- Connects
- Google Sheets
- Modules
- 6
- Price
- Free
- Version
- v1.0
About this workflow
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
How to import this Make.com workflow
- 1
Download the blueprint JSON file after purchase.
- 2
Open Make.com → go to Scenarios → click Import Blueprint.
- 3
Select the downloaded JSON file and confirm.
- 4
Connect your app credentials in each module.
- 5
Run once manually to test, then activate the schedule.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related Make workflows
Smart Shopify agent: AI-powered abandoned cart recovery
Turn new Shopify products into SEO blogs with Perplexity, Gemini and Sheets
Send a group SMS message to contacts in your Google Sheets spreadsheet
Add new leads from Facebook Lead Ads to Google Sheets (multiple vairables)
Add courses to Edusign from new Google Sheets rows
Add Reamaze contacts from new Google Sheets rows
Send e-mail addresses from new e-mails in Gmail to Facebook Custom Audiences
Create Pipedrive CRM persons for new Circle members
Reviews
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.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with Make.com
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you