17 · apps
Append, read, and update spreadsheet rows — lightweight DB for ops.
When to use it
You need a durable table without standing up Postgres. Graduate to a real DB when volume or concurrency hurts.
Writeup
Append, read, and update spreadsheet rows — lightweight DB for ops. You need a durable table without standing up Postgres. Graduate to a real DB when volume or concurrency hurts.
Step by step — how to wire it
01
Prepare headers
Row 1: at | email | message | priority (match your payload).
02
Connect OAuth2
n8n Credentials → Google Sheets → sign in.
03
Append from the graph
Webhook/IF false → Google Sheets Append → Document + Sheet.
04
Respond after write
If the client waits, Sheets → Respond to Webhook so 200 means “logged”.
How it functions
Append
Most intake flows use Append + autoMapInputData once headers exist.
Credential
Google Sheets OAuth2 — share the sheet with that Google account.
Used for
Used for 1
Audit logs of every webhook
Used for 2
Non-urgent queues when Slack would be noise
Used for 3
Daily digest persistence
Tips
Retries duplicate rows — add an idempotency key column when it matters.
autoMap fails silently on mismatched headers — check the first test row.