Quick Overview
This workflow polls the Jumia Vendor API for recent orders, formats each new order into a readable alert, and sends notifications to both Telegram and WhatsApp, while tracking processed order IDs in an n8n Data Table to prevent duplicate messages.
How it works
- Runs manually or on a 5-minute schedule to start the order-check process.
- Requests an access token from the Jumia Vendor API using a refresh token.
- Fetches recent orders from the Jumia Vendor API and normalizes the order data into a consistent structure.
- Checks an n8n Data Table to skip any orders that have already been processed.
- Formats a detailed notification message containing order, customer, totals, and shipping information.
- Sends the notification to a Telegram chat and then sends the same message via the WhatsApp Cloud API.
- Inserts the order ID and metadata into the n8n Data Table to mark the order as processed.
Setup
- Provide your Jumia Vendor API values (client_id, refresh_token, and seller ID) in the HTTP request and normalization steps.
- Create an n8n Data Table named
jumia_processed_orders with columns seller_id, marketplace, order_id, status, first_seen, notified_at, and raw_payload.
- Add Telegram credentials and set your target Telegram chat ID.
- Add WhatsApp Cloud API (Meta) credentials and set your phone number ID and recipient WhatsApp number.
- Test with the Manual Trigger, then enable the 5-minute schedule trigger (and adjust the interval if needed).