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-c

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 (productid, email, returnurl) 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 productid, 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: --- π§ 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
Download the workflow JSON file after purchase.
Open n8n β click the menu β Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.