I Got Tired of Manually Logging Invoices, So I Wired Webhooks Straight to a Google Sheet

Описание и применение

Автоматический поток в n8n, принимающий веб‑хуки счетов, проверяющий подпись HMAC, отбрасывающий дубликаты и записывающий данные в Google Sheets, устраняет ручной ввод и потери данных.

Задача

Repeatedly rebuilding invoice‑logging automations for each payment provider caused friction due to varying payloads, failure modes, and duplicate handling.

Результат

The workflow reliably records invoices, prevents duplicates, and surfaces errors, eliminating manual logging and reducing loss of data under load.

Рабочий процесс

• Webhook – entry point for all executions
• HMAC verify – checks signature before parsing
• Idempotency check – drops events with previously processed id
• Append to Sheets – writes normalized record as a row
• Error branch – collects failures and surfaces them

Доказательства

I kept hitting the same friction: every time a payment provider fired an event, I rebuilt the same automation from scratch.

Источник

The order matters: verifying before parsing means a malformed or hostile body never reaches code that acts on it.

Источник

An error branch that only appends to a file is not an error branch; it has to end somewhere a human looks.

Источник