Community Apps Script
With this set of connectors, data analysts & marketers can collect any marketing, financial, or CRM data into Google Sheets & Google BigQuery.
No cost. No email collection. No vendors. No lock-in. No permissions sharing with 3-rd parties.
Just Google Sheets Templates + Your full control + Amazing OWOX Community.
🌐 Website | 💬 Join Community | 🆘 Create an Issue
🔌 Available Connectors
Section titled “🔌 Available Connectors”Data Sources
Section titled “Data Sources”| Name | Status | Links |
|---|---|---|
| Facebook Ads | 🟢 Public | Copy Template, How-to-guide |
| Open Exchange Rates | 🟢 Public | Copy Template, How-to-guide |
| Bank of Canada | 🟢 Public | Copy Template, How-to-guide |
| LinkedIn Ads | 🟢 Public | Copy Template, How-to-guide |
| LinkedIn Pages | 🟢 Public | Copy Template, How-to-guide |
| TikTok Ads | 🟢 Public | Copy Template, How-to-guide |
| X Ads (former Twitter Ads) | 🟢 Public | Copy Template, How-to-guide |
| Criteo Ads | 🟢 Public | Copy Template, How-to-guide |
| Bing Ads | 🟢 Public | Copy Template, How-to-guide |
| Reddit Ads | 🟢 Public | Copy Template, How-to-guide |
| Hotline | ⚪️ In Discussion | Discussion |
| Shopify Ads | ⚪️ In Discussion | Discussion |
| Google Business Profile | ⚪️ In Discussion | Discussion |
Data Destinations Available
Section titled “Data Destinations Available”| Name | Status | Environment | Links |
|---|---|---|---|
| Google Sheets | 🟢 Public | Apps Script | Readme |
| Google BigQuery | 🟢 Public | Apps Script | Readme |
If you need an integration that is currently not available, you can share your use case and request it in the discussions
✨ Why We Built This
Section titled “✨ Why We Built This”We believe every data analyst should have the power to automate data collection — without begging for engineering help, paying for expensive SaaS tools, or exposing credentials to 3rd party SaaS tools. We want to empower every business to become data owners by importing their data into Spreadsheets or data warehouses.
OWOX Data Marts - Apps Script Edition is a growing library of JavaScript connectors that:
- Run inside YOUR Google Sheet
- Import data to YOUR Google Sheets ot Google 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.
We also have Node.js Community Edition to avoid the Apps Script limitations already available. See our 🚀 Quick Start setup docs.
🧰 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 connectors table
- 🔐 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
🎥 Webinar Replay: Own Your Data
Section titled “🎥 Webinar Replay: Own Your Data”
Own Your Data: How Data Analysts Can Connect Any Data
Learn how to collect and automate marketing, financial, and any other data into Google Sheets or BigQuery — with zero engineering help and no SaaS subscriptions.
▶️ Watch the Replay on YouTube
What you’ll learn:
- Why data access is broken (and how to fix it)
- Facebook Ads → Sheets and TikTok Ads → BigQuery — live demos
- How to automate reporting across clients without SaaS limits
- How to contribute, customize, and grow the connector library
🎯 For: Data analysts at agencies, startups, enterprises, or doing solo
🛠️ Includes: Free templates & walkthroughs
🎙️ Hosted by: Ievgen Krasovytskyi
🧑💻 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 platform connector, 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.
- Apps Script Connectors (
packages/connectors) are distributed under the MIT License
⭐ Like this project? Star the repo here »