Yookassa

# Accept YooKassa payments and log transactions in Google Sheets

## 🧾 Summary

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.

## 👥 Who is this for?

This template is ideal for:

* Online stores with simple checkout flows
* Sellers of digital products or info-courses
* Entrepreneurs using Telegram bots or web forms
* Anyone needing quick payment integration with Google Sheets tracking

## 🎯 What problem does this workflow solve?

Setting up online payments usually requires backend infrastructure. This no-code solution automates the entire payment flow:

* Handles product listing and price retrieval
* Initiates payments with email and return URL
* Listens for `payment.succeeded` and `refund.succeeded` events
* Records every action into structured Google Sheets

## ⚙️ What this workflow does

### 1. **GET /products**

Returns a sorted list of products from a Google Sheet (`products`).

### 2. **POST /payment**

* Validates required fields (`product_id`, `email`, `return_url`)
* Checks email format
* Fetches product data from `products`
* Generates a unique idempotence key
* Sends a request to YooKassa API
* Saves the order into the `orders` sheet
* Returns a payment confirmation link

### 3. **POST /yoomoney**

Webhook to process payment/refund events:

* On `payment.succeeded`, adds entry to `transactions`
* On `refund.succeeded`, updates transaction status

### 4. **GET /status/\:id**

Returns real-time payment status from YooKassa

## 🚀 Setup

1. **Connect credentials:**

   * Google Sheets (OAuth2)
   * YooKassa (Basic Auth using `shopId` and `secretKey`)

2. **Update the following Google Sheets:**

   * `products`: should contain `product_id`, `title`, `price`
   * `orders`: for saving confirmed purchases
   * `transactions`: for logging all successful or refunded payments

3. **Test endpoints using any HTTP client**:

Example payload for `/payment`:

```json
{
  "product_id": "abc123",
  "email": "user@example.com",
  "return_url": "https://your.site/success"
}
```

## 🔧 How to customize this workflow

* Add delivery logic (e.g., email with product link after successful payment)
* Replace Google Sheets with a database (e.g., PostgreSQL)
* Connect Telegram or other messengers for post-payment notifications
* Add promo codes, discounts, or subscriptions logic

## 💼 Use cases

* Simple online checkouts
* Telegram bots selling access
* Educational product sales
* MVP e-commerce flows
* Donation or membership payments

## 📎 Notes

✅ Includes Sticky Notes for sections
✅ Includes error handling and validation
✅ No custom code needed except UUID generation