Log every Paymob payment in Google Sheets

Every Paymob transaction, successful or failed, becomes a row in your sheet.

Easy Saves ~4 hours/month MENA & local appsBy Flowngn team

Works with n8n · Make · Zapier

Get paid faster Get organized

How it works

Trigger: Webhook — Paymob transaction processed callback

Receive the transaction callback from Paymob.
Pull out date, order, amount, method, customer and result.
Append a row to your Payments sheet.

Diagram

Trigger App Code

Code

JavaScript used in the Code step — already included in the template below.

Read payment · Code node

// Mode: Run Once for Each Item
// Paymob "transaction processed" callback → clean, easy-to-use fields.
const obj = $json.body?.obj || {};
const billing = obj.order?.shipping_data || obj.payment_key_claims?.billing_data || {};

return {
  json: {
    success: obj.success === true,
    transaction_id: obj.id,
    order_id: obj.order?.merchant_order_id || obj.order?.id,
    amount: (obj.amount_cents || 0) / 100,
    currency: obj.currency,
    method: obj.source_data?.sub_type || obj.source_data?.type || "",
    customer_name: [billing.first_name, billing.last_name].filter(Boolean).join(" "),
    phone: String(billing.phone_number || "").replace(/[^0-9]/g, ""),
    email: billing.email || "",
    error: obj.data?.message || "",
    date: obj.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.

Workflow JSON

Show code (119 lines)

{
  "name": "Log every Paymob payment in Google Sheets (Flowngn)",
  "nodes": [
    {
      "parameters": {
        "content": "## Log every Paymob payment in Google Sheets\nEvery Paymob transaction, successful or failed, becomes a row in your sheet.\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": "43ef56f7-3e64-497c-a29d-9f8e76873bd0",
      "name": "Setup notes",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -420,
        -60
      ]
    },
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "paymob-log",
        "options": {}
      },
      "id": "43ef56f7-3e64-497c-a29d-9f8e76873bd0",
      "name": "Paymob callback",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        0,
        0
      ],
      "webhookId": "43ef56f7-3e64-497c-a29d-9f8e76873bd0"
    },
    {
      "parameters": {
        "jsCode": "// Mode: Run Once for Each Item\n// Paymob \"transaction processed\" callback → clean, easy-to-use fields.\nconst obj = $json.body?.obj || {};\nconst billing = obj.order?.shipping_data || obj.payment_key_claims?.billing_data || {};\n\nreturn {\n  json: {\n    success: obj.success === true,\n    transaction_id: obj.id,\n    order_id: obj.order?.merchant_order_id || obj.order?.id,\n    amount: (obj.amount_cents || 0) / 100,\n    currency: obj.currency,\n    method: obj.source_data?.sub_type || obj.source_data?.type || \"\",\n    customer_name: [billing.first_name, billing.last_name].filter(Boolean).join(\" \"),\n    phone: String(billing.phone_number || \"\").replace(/[^0-9]/g, \"\"),\n    email: billing.email || \"\",\n    error: obj.data?.message || \"\",\n    date: obj.created_at,\n  },\n};",
        "mode": "runOnceForEachItem"
      },
      "id": "43ef56f7-3e64-497c-a29d-9f8e76873bd0",
      "name": "Read payment",
      "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": "Payments",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "date": "={{ $json.date }}",
            "order_id": "={{ $json.order_id }}",
            "transaction_id": "={{ $json.transaction_id }}",
            "amount": "={{ $json.amount }}",
            "currency": "={{ $json.currency }}",
            "method": "={{ $json.method }}",
            "customer": "={{ $json.customer_name }}",
            "result": "={{ $json.success ? 'paid' : 'failed' }}"
          }
        },
        "options": {}
      },
      "id": "43ef56f7-3e64-497c-a29d-9f8e76873bd0",
      "name": "Add to Payments",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        600,
        0
      ]
    }
  ],
  "connections": {
    "Paymob callback": {
      "main": [
        [
          {
            "node": "Read payment",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read payment": {
      "main": [
        [
          {
            "node": "Add to Payments",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "tags": []
}

Open in the playground to edit →

Tips

Amounts arrive in cents (amount_cents) — the Code step divides by 100.

Related flows

MENA & local appsMedium

WhatsApp receipt for Paymob payments

When a Paymob payment succeeds, the customer gets a WhatsApp receipt instantly.

Paymob → WhatsApp5h/mo

MENA & local appsEasy

Telegram alert for failed Paymob payments

Know instantly when a customer's payment fails, so you can call them and save the sale.

Paymob → Telegram2h/mo

MENA & local appsAdvanced

Verify Paymob callbacks with HMAC

Check Paymob's signature on every callback so fake payment messages are rejected.

Paymob → Telegram1h/mo