Log Every Chargebee Payment Into Google Sheets Automatically
Each successful Chargebee charge is appended as a clean row in Google Sheets, giving you a live, reconciled revenue ledger without touching a spreadsheet.
- 1
Step 1 — Trigger on a successful charge
Add the
Chargebeetrigger (or aWebhooksubscribed to Chargebee'spayment succeededevent). Test-fire one payment to confirm the payload. - 2
Step 2 — Extract the money fields
Add a
Setnode withamount,currency,customerandpaid_at, mapped from the event, e.g.{{ $json.data.object.amount / 100 }}for Chargebee's cents. - 3
Step 3 — Append to Google Sheets
Add a
Google Sheetsnode set to append a row and map the four fields to columns. This keeps an immutable history you can pivot on. - 4
Step 4 — Flag large payments (optional)
Add an
Ifnode onamountto send high-value payments to Slack or email so finance sees the big wins immediately.
Frequently asked questions
Refunds — are they logged too?
Subscribe the same webhook to Chargebee's refund event and add a second branch that writes a negative-amount row to Google Sheets.
Amounts look 100x too big — why?
Chargebee reports money in the smallest currency unit (cents). Divide by 100 in the Step 2 expression, as shown.
Log Every Stripe Payment Into Google Sheets Automatically
Each successful Stripe charge is appended as a clean row in Google Sheets, giving you a live, reconciled revenue ledger without touching a spreadsheet.
n8nStripeGoogle Sheets
Auto-File Gmail Invoice Attachments Into Google Drive
This watches Gmail for invoices and receipts, extracts the key details, and files the attachment into Google Drive with a tidy name — so month-end reconciliation is already done.
n8nGoogle DriveGmailRescue Failed Stripe Payments With an Automatic Email Nudge
When a Stripe charge fails, this reaches the customer over Email with a friendly heads-up and an update-card link, and flags finance — recovering revenue that silent dunning would lose.
n8nStripe