OWOX Data Marts

Product Introduction

1. OWOX Data Marts is a free, open-source JavaScript library designed to automate data collection from advertising platforms, CRMs, and APIs into Google Sheets or BigQuery without third-party intermediaries. It provides prebuilt connectors for platforms like Facebook Ads, TikTok Ads, LinkedIn Ads, and financial data sources such as Open Exchange Rates and Bank of Canada. The solution operates entirely within Google Apps Script or Google Cloud, ensuring data remains under user control.
2. The core value lies in enabling data analysts to build custom reporting pipelines without relying on engineering teams or exposing credentials to SaaS vendors. It eliminates vendor lock-in, reduces costs associated with commercial ETL tools, and maintains full ownership of data workflows through transparent, modifiable code.

Main Features

1. Prebuilt API Connectors: Includes ready-to-use JavaScript modules for major advertising platforms (Facebook Ads, TikTok Ads, Bing Ads), CRMs, and financial APIs, with automatic schema mapping for Google Sheets and BigQuery compatibility. Connectors handle OAuth2 authentication, pagination, and rate limiting natively.
2. Zero-Infrastructure Execution: Runs entirely within Google Apps Script for Sheets integration or Google Cloud Functions for BigQuery pipelines, requiring no external servers or middleware. Scripts execute with user-owned credentials stored directly in Google Secret Manager or native Apps Script properties.
3. Customizable Open-Source Code: All connectors are MIT-licensed, allowing modifications for unique API endpoints, custom transformations, or integration with internal data validation rules. Developers can extend the base classes to add new platforms while maintaining compatibility with the core scheduling and logging framework.

Problems Solved

1. Eliminates Data Silos: Addresses the challenge of fragmented marketing data by providing direct pipelines from 15+ ad platforms and CRMs into centralized storage (Sheets or BigQuery), bypassing manual CSV exports and third-party aggregation tools.
2. Empowers Non-Engineering Teams: Targets data analysts, marketing operations specialists, and agency teams who need to automate reporting without writing production-grade code or negotiating SaaS contracts.
3. Secure Data Governance: Solves credential security concerns by keeping API keys and OAuth tokens within Google’s ecosystem, avoiding exposure to external vendors. Use cases include daily PPC performance snapshots, CRM hygiene audits, and financial exchange rate updates for multinational reporting.

Unique Advantages

1. No Black-Box Dependencies: Unlike commercial alternatives like Supermetrics or Fivetran, OWOX Data Marts provides full visibility into data transformation logic and error handling, critical for debugging and compliance audits.
2. Dual-License Model: Combines MIT licensing for connectors (allowing commercial reuse) with the Elastic License 2.0 for the orchestration framework, preventing competitors from monetizing the core platform while encouraging community contributions.
3. Cost-Effective Scalability: Avoids per-seat pricing or data volume fees common in SaaS alternatives, making it viable for enterprises processing terabytes of ad performance data. The Google Cloud integration supports serverless scaling without infrastructure management overhead.

Frequently Asked Questions (FAQ)

1. How are API credentials secured? Credentials are stored in Google Apps Script’s Properties Service or Google Cloud Secret Manager, encrypted at rest and never exposed in logs. Connectors use platform-specific OAuth2 implementations without intermediate token storage.
2. Can I add connectors for private/internal APIs? Yes, the modular architecture allows developers to extend the BaseConnector class, implement authentication methods, and deploy custom adapters alongside prebuilt integrations via GitHub pull requests.
3. How is scheduling handled for daily data refreshes? For Google Sheets, users configure time-driven triggers directly in Apps Script. For BigQuery, workflows can be scheduled via Google Cloud Scheduler with Pub/Sub triggers, supporting minute-level granularity.
4. What happens if an API changes its endpoints? The open-source model allows users to immediately update affected connectors without waiting for vendor support. Community-maintained connectors receive updates through GitHub issues and versioned releases.
5. Is there a cost for using the Google Cloud integration? Users incur standard Google Cloud fees for services like Cloud Functions and BigQuery, but OWOX Data Marts itself imposes no additional charges. Cost optimization templates are provided for budget-conscious deployments.