This workflow allows you to accept online payments via YooKassa and log both orders and transactions in Google Sheets — all without writing a single line of code. It supports full payment flow: product selection, payment initiation, webhook processing, refund updates, and payment status checks.
This template is ideal for:
Setting up online payments usually requires backend infrastructure. This no-code solution automates the entire payment flow:
payment.succeeded
and refund.succeeded
eventsReturns a sorted list of products from a Google Sheet (products
).
product_id
, email
, return_url
)products
orders
sheetWebhook to process payment/refund events:
payment.succeeded
, adds entry to transactions
refund.succeeded
, updates transaction statusReturns real-time payment status from YooKassa
Connect credentials:
shopId
and secretKey
)Update the following Google Sheets:
products
: should contain product_id
, title
, price
orders
: for saving confirmed purchasestransactions
: for logging all successful or refunded paymentsTest endpoints using any HTTP client:
Example payload for /payment
:
{
"product_id": "abc123",
"email": "[email protected]",
"return_url": "https://your.site/success"
}
✅ Includes Sticky Notes for sections
✅ Includes error handling and validation
✅ No custom code needed except UUID generation