Odoo to Google Sheets Order Analytics Dashboard

Every ready-to-ship order, organized for the day ahead.

The same brand's fulfillment team

OdooReady ordersTodayTomorrowThuFri

Overview

An ERP data pipeline that extracts every ready-to-ship order from Odoo and builds a planning dashboard grouped by ship date, carrier, region, and destination, with deep links back to each record.

What it does

  • Authenticated Odoo JSON-RPC integration with paginated batch extraction
  • Data normalization of relational fields and status labels
  • Automated dashboards by ship date, carrier, region, and destination
  • Per-region views generated automatically
  • Deep links from every order back into the ERP
  • Today and tomorrow flagged for daily planning