Google Sheets sync
DZBuild's Google Sheets integration keeps a live spreadsheet of your store data — orders, products, customers, inventory, and abandoned carts — updated automatically as activity happens in your store.
Setup
- Go to
/dashboard/addons/google-sheets. - Click Connect Google and authorize via Google OAuth.
- Click Create new sheet (or link an existing sheet the app created). The background sync starts immediately.
If the token expires later, the page will prompt you to reconnect.
What syncs
| Data type | Syncs automatically |
|---|---|
| Orders | ✅ order ID, customer name, phone, wilaya, products, amount, status, courier, tracking |
| Products | ✅ name, SKU, price, stock, category |
| Customers | ✅ name, phone, total orders, fraud score |
| Inventory | ✅ current stock per product/variant |
| Abandoned carts | ✅ phone, products, timestamp |
The first sheet you connect syncs all of the above. Additional sheets default to orders-only.
Active-sheet limits by plan
| Plan | Max active sheets |
|---|---|
| Free | 1 |
| Pro | 6 |
| Unlimited | 10 |
| Enterprise | 30 |
If you hit the limit you'll see: "لقد وصلت إلى الحد الأقصى للأوراق المفعلة". Disconnect an unused sheet or upgrade your plan.
Troubleshooting
| Issue | Fix |
|---|---|
| "Token expired" / reconnect prompt | Click Reconnect and re-authorize Google |
| Sheet stops updating | Check connection status; Google revokes tokens after prolonged inactivity |
| Can't create more sheets | Plan limit reached — see table above |
Octomatic
Octomatic is a third-party fulfillment tool that connects to DZBuild via Google Sheets. Set up Google Sheets first, then follow the guide at /dashboard/addons/octomatic.