Zid orders in Google Sheets
Log every new Zid order in a Google Sheet automatically.
How it works
Trigger: Webhook — Zid new order event
- Receive the new order webhook from Zid.
- Pull out order, customer, phone, city, items, total and payment method.
- Append a row to your Orders sheet.
Diagram
Trigger App Code
Code
JavaScript used in the Code step — already included in the template below.
// Mode: Run Once for Each Item
// Zid order webhook → clean fields.
// Run one test order first and adjust the field names below if needed.
const o = $json.body?.data || $json.body || {};
const c = o.customer || {};
return {
json: {
order_id: o.code || o.id,
customer_name: c.name || "",
phone: String(c.mobile || c.phone || "").replace(/[^0-9]/g, ""),
email: c.email || "",
total: o.order_total ?? o.total ?? "",
currency: o.currency_code || o.currency || "",
payment_method: o.payment?.method?.code || o.payment_method || "",
city: o.shipping?.address?.city?.name || o.shipping?.address?.city || "",
items: (o.products || []).map((p) => `${p.quantity}× ${p.name}`).join("، "),
},
};Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (119 lines)
{
"name": "Zid orders in Google Sheets (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Zid orders in Google Sheets\nLog every new Zid order in a Google Sheet automatically.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "53ade245-fd19-478b-ab68-81cd19e532ab",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"httpMethod": "POST",
"path": "zid-orders-log",
"options": {}
},
"id": "53ade245-fd19-478b-ab68-81cd19e532ab",
"name": "Zid order",
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"webhookId": "53ade245-fd19-478b-ab68-81cd19e532ab"
},
{
"parameters": {
"jsCode": "// Mode: Run Once for Each Item\n// Zid order webhook → clean fields.\n// Run one test order first and adjust the field names below if needed.\nconst o = $json.body?.data || $json.body || {};\nconst c = o.customer || {};\n\nreturn {\n json: {\n order_id: o.code || o.id,\n customer_name: c.name || \"\",\n phone: String(c.mobile || c.phone || \"\").replace(/[^0-9]/g, \"\"),\n email: c.email || \"\",\n total: o.order_total ?? o.total ?? \"\",\n currency: o.currency_code || o.currency || \"\",\n payment_method: o.payment?.method?.code || o.payment_method || \"\",\n city: o.shipping?.address?.city?.name || o.shipping?.address?.city || \"\",\n items: (o.products || []).map((p) => `${p.quantity}× ${p.name}`).join(\"، \"),\n },\n};",
"mode": "runOnceForEachItem"
},
"id": "53ade245-fd19-478b-ab68-81cd19e532ab",
"name": "Read Zid order",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
300,
0
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Orders",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"date": "={{ $json.date || $now.toISO() }}",
"order_id": "={{ $json.order_id }}",
"customer": "={{ $json.customer_name }}",
"phone": "={{ $json.phone }}",
"city": "={{ $json.city }}",
"items": "={{ $json.items }}",
"total": "={{ $json.total }}",
"payment": "={{ $json.payment_method }}"
}
},
"options": {}
},
"id": "53ade245-fd19-478b-ab68-81cd19e532ab",
"name": "Add to Orders",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
600,
0
]
}
],
"connections": {
"Zid order": {
"main": [
[
{
"node": "Read Zid order",
"type": "main",
"index": 0
}
]
]
},
"Read Zid order": {
"main": [
[
{
"node": "Add to Orders",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Webhooks › Custom webhook
- Tools › Set variable / Iterator + Array aggregator (same logic as the Code step)
- Google Sheets › Add a Row
- Every module run uses Make operations — the free plan includes a monthly quota.
- Make's built-in functions (map, sum, formatDate…) can replace most Code steps; for complex logic use a code module.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Webhooks by Zapier — Catch Hook
- Code by Zapier — Run JavaScript (paste the code from the Code section)
- Google Sheets — Create Spreadsheet Row
- Zaps with more than two steps need a paid Zapier plan.
- Webhooks, Filters/Paths and Code by Zapier are premium features on some Zapier plans.
- Code by Zapier runs JavaScript: reuse the code shown above, reading inputs from inputData instead of $json.
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- Run one test order and check the field names — then adjust the Code step if needed.
Related flows
MENA & local appsEasy
Log every Paymob payment in Google Sheets
Every Paymob transaction, successful or failed, becomes a row in your sheet.
Paymob → Google Sheets4h/mo
MENA & local appsEasy
Salla orders in Google Sheets
Every new Salla order is logged in a sheet for fulfilment and reporting.
Salla → Google Sheets4h/mo
MENA & local appsEasy
New Zid order alerts on Telegram
Every new order in your Zid store arrives as a Telegram message.
Zid → Telegram2h/mo