{"product_id":"qersh-webhook-to-google-sheets-verify-log-wallet-transfers","title":"Qersh Webhook to Google Sheets: Verify \u0026 Log Wallet Transfers","description":"\u003ch3\u003eVerify Qersh Webhooks and Log Wallet Transfers to Google Sheets—Automatically\u003c\/h3\u003e\n\u003cp\u003eTurn incoming \u003cstrong\u003eQersh wallet-transfer webhooks\u003c\/strong\u003e into clean, auditable records in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. This n8n workflow verifies Qersh webhook signatures, prevents duplicate entries using \u003cstrong\u003edelivery_id\u003c\/strong\u003e, and updates existing rows to mark \u003cstrong\u003esuspected forgery\u003c\/strong\u003e when Qersh flags an event.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives signed POST webhooks\u003c\/strong\u003e from Qersh, including the raw JSON delivery payload and signature headers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates request authenticity\u003c\/strong\u003e: the workflow verifies the \u003cstrong\u003eX-Qersh-Signature HMAC\u003c\/strong\u003e against the raw body using your provided \u003cstrong\u003econnection_key\u003c\/strong\u003e. Invalid requests are rejected with a \u003cstrong\u003e401\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns responses fast\u003c\/strong\u003e: for valid deliveries it responds with \u003cstrong\u003e200 OK\u003c\/strong\u003e immediately, then continues processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIgnores connection tests\u003c\/strong\u003e to avoid polluting your sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs new incoming transfers\u003c\/strong\u003e for \u003cem\u003etransfer.received\u003c\/em\u003e events by checking \u003cstrong\u003edelivery_id\u003c\/strong\u003e in Google Sheets and appending a new row only if it’s not already logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles updates for suspected forgery\u003c\/strong\u003e: for update events flagged as suspected forgery, it finds the matching row by \u003cstrong\u003etransfer_id\u003c\/strong\u003e and sets \u003cstrong\u003estatus\u003c\/strong\u003e to \u003cstrong\u003e“SUSPECTED FORGERY”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a reliable transfer ledger for your SaaS, with signature-verified webhook ingestion.\u003c\/li\u003e\n  \u003cli\u003eDetect and record potential fraud: automatically update transfer status when Qersh issues a forgery verdict.\u003c\/li\u003e\n  \u003cli\u003eAudit wallet activity without manual reconciliation—duplicates are prevented by \u003cstrong\u003edelivery_id\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook node\u003c\/strong\u003e receives Qersh POST events.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSignature verification\u003c\/strong\u003e is implemented with workflow steps that check the \u003cstrong\u003eX-Qersh-Signature HMAC\u003c\/strong\u003e using the Qersh \u003cstrong\u003econnection_key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration: read\/append\/update using columns such as received_at, amount, currency, payer_number, payer_name, provider_txn_id, wallet, risk, auto_confirm_ok, transfer_id, delivery_id, and status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eControl flow nodes\u003c\/strong\u003e: if, set, code, no op, sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet up once, then let this n8n automation continuously verify Qersh webhook deliveries and keep your Google Sheets transfer history accurate and up to date.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244559356083,"sku":"N8N-21102","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Z1YRfQf4KkSPd00lcYPWV_lhzL8ubR.png?v=1792401975","url":"https:\/\/buyflowscripts.com\/products\/qersh-webhook-to-google-sheets-verify-log-wallet-transfers","provider":"N8N Commerce","version":"1.0","type":"link"}