0%
PRAXIUM LABS

Namaste! 🇳🇵

You found our hidden gem! Something incredible is brewing in the heart of the Himalayas. We might have something special here for you soon.

Stay curious. Jay Nepal!

Share

Auto-Import Daraz Orders to Google Sheets with n8n (2026 Recipe)

Auto-Import Daraz Orders to Google Sheets with n8n (2026 Recipe)

TL;DR. Daraz Open Platform exposes a Seller Order API. The n8n recipe below polls it every 60 seconds, deduplicates by order ID, writes new rows to Google Sheets, and sends a WhatsApp alert on every order above NPR 5,000. Setup takes under 90 minutes; build cost is NPR 25,000–40,000 if you outsource it. Saves roughly 30–60 minutes per day for a seller doing 50+ orders/day.

Praxium Labs ships this for Nepali clients — here is what works. If you sell on Daraz Nepal, the seller dashboard is the bottleneck — opening it every hour, copying new orders into a spreadsheet, and tagging them by status is the daily routine that automation eliminates first. Here is the n8n workflow we ship to every Daraz client.

Why Daraz needs an automation layer

Sellers above ~20 orders/day routinely lose time on three friction points: (1) the seller dashboard does not let you bulk-export filtered orders, (2) there is no native WhatsApp integration, (3) reconciling Daraz payouts against your accounting system is manual. n8n bridges all three.

The Daraz API in 5 lines

Daraz Open Platform is a Lazada-derived API. Authentication uses HMAC-SHA256 signing of sorted query parameters. Order data comes from GetOrderList (paginated) and GetOrderItems (line items). Rate limit: 500 req/min — comfortable for any seller below 50,000 orders/month.

The n8n nodes you need

  • Schedule Trigger: every 60 seconds
  • Function: build the signed query (sorts params + HMAC)
  • HTTP Request: GET to https://api.daraz.com.np/rest with the signed params
  • IF / Filter: only orders newer than last_seen_id
  • Set: reshape Daraz fields into your Sheet column order
  • Google Sheets: Append Row (use service-account auth)
  • Static Data: store last_seen_id so the next run starts from there
  • Error Trigger workflow: separate workflow that catches failures across all workflows and pings ops

Common breakage and the fixes

  • Signature mismatch: Daraz is strict about parameter sorting and UTF-8 encoding. Build the signature in a Function node and log the canonical string the first 5 runs — it is always a sort order or escape issue.
  • Token expiry: Daraz access tokens expire after 6 hours by default. Add a refresh sub-workflow that runs every 5 hours and updates a credential.
  • Duplicate rows on retry: always dedupe by order_id in the Google Sheet, not just by timestamp.
  • Rate limit (429): add an exponential backoff (n8n's built-in Retry on Fail with 3 attempts and 30s delay).

What to do with the data once it is in Sheets

A Sheet is the staging layer, not the endpoint. From there: (a) push into QuickBooks for accounting, (b) trigger WhatsApp confirmations, (c) feed a Looker Studio / Power BI dashboard, (d) feed your inventory system to decrement stock. Each downstream step is another n8n workflow that triggers off the Sheet row insertion.

Frequently asked questions

Does Daraz Nepal have a webhook?

No, Daraz Open Platform does not currently push webhooks for new orders in Nepal. The standard pattern is polling — every 60 seconds is well within rate limits and feels real-time to ops staff. If Daraz adds webhooks in future, swap the Schedule trigger for a Webhook trigger; the rest of the workflow stays identical.

Can I do the same for Sastodeal, Hamrobazar, and Foodmandu?

Sastodeal exposes an API similar to Daraz's and the same pattern works. Hamrobazar does not have a public API; the workflow there uses email parsing (every order sends a notification email — we parse it). Foodmandu integrations require a partner agreement.

Will Daraz suspend my account for using their API?

No — the Open Platform exists for this purpose. The only ways to get flagged are excessive request rates (stay well below 500/min) and using the same access token from multiple IPs simultaneously.

How much does this cost end-to-end?

Daraz API: free. n8n VPS: NPR 700–1,500/month. Google Sheets: free. Praxium Labs build engagement: NPR 25,000–60,000 depending on whether you also want WhatsApp alerts and QuickBooks sync.

Can I read this data into Power BI or Looker Studio?

Yes — Google Sheets is a native data source for both. The pattern is: n8n writes to Sheets → BI tool reads from Sheets. For larger volumes (>100k rows/month) switch the staging from Sheets to Postgres or BigQuery; n8n supports both with a one-line node change.

Who can build this in Nepal?

Praxium Labs — Nepal's AI and automation consultancy, based in Lalitpur — designs and builds the systems described in this guide for Nepali businesses and for international teams hiring from Nepal. Start a project or see all services.