Track shipments with DHL/Delhivery APIs & send Google Sheets updates to customers via WhatsApp/Email
Streamline your logistics by automatically monitoring DHL and Delhivery shipments and syncing their statuses directly into Google Sheets. This workflow ensures customers stay informed with instant delivery updates delivered via WhatsApp and email notifications. It is a robust solution for businesses looking to enhance their post-purchase experience through real-time tracking automation.
Run this with your team's AIWhat This Recipe Does
Managing logistics often involves a repetitive cycle of checking tracking numbers and responding to customer inquiries about delivery status. The Daily Shipment Tracker automates this entire lifecycle, transforming a manual spreadsheet into a proactive communication tool. Every day, the system scans your Google Sheets for active shipments and connects directly to courier APIs to retrieve the latest delivery progress. By comparing real-time data against your records, the automation identifies status changes and triggers personalized email alerts to your customers. This ensures that your clients are always informed about their orders, significantly reducing the volume of inbound support requests. For business owners, this means more time focused on growth and less on administrative oversight. The app provides a centralized dashboard to monitor all transit activity, ensuring that no package is lost and every delay is caught early. By bridging the gap between logistics data and customer communication, you build trust through transparency and operational efficiency.
What your team gets
Forms and dashboards, so it is not a script only one person understands
Runs on your schedule in the cloud, so it does not stop when a laptop closes
Endpoints, so the rest of your stack can trigger the same work
Google Sheets connected for the team, not per person
How It Works
- 1
Open the recipe and connect your accounts
Connect Google Sheets once, in your team cloud, and nobody has to do it again on their own machine
- 2
Tell your own agent what is different about your process
Claude, ChatGPT, Cursor, whichever your team already uses. It adapts the recipe to how you actually work
- 3
Run it, then leave it running
It lives in your team cloud, so it keeps going after you close the laptop and every teammate's AI can use it
Who Uses This
- E-commerce retailers use this to provide automated delivery updates to customers, reducing support inquiries regarding order status.
- Logistics coordinators use this to monitor bulk shipments across multiple couriers in a single view, ensuring all delivery deadlines are met.
- Wholesale distributors use this to notify business clients of incoming inventory shipments, allowing them to plan their warehouse staffing more effectively.
Frequently Asked Questions
Do I need to manually trigger the tracking updates?
No, the system is designed to run automatically on a daily schedule, though you can also trigger an instant update manually whenever you need real-time data.
Which courier services can this automation track?
It connects via API to support major global and local carriers, including FedEx, UPS, DHL, and USPS, as long as you have the tracking credentials for the Courier API service.
Can I customize the email notifications sent to my customers?
Yes, you can fully edit the email content and design to match your brand voice and include specific order details pulled directly from your spreadsheet.
What happens if the tracking information is unavailable?
The system includes built-in logic to identify missing data or errors, ensuring that customers only receive accurate updates and flagging any issues for your internal team to review.
Coming from n8n?
This recipe uses nodes like Cron, GoogleSheets, Filter, HttpRequest and 4 more. On Runwork, you don't need to learn n8n's workflow syntax. Describe what you want to your own AI agent in plain English.
Based on n8n community workflow. View original
Related Recipes
Taxi service provider (production-ready, part 4)
The Taxi Service Provider automation offers a comprehensive solution for managing transportation logistics and fleet operations. By centralizing the dispatch process, this system eliminates the manual overhead typically associated with ride coordination and driver management. It leverages high-performance data handling to ensure that passenger requests are matched with available resources in real-time, reducing wait times and improving service reliability. Business owners can maintain a complete record of every trip, payment, and driver status without manually updating spreadsheets or switching between disconnected tools. The automation handles complex logic for ride routing and status updates, allowing your team to focus on customer service rather than administrative tasks. This system is designed to scale with your business, providing the architectural foundation needed to manage a handful of vehicles or a large-scale metropolitan fleet. By integrating robust data storage and rapid processing, it ensures that your operations remain smooth, transparent, and data-driven, ultimately leading to higher driver retention and increased passenger satisfaction.
🚛🗺️ Geocoding for logistics with Open Route API and Google Sheets
This transportation management automation streamlines the process of synchronizing logistics data between external APIs and internal tracking systems. By connecting direct HTTP requests with Google Sheets, the workflow eliminates the need for manual data entry and reduces the risk of human error in shipment tracking. The automation handles large datasets efficiently by processing information in batches, ensuring that high volumes of delivery or fleet information are updated systematically without system timeouts. For logistics managers and dispatchers, this means real-time visibility into transportation metrics, automated status updates, and a centralized source of truth for all transit activities. By automating the retrieval and storage of transportation data, businesses can focus on optimizing routes and improving delivery timelines rather than managing spreadsheets.
Smart shipping prioritization with Google Gemini and Google Sheets
The n8n Terminal automation transforms your transportation and logistics data management into a streamlined, automated process. By connecting webhooks with Google Sheets, this tool acts as a central hub for logging trip details, tracking delivery milestones, and managing fleet schedules in real-time. Instead of manually updating spreadsheets or switching between disparate logistics platforms, business owners and operations managers can capture critical data points instantly through a simplified interface. This automation ensures that every entry is accurately time-stamped and organized, providing a single source of truth for your entire operation. The result is improved data accuracy, reduced administrative overhead, and faster decision-making based on live transportation metrics. Whether you are managing a small local delivery team or a large-scale shipping operation, this automation provides the structural backbone needed to scale your logistics without increasing manual workload. By centralizing your data flow, you eliminate communication gaps and ensure that your team always has access to the most current information.
Live flight fare tracker with Aviation Stack API – alerts via Gmail & Telegram
Managing travel expenses is a significant challenge for modern businesses. The Live Flight Fare Tracker automates the tedious process of manual price monitoring, ensuring you never overpay for corporate travel again. By integrating real-time flight data with your existing communication channels, this automation identifies price fluctuations the moment they occur. The system continuously tracks specific routes, logs historical pricing data in Google Sheets for trend analysis, and triggers instant alerts via Gmail and Telegram when fares drop below your specified threshold. For companies with frequent travel requirements or remote teams, this tool transforms a reactive booking process into a proactive cost-saving strategy. Instead of assigning staff to refresh booking sites, your team can focus on high-value tasks while the automation handles the surveillance. This ensures your travel budget goes further, allowing for more strategic resource allocation and significant annual savings on transportation overhead. It bridges the gap between raw data and actionable insights, providing a competitive edge in travel procurement and budget management.
Run this with the AI your team already uses
Your agent adapts it, your team cloud keeps it running, and everyone's AI can find it.
Open this recipe in Runwork