OWOX Data Marts Fork
🏷️ OWOX Data Marts — Free, Open-Source Connectors for Data Analysts
Section titled “🏷️ OWOX Data Marts — Free, Open-Source Connectors for Data Analysts”Collect any marketing, financial, or CRM data into Google Sheets or BigQuery — for free.
No vendors. No lock-in. No permissions sharing with 3-rd parties.
Just JavaScript + full control for you.
🌐 Website | 💬 Join Community | 🆘 Create an Issue
✨ Why We Built This
Section titled “✨ Why We Built This”We believe every data analyst should have the power to automate their data collection & reporting — without begging for engineering help, paying for expensive SaaS tools, or exposing credentials to vendors. We want to empower every business to become data owners by importing their data into Spreadsheets or data warehouses.
OWOX Data Marts is a growing library of JavaScript-based connectors that:
- Pull data from any APIs like Facebook, TikTok, LinkedIn, etc.
- Run inside Google Sheets (via Apps Script) or Google Cloud (for BigQuery)
- Require no external platforms or credentials sharing
- Doesn’t require ANY data engineering resources
- Are 100% open-source and customizable
- Free forever: your connector - your control
Whether you’re an analyst at an agency, a startup, or in a huge enterprise, this project gives you full control over your data collection connectors.
🔌 Available Connectors
Section titled “🔌 Available Connectors”Data Sources
Section titled “Data Sources”| Name | Status | Links |
|---|---|---|
| Facebook Ads | 🟢 Public | Google Drive, Source Code, Readme |
| Open Exchange Rates | 🟢 Public | Google Drive, Source Code, Readme |
| Bank of Canada | 🟢 Public | Google Drive, Source Code, Readme |
| LinkedIn Ads & LinkedIn Pages | 🟢 Public | Google Drive, Source Code, Readme |
| TikTok Ads | 🟢 Public | Google Drive, Source Code, Readme |
| X Ads (former Twitter Ads) | 🟢 Public | Google Drive, Source Code, Readme |
| Criteo Ads | 🟢 Public | Google Drive, Source Code, Readme |
| Bing Ads | 🟢 Public | Google Drive, Source Code, Readme |
| Reddit Ads | 🟢 Public | Google Drive, Source Code, Readme |
| Hotline | ⚪️ In Discussion | Discussion |
| Shopify Ads | ⚪️ In Discussion | Discussion |
| Google Business Profile | ⚪️ In Discussion | Discussion |
Data Storage Options
Section titled “Data Storage Options”| Name | Status | Links |
|---|---|---|
| Google Sheets | 🟢 Public | Issues |
| Google BigQuery | 🟢 Public | Issues |
If you find an integration missing, you can share your use case and request it here
🧰 How It Works
Section titled “🧰 How It Works”- 🎯 Pick your platform (e.g. Facebook Ads) from existing integrations
- 🧾 Make a copy of the Template from the [table above]
- 🔐 Add your API credentials directly to the sheet — they stay private
- 🚀 Run the Apps Script to pull your data
- 📅 Schedule it (optional) for daily/weekly refreshes
If you experience any issues or want to report a bug, please open an issue.
To become a part of the Core team, please start by submitting a pull request to the Core part of the product. Understanding TypeScript, Git, and software development is required.
To get support, please visit Q&A first.
🧑💻 Contribute or Build Your Own
Section titled “🧑💻 Contribute or Build Your Own”Want to build a connector? We’d love your help. To contribute to existing integrations or create a new one:
- 📘 Read the Contributor guide
- 📌 Check open connector requests
All you need to get started is basic knowledge of Apps Script and a GitHub login. No software installation is required on your computer.
Whether you’re adding a new API, tweaking one, or improving docs, we’ll support and spotlight you.
🌍 Join the Community
Section titled “🌍 Join the Community”Need help or want to connect with others?
- 💬 Join our Community
- 🗨️ Ask questions or suggest features We’re building this with the community, not just for it.
📌 License
Section titled “📌 License”OWOX Data Marts is free for internal or client use, not for resale in a competing product. The project uses a dual-license model:
- Connectors (
packages/connectors) are distributed under the MIT License - Platform (all other files and directories) is distributed under the ELv2 License
🚀 Running the App Locally and in Production
Section titled “🚀 Running the App Locally and in Production”Node.js version 22.16.0 or higher is required. To run the full application (backend + frontend), use the following commands:
🛠 Development Mode
Section titled “🛠 Development Mode”Run both the NestJS backend and the Vite frontend in watch mode:
npm run devThis command uses npm-run-all to launch both services concurrently. It’s ideal for local development and live editing.
🌐 Serve Production Build
Section titled “🌐 Serve Production Build”Start the NestJS server that serves static frontend files:
npm run serve📖 Documentation
Section titled “📖 Documentation”- Lint-staged Workflow - Code quality and formatting workflow
- Monorepo Structure - Project architecture and organization
- Migrations Guide - Database migration workflow
⭐ Like this project? Star the repo here »