Community Apps Script
Free Advertising Platforms -> Google Sheets Connectors
With this set of connectors, data analysts & marketers can collect any marketing, financial, or CRM data into Google Sheets.
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βName | Status | Links |
---|---|---|
Facebook Ads | π’ Public | Copy Template |
Microsoft Ads | π’ Public | Copy Template |
TikTok Ads | π’ Public | Copy Template |
LinkedIn Ads | π’ Public | Copy Template |
Reddit Ads | π’ Public | Copy Template |
X Ads | π’ Public | Copy Template |
Open Exchange Rates | π’ Public | Copy Template |
LinkedIn Pages | π’ Public | Copy Template |
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.
Here is what Google Sheets Connectors are:
- You can import data to YOUR Google Sheets
- 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.
This is the starting point for data connectivity, but we also have the OWOX Data Marts π Cloud and Self-Hosted Editions.
π§° 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 connector to pull your data
- π Schedule it for interval/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 work
π οΈ Includes: Free templates & walkthroughs
ποΈ Hosted by: Ievgen Krasovytskyi
π§βπ» Contribute or Build Your Own
Section titled βπ§βπ» Contribute or Build Your OwnβWant to build a new 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βConnectors are 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 Β»