Log successful Adyen payments to Google Sheets and Slack
The moment Adyen confirms a card payment, we add a row to your Google Sheets ledger and post a short heads-up to your team's Slack channel.
Adyen
Google Sheets
Slack BotFinanceOperationsNotifications & AlertsData SyncSet up a webhook trigger that receives Adyen AUTHORISATION notifications. For each notification where the success flag is true, run these two steps in order. When success is false, do nothing.
Step 1. Use the Google Sheets Append Values operation to add a new row to a designated ledger spreadsheet. Populate one column per field from the webhook payload: the event timestamp, pspReference, merchantReference, shopper email, amount, currency code, and payment method name. Adyen sends the amount value in the smallest currency unit, so divide by 100 for most currencies before writing it to the sheet so the ledger shows human amounts (for zero-decimal currencies like JPY, write the value as is).
Step 2. Use the Slack Bot Send a Message operation to post to a preconfigured Slack channel (default #payments). The message text should follow this exact format: "New payment: {amount} {currency} from {shopperEmail} (ref {merchantReference})".
No AI reasoning is required. The same fields flow from every payload into the same spreadsheet and the same Slack channel every time. This is a real-time payment ledger and is intentionally separate from any scheduled payment digest workflow.
Additional information
What does this prompt do?
- Every time a card payment goes through in Adyen, adds a fresh row to your Google Sheets payment ledger with the payment reference, shopper email, amount, currency, and payment method.
- Posts a short one-line notification to your Slack channel so finance and ops see each new payment the moment it lands.
- Only successful authorisations are recorded. Declined or failed charges are skipped so the numbers you see reflect real revenue.
- Runs the instant Adyen confirms the payment rather than on a schedule, so your ledger and your team's Slack channel stay in sync in real time.
What do I need to use this?
- An Adyen account you can point notifications at
- A Google Sheets spreadsheet to use as your payment ledger
- A Slack workspace and a channel where payment notifications should land
How can I customize it?
- Choose which spreadsheet and tab we append the row to, and which columns you want on the ledger
- Pick which Slack channel receives the notification (many teams use a dedicated #payments channel)
- Reword the Slack message or swap in different fields, for example including the payment method or a link back to the Adyen dashboard
Frequently asked questions
What happens if a payment is declined or fails?
Do I need to write any code to use this?
How fast does the ledger update after a payment?
Which columns does it fill in on the spreadsheet?
Does this handle refunds or captures too?
Related templates
Stop typing payments into a spreadsheet by hand.
Adyen tells you the moment a payment goes through. This connects that signal straight to your ledger and to your team's Slack channel.