Send Zendrop Order Tracking Updates Automatically via WhatsApp
Automatically fetch order tracking updates from Zendrop and send them to customers via WhatsApp. Store owners save time and boost customer satisfaction without manually copying tracking numbers.
- 1
Schedule a regular check for new Zendrop shipments
Add a
Schedule Triggernode. SetTrigger Intervalto every 1 hour (or 30 minutes for faster updates). This node wakes up the workflow automatically so you never have to run it manually. - 2
Fetch shipped orders from Zendrop API
Add an
HTTP Requestnode. SetMethodto GET andURLtohttps://app.zendrop.com/api/v1/orders?status=shipped. In theHeaderssection addAuthorizationwith valueBearer YOUR_ZENDROP_API_KEY. Add your Zendrop API key in the node'sNotesfield as a reminder. This returns a list of shipped orders with tracking numbers. - 3
Look up customer phone numbers from Google Sheets
Add a
Google Sheetsnode set toRead Rowsoperation. Point it to your orders spreadsheet that contains columnsorder_idandcustomer_phone. Use={{ $json.id }}in theLookup Column Valuefield to match each Zendrop order to a customer phone number. Make sure your sheet is shared with the Google service account credential. - 4
Build the WhatsApp message text
Add a
Setnode. Create a field calledmessagewith value:Hi! Your order #{{ $json.order_id }} has shipped. Track it here: {{ $json.tracking_url }}. Create a second field calledphonemapped to={{ $json.customer_phone }}. This prepares clean data for the WhatsApp sender. - 5
Send the tracking message via WhatsApp
Add a final
HTTP Requestnode. SetMethodto POST andURLto your WhatsApp Business API endpoint (e.g.https://waba.360dialog.io/v1/messagesfor 360dialog orhttps://api.twilio.com/2010-04-01/Accounts/YOUR_SID/Messages.jsonfor Twilio). InBody, settoto={{ $json.phone }},typetotext, andtext.bodyto={{ $json.message }}. Add your API key or Twilio credentials in theHeadersorAuthsection.
Frequently asked questions
What if I do not have a Zendrop API key?
Log into your Zendrop account and go to Settings > API. Generate a new API key there. You need at least the Pro plan for API access. Paste the key into the Authorization header of the second node.
Can I use a free WhatsApp solution instead of a paid API?
Yes. Twilio offers a free WhatsApp sandbox for testing that lets you send messages to approved numbers at no cost. Once you are ready for production, you will need an approved WhatsApp Business number through Twilio or 360dialog.
How do I avoid sending duplicate tracking messages to the same customer?
Add a column called `tracking_sent` to your Google Sheets order list. After sending a message successfully, use a Google Sheets update step to mark that row as `yes`. Then add an IF node before the WhatsApp step to skip rows where `tracking_sent` already equals `yes`.