How to Connect Salla to Looker Studio & Google Sheets for Real-Time Reporting

Why Salla Merchants Need Direct BI & Spreadsheet Reporting

Salla powers tens of thousands of thriving online stores across Saudi Arabia and the GCC. While the native Salla analytics dashboard provides vital daily operational views (order volumes, daily sales, pending shipments), modern e-commerce leaders quickly run into analysis limits:

• No Custom Blended Calculations: Calculating blended metrics like net profit margins, customer lifetime value (LTV), or return on ad spend (ROAS) across ad channels requires external modeling.
• Reporting Bottlenecks: Exporting manual CSV files each week to update team spreadsheets is tedious and prone to date mismatch errors.
• Stakeholder Presentation: Executive and investor updates require polished, real-time visual dashboards that update automatically.

Connecting Salla directly to Google Looker Studio and Google Sheets solves these hurdles. If you are also setting up SQL warehousing alongside visual dashboards, see our companion technical guide on how to connect Salla to BigQuery.

---

What Salla Store Data Should You Sync?

To build an actionable e-commerce dashboard, ensure your connector pulls these key entities:

1. Orders & Transactions: Order ID, status (Completed, Canceled, Refunded), payment method (Mada, Apple Pay, Tabby, Tamara), creation date, and total order value in SAR.
2. Products & Inventory: SKU, product name, category, quantity sold, and stock levels.
3. Customer & Acquisition Data: City, shipping region, repeat customer flags, and coupon discount codes applied.

---

3 Approaches to Connect Salla to Looker Studio & Sheets

Approach 1: Manual CSV Exports (The Basic Method)

1. Navigate to your Salla Merchant Dashboard → Orders.
2. Filter the desired date range and click Export to CSV.
3. Open Google Sheets → File → Import → Upload.
4. Connect Looker Studio to the Google Sheet using the native Google Sheets connector.

Verdict: Good for quarterly reviews, but unworkable for daily campaign monitoring due to high manual overhead and zero real-time sync.

Approach 2: Custom Salla Webhooks to Google Apps Script

Technical teams can build a custom webhook handler:

1. Register webhooks in the Salla Partner portal for order.created and order.updated.
2. Write a Google Apps Script web app endpoint that receives the webhook POST payload and appends rows to a Google Sheet.
3. Connect that sheet as a data source in Looker Studio.

Verdict: Cheap to set up, but prone to Google Apps Script rate limits and timeout failures during peak shopping seasons (e.g., White Friday or Ramadan).

Approach 3: Automated Direct Integration with AKM

The fastest and most reliable route is using AKM's native Salla connector:

1. Authorize Salla Store: Connect your store through AKM’s native OAuth integration in one click via the Salla Ads connector.
2. Automated Data Sync: AKM continuously syncs and cleans orders, refunds, and coupon data in an enterprise first-party warehouse.
3. Turnkey Looker Studio & Sheets Connectors: Use AKM's pre-built Partner Connector for Looker Studio or direct Sheets sync. Your dashboards populate automatically with pre-calculated metrics like Net Revenue, Mada vs. Tabby payment splits, and repeat purchase rates.
4. Compare Across Regional Stores: If you operate across platforms in KSA, you can pair this with our guide on connecting Zid store data to BigQuery.

---

Top 5 Visuals Every Salla Looker Studio Dashboard Needs

---

Summary & Next Steps

Eliminate manual spreadsheet work and give your growth team live access to real-time store performance. Connect your Salla store to Looker Studio and Google Sheets effortlessly using AKM. Explore our e-commerce solutions or request a demo at alkhwarizmimetrics.com.