Yookassa Payment Processing & Product Catalog API
detail.loadingPreview
This n8n workflow automates key e-commerce operations by providing a dynamic product catalog API and seamlessly processing payments via Yookassa. It also logs all transaction details to Google Sheets, empowering businesses to manage product information and handle transactions efficiently.
About This Workflow
This robust n8n workflow streamlines your e-commerce backend by integrating product data management with the Yookassa payment gateway. It exposes a powerful API endpoint (via webhook) to fetch and display your product catalog, complete with sorting capabilities by price. Concurrently, the workflow handles the entire payment lifecycle: retrieving specific product details from Google Sheets, initiating secure payment requests through Yookassa's API, and automatically logging all transaction data into a separate Google Sheet for robust record-keeping and analytics. This comprehensive solution minimizes manual effort, reduces errors, and provides a scalable way to manage online sales and product information.
Key Features
- Product Catalog API: Exposes a webhook endpoint to retrieve a sortable list of products from your Google Sheets.
- Secure Yookassa Payments: Initiates payment requests via the Yookassa API, collecting necessary customer and product information.
- Automated Order Logging: Records all successful payment and order details, including product ID, email, and timestamp, directly into a Google Sheet.
- Dynamic Data Retrieval: Fetches product prices and details from a Google Sheet based on incoming payment requests.
- Error Handling: Includes a dedicated webhook response for handling errors during product data retrieval.
How To Use
- Set up Google Sheets: Create two Google Sheets: one named
products(e.g., with columns likeproduct_id,title,price) and another namedorders(e.g., with columns likeid,email,product_id,order_datetime). Ensure the sheet IDs and names match those configured in the n8n Google Sheets nodes. - Configure Credentials:
- Google Sheets: Create a Google Sheets OAuth2 API credential in n8n and select it for both the "Get Product" and "Save Order" nodes.
- Yookassa: Create an HTTP Basic Auth credential for Yookassa, providing your Shop ID as the username and Secret Key as the password. Select this credential for the "YooKassa Request" node.
- Activate Webhooks:
- The "Get products" webhook (path:
products) is already configured to expose an API endpoint to retrieve your product list. - For the payment processing part, you will need to add an additional Webhook node (e.g., named "Payment") at the beginning of that flow. Configure this webhook to receive
product_id,email, andreturn_urlin its body, then connect its success output to the 'Get Product' node.
- The "Get products" webhook (path:
- Test the Workflow: Trigger the "Get products" webhook URL to ensure it returns sorted product data. Then, trigger your payment webhook with sample data to verify that Yookassa payments are initiated and order details are logged correctly into your 'orders' Google Sheet.
Apps Used
Workflow JSON
{
"id": "96443f2f-9e66-483e-8fc7-3488f65516b3",
"name": "Yookassa Payment Processing & Product Catalog API",
"nodes": 22,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 96443f2f-9e66...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Dynamic Bible Scripture Retrieval Workflow
This n8n workflow provides a robust solution for dynamically querying and retrieving Bible scriptures from the getBible.net API. It takes structured JSON input for references, translation, and version, returning the corresponding passages in a standardized API response format.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.