What it does
- 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.
The prompt
Paste it into a new chat in General Input, and a specialist builds it with you.
Set 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.
What you'll need
- 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
Make it yours
- 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