07 · Intermediate

Webhook Sheets Log

Appends every webhook payload to a spreadsheet — a lightweight audit trail without a database.

Webhook

Sheets

Respond

n8n canvas preview

Webhook Sheets Log

Download JSONOpen n8n.io ↗
Loading n8n canvas…

Canvas via n8n-demo · import JSON into n8n.io → Workflows → Import from File

Writeup

How Webhook Sheets Log works

POST /log → Append Row (Sheets autoMap) → Respond { ok: true, logged: true }. Audit trail without a DB.

Step by step — how to build it

  1. 01

    Add Webhook

    POST, Path log. Respond: Using ‘Respond to Webhook’ node.

  2. 02

    Add Google Sheets Append

    Connect Webhook → Google Sheets. Operation Append. Mapping: autoMapInputData (or map columns).

  3. 03

    Pick Document + Sheet

    Choose spreadsheet/tab. Headers should exist. Attach Google Sheets credential.

  4. 04

    Add Respond to Webhook

    Connect Sheets → Respond. Respond With JSON: { "ok": true, "logged": true }.

  5. 05

    Test the chain

    POST sample JSON → Sheet gains a row AND HTTP response returns logged: true.

How it functions

1 · Webhook

POST path log, responseMode responseNode — waits for Respond 200.

2 · Append Row

Google Sheets operation append, mappingMode autoMapInputData.

3 · Respond 200

JSON { "ok": true, "logged": true } so the client can stop retrying.

Setup notes

Create the Sheet

Add a header row matching fields you send. Share with the Google account in n8n.

Select Document + tab

Append Row → choose spreadsheet/sheet. Keep autoMap or map columns explicitly.

Activate

POST to …/webhook/log until rows appear and the response JSON matches.

Tips

Still design for idempotency — retries can duplicate rows.

responseNode + Respond is the right pattern when Sheets must finish before HTTP 200.

Import into n8n.io → Workflows → Import from File, attach credentials, activate.

← IF Priority RouterIntent Switch CRM →
© 2026 thenionic · Webhook Sheets Log