Get Daily Zendrop Fulfillment Success Rate Alerts in MS Teams
Automatically pull your Zendrop order fulfillment stats every day and post a clear success rate summary directly into a Microsoft Teams channel. Keep your entire team informed without logging into Zendrop manually.
- 1
Schedule the daily trigger
Add a
Schedule Triggernode. SetTrigger IntervaltoDaysandDays Between Triggersto1. Set the trigger time to something like 8:00 AM so your team sees the report at the start of their day. - 2
Fetch fulfillment data from Zendrop
Add an
HTTP Requestnode connected to the Schedule Trigger. SetMethodtoGETandURLtohttps://app.zendrop.com/api/v1/orders(or your Zendrop API orders endpoint). UnderAuthentication, chooseHeader Authand add your Zendrop API key asAuthorization: Bearer YOUR_API_KEY. Add query parametersstatusset tofulfilledandcreated_at_minset to yesterday's date using the expression{{ new Date(Date.now() - 86400000).toISOString().split('T')[0] }}. Store the credential details in the nodeNotesfield. - 3
Calculate the fulfillment success rate
Add a
Setnode. Create three fields:totalOrdersusing expression{{ $json.total_count }},fulfilledOrdersusing expression{{ $json.fulfilled_count }}, andsuccessRateusing expression{{ Math.round(($json.fulfilled_count / $json.total_count) * 100) }}. If Zendrop returns an array, adjust the expressions to reference the correct response shape from the previous node. - 4
Format the Teams message
Add a second
Setnode. Create a single field calledteamsMessagewith the value:Daily Fulfillment Report Total Orders: {{ $json.totalOrders }} Fulfilled Orders: {{ $json.fulfilledOrders }} Success Rate: {{ $json.successRate }}% Powered by Zendrop + n8n. This shapes the message text before sending. - 5
Post the report to Microsoft Teams
Add a
Microsoft Teamsnode. SetOperationtoCreate Messageand select your targetChannel. SetMessageto{{ $json.teamsMessage }}. Connect your Microsoft 365 credentials using OAuth2. In the nodeNotes, record which Teams channel and tenant you are targeting. Connect this node to the second Set node to complete the workflow.
Frequently asked questions
What if Zendrop does not have a public API endpoint for orders?
Check your Zendrop account under Settings or Developer options for your personal API key and available endpoints. If a direct orders API is not available on your plan, consider exporting a CSV report and triggering the workflow via an email attachment or Google Sheets integration instead.
Can I change the Teams channel the message is posted to?
Yes. In the Microsoft Teams node, you can select any channel your connected Microsoft 365 account has access to. Simply change the Team and Channel fields in the node configuration to point to a different channel at any time.
How do I change the report from daily to weekly?
Open the Schedule Trigger node and change the `Trigger Interval` from `Days` to `Weeks`. Also update the `created_at_min` date expression in the HTTP Request node to subtract 7 days instead of 1 by changing `86400000` to `604800000` so you capture the full week of orders.
Automatically Back Up Every Zoom Recording to Google Drive the Moment It Finishes
When a Zoom cloud recording is completed, this workflow instantly uploads the recording file to a designated Google Drive folder. Consultants never lose a client session recording again.
Free recipeAutomatically Sync Zendrop Products to an Airtable Base Daily
Fetch your latest product catalog from Zendrop via API and upsert each product into an Airtable base automatically. Data teams stay current without any manual copy-paste work.
Free recipeAutomatically Celebrate in Slack Every Time a Trello Card Moves to Done
When a Trello card is moved to your Done list, this workflow instantly posts a fun celebration message in a Slack channel so the whole team can cheer together. No manual updates needed — every win gets recognized automatically.