Payment Processing and Order Tracking with YooKassa and Google Sheets

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

Connect credentials:

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

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

Test endpoints using any HTTP client:

Example payload for /payment:

{ "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