07 · Intermediate
Appends every webhook payload to a spreadsheet — a lightweight audit trail without a database.
Webhook
Sheets
Respond
n8n canvas preview
Webhook Sheets Log
Canvas via n8n-demo · import JSON into n8n.io → Workflows → Import from File
Writeup
POST /log → Append Row (Sheets autoMap) → Respond { ok: true, logged: true }. Audit trail without a DB.
Step by step — how to build it
01
Add Webhook
POST, Path log. Respond: Using ‘Respond to Webhook’ node.
02
Add Google Sheets Append
Connect Webhook → Google Sheets. Operation Append. Mapping: autoMapInputData (or map columns).
03
Pick Document + Sheet
Choose spreadsheet/tab. Headers should exist. Attach Google Sheets credential.
04
Add Respond to Webhook
Connect Sheets → Respond. Respond With JSON: { "ok": true, "logged": true }.
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.