Salla orders in Google Sheets
Every new Salla order is logged in a sheet for fulfilment and reporting.
How it works
Trigger: Webhook — Salla order.created event
- Receive the new order event from Salla.
- Pull out order, customer, phone, city, items and total.
- 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
// Salla order webhook → clean fields.
// Run one test order first and check the field names in the webhook data.
const body = $json.body || {};
const o = body.data || {};
const c = o.customer || {};
return {
json: {
event: body.event,
order_id: o.reference_id || o.id,
customer_name: [c.first_name, c.last_name].filter(Boolean).join(" "),
phone: `${c.mobile_code || ""}${c.mobile || ""}`.replace(/[^0-9]/g, ""),
email: c.email || "",
total: o.amounts?.total?.amount ?? o.total?.amount ?? "",
currency: o.amounts?.total?.currency ?? o.currency ?? "",
payment_method: o.payment_method || "",
city: o.shipping?.address?.city || c.city || "",
items: (o.items || []).map((i) => `${i.quantity}× ${i.name}`).join("، "),
date: o.date?.date || body.created_at || "",
},
};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": "Salla orders in Google Sheets (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Salla orders in Google Sheets\nEvery new Salla order is logged in a sheet for fulfilment and reporting.\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": "4582ffa0-b14a-4d3f-a4ae-9194a533337e",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"httpMethod": "POST",
"path": "salla-orders-log",
"options": {}
},
"id": "4582ffa0-b14a-4d3f-a4ae-9194a533337e",
"name": "Salla order",
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"webhookId": "4582ffa0-b14a-4d3f-a4ae-9194a533337e"
},
{
"parameters": {
"jsCode": "// Mode: Run Once for Each Item\n// Salla order webhook → clean fields.\n// Run one test order first and check the field names in the webhook data.\nconst body = $json.body || {};\nconst o = body.data || {};\nconst c = o.customer || {};\n\nreturn {\n json: {\n event: body.event,\n order_id: o.reference_id || o.id,\n customer_name: [c.first_name, c.last_name].filter(Boolean).join(\" \"),\n phone: `${c.mobile_code || \"\"}${c.mobile || \"\"}`.replace(/[^0-9]/g, \"\"),\n email: c.email || \"\",\n total: o.amounts?.total?.amount ?? o.total?.amount ?? \"\",\n currency: o.amounts?.total?.currency ?? o.currency ?? \"\",\n payment_method: o.payment_method || \"\",\n city: o.shipping?.address?.city || c.city || \"\",\n items: (o.items || []).map((i) => `${i.quantity}× ${i.name}`).join(\"، \"),\n date: o.date?.date || body.created_at || \"\",\n },\n};",
"mode": "runOnceForEachItem"
},
"id": "4582ffa0-b14a-4d3f-a4ae-9194a533337e",
"name": "Read Salla 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": "4582ffa0-b14a-4d3f-a4ae-9194a533337e",
"name": "Add to Orders",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
600,
0
]
}
],
"connections": {
"Salla order": {
"main": [
[
{
"node": "Read Salla order",
"type": "main",
"index": 0
}
]
]
},
"Read Salla 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
- Add a status column you update by hand: new, shipped, delivered.
Related flows
MENA & local appsMedium
Salla abandoned cart reminders on WhatsApp
When a Salla cart is abandoned, send the customer a friendly WhatsApp reminder with a link back to their cart.
Salla → WhatsApp → Google Sheets6h/mo
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 appsMedium
WhatsApp order confirmation for Salla
Customers of your Salla store get a WhatsApp message the moment they order.
Salla → WhatsApp6h/mo