Google Sheets
Integrations Overview
WordPress
YouCan
Google Sheets Integration
- SMA API Endpoint: /api/google-sheet-order.php
- Secret Token placeholder: sma_google_sheet_secret_2026
- Status: Ready to receive orders
| Google Sheet Column | SMA Field |
|---|---|
| Full Name / Name | customer_name |
| Phone | phone |
| City | city |
| Address | address |
| Product / Product Name | product_name |
| SKU | sku |
| Quantity | quantity |
| Price | price |
| Date / Created At | created_at |
| Note / Remark | note |
Import Rules
- source = Store
- confirmation_status = New Order
- ameex_status = Pending
- delivery_status = Empty
- duplicate check by order_number first, then phone + product + date