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
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.
| 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 |
| 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
- 🎯 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.
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.
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.
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
Node.js version 22.16.0 or higher is required. To run the full application (backend + frontend), use the following commands:
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.
Start the NestJS server that serves static frontend files:
npm run serve- 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 »