Runwork
Google Sheets

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.

Start Building

What This Recipe Does

Managing shipment logistics manually is a significant drain on time and a common source of customer frustration. This automation transforms your Google Sheets shipment log into a proactive tracking system. By connecting directly to courier APIs, the application automatically retrieves the latest status for every package in your queue. It eliminates the need for staff to manually visit carrier websites to check tracking numbers. When a package moves to a new stage—such as being out for delivery or successfully arrived—the system immediately notifies the customer via email. This proactive communication significantly reduces the volume of inbound support inquiries regarding order status and improves the overall post-purchase experience. For business owners and logistics managers, this means a more accurate overview of delivery performance and a streamlined operation that scales without adding headcount. Your team can focus on resolving actual delivery issues rather than just reporting on them, ensuring your shipping operations remain efficient and customer-centric.

What You'll Get

Complete App

Forms, dashboards, and UI components ready to use

Automated Workflows

Background automations that run on your schedule

API Endpoints

REST APIs for external integrations

Connected Integrations

Google Sheets configured and ready

How It Works

  1. 1

    Click "Start Building" and connect your accounts

    Runwork will guide you through connecting Google Sheets

  2. 2

    Describe any customizations you need

    The AI will adapt the recipe to your specific requirements

  3. 3

    Preview, test, and deploy

    Your app is ready to use in minutes, not weeks

Who Uses This

Frequently Asked Questions

Can I connect this to different shipping carriers?

Yes, the automation uses a flexible API connector that can be configured to communicate with any major courier service that provides a tracking API.

Do I need to manually trigger the status checks?

While the workflow can be started manually, it is designed to run on a scheduled basis, such as every morning or every hour, to keep your data current.

Can I customize the email content sent to customers?

The email component is fully customizable, allowing you to include your company branding, specific order details, and personalized messaging.

What happens if a tracking number is incorrect?

The system includes logic to identify and filter out invalid requests, ensuring that your automation continues to run smoothly even if there are data entry errors in your spreadsheet.

Importing from n8n?

This recipe uses nodes like Cron, GoogleSheets, Filter, HttpRequest and 4 more. With Runwork, you don't need to learn n8n's workflow syntax—just describe what you want in plain English.

Cron GoogleSheets Filter HttpRequest If Code EmailSend StickyNote

Based on n8n community workflow. View original

Related Recipes

Ready to build this?

Start with this recipe and customize it to your needs.

Start Building Now