Skip to main content
ClientNest365ClientNest365

Google Sheets

Log every approval decision to Google Sheets

Append each approval decision to a Google Sheet. Defensible audit log outside the product, useful for compliance reviews and fee-dispute defence.

6 min setup Trigger: approval.decided easy
works with Zapierworks with Make.comworks with n8n

Setup steps

  1. In Google Sheets: create a sheet with columns Date, Client, Approval, Decision, Comment, Approver IP.
  2. In Make / Zapier: webhook trigger.
  3. Add 'Google Sheets Append Row' step.
  4. In ClientNest365: subscribe a new webhook to approval.decided.

Payload fields you'll use

  • approval.subject
  • approval.decision
  • approval.decided_at
  • approval.comment
  • approval.approver_ip
  • client.name

Where to wire it in ClientNest365

Open your workspace at /app/settings/webhooks. Click + New endpoint. Paste the target URL from your automation platform (Zapier, Make, n8n) or the third-party tool's native webhook URL. Subscribe to the approval.decided event. Save. Your endpoint secret is shown once at creation; copy it now if you plan to verify the HMAC signature on the receiving end.

Verifying the signature

Each webhook POST carries an X-CN-Signature header. The value is sha256=<hmac> where the HMAC is computed over the raw request body using your endpoint secret. Compare with constant-time equality. Reject mismatches.