Running ads on TikTok is easy. Getting clear, usable reports from it? Not so much. If you’ve ever tried to pull performance data into Google Sheets from TikTok, you know the pain: manual exports, token limitations, and restricted API access.
We believe that should change.
With this free, no-code TikTok Data to Google Sheets connector from OWOX Data Marts (Community Apps Script Edition), you can import, refresh, and customize TikTok Ads data in Google Sheets – in minutes, not hours. And best of all? You keep full ownership and control over your data.
Why We Made This Free Connector
At OWOX, we’ve always believed that businesses shouldn’t have to rent their own data.
That’s why we built this connector for importing TikTok data to Google Sheets and made it 100% free. No paid upgrades, no hidden features, and no restrictions on what you can do with your data.
Inspired by our mission to simplify data ownership, we want marketers and analysts to stop depending on black-box tools. You deserve transparency, flexibility, and control – and this connector gives you exactly that.
Whether you're a performance marketer, a startup founder, or a data analyst tired of reinventing the wheel, this connector puts the power back in your hands.
Join the Open-Source Movement
We’re not just releasing a free connector – we’re inviting you to help shape the future of open marketing analytics tools.
At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.
If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.
Also, feel free to:
Explore the code and customize it to fit your needs.
Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
Join our community & share your feedback.
We’ve built the core, the foundation – now it’s your turn to take it further.
Managing TikTok ad performance across different campaigns can be overwhelming, especially when data is stuck behind a complex UI or exported as raw CSV files, including TikTok organic data to Google Sheets. Marketers and analysts need fast, customizable access to insights – and that’s exactly what this free Google Sheets connector delivers.
Here’s why this connector is a game-changer:
✅ Real-time imports from TikTok Ads into a familiar Google Sheets interface ✅ No-code setup using a simple spreadsheet template ✅ Access to full-funnel metrics: impressions, clicks, CTR, conversions, video views, and more ✅ Seamless reporting with support for scheduling and re-importing ✅ Freedom to query all key TikTok ad data objects – campaigns, ad groups, creatives, audiences
Forget manual exports and messy CSV files. With this TikTok Google Sheets integration, your data is structured, fresh, and always at your fingertips.
Why Choose OWOX Free Connector for TikTok Ads to Google Sheets
If you're a marketer who wants full control over campaign data without paying for dashboards or syncing limits, this connector is for you. It loads TikTok Ads data straight into Google Sheets, where you already do your work.
Free and open-source: No subscriptions, usage limits, or hidden costs. You can inspect, run, or fork the connector directly from GitHub.
Custom field selection: Easily define the exact TikTok Ads fields (like campaign name, spend, and impressions) you want in your spreadsheet.
No-code friendly: Designed to run from your Google Sheets with just an Apps Script deployment. No setup pain, no dev dependency.
Schedule-ready: Automate daily or hourly fetches using built-in time triggers and append data to track ad performance over time.
It’s a lightweight but powerful tool for building live, self-updating TikTok Ads reports inside Sheets, without relying on vendor dashboards.
How the Connector Works
At OWOX, we built the TikTok Ads to Google Sheets connector from OWOX Data Marts (Community Apps Script Edition) to give analysts and marketers a fast, flexible way to access their ad data, without relying on external platforms or writing code.
Here’s what sets it apart:
Runs fully on open-source Google Apps Script — you can inspect, edit, or extend the logic to suit your reporting needs.
Connects directly to the TikTok Ads API to pull detailed campaign data, with full control over metrics, breakdowns, and filters.
Automatically sends that data into your Google Sheet, where you can build dashboards, blend with other sources, or share with your team.
It’s 100% free — no hidden limits, usage caps, or upgrade prompts.
If you're tired of paying for limited connectors or dealing with manual exports, this tool gives you a simple, scalable way to manage TikTok Ads reporting inside Google Sheets.
What You Can Do With This Connector
This free connector gives you powerful, flexible access to your TikTok data in Google Sheets – without the manual hassle or expensive tools. Whether you're managing campaigns, optimizing creatives, or building reports, this connector puts everything you need right at your fingertips.
Key Features
Import account-level data from your TikTok Business account, including advertiser info, balances, and currency.
Access full campaign structures – campaigns, ad groups, and individual ads – with all relevant settings and targeting.
Track performance metrics like impressions, clicks, CTR, video views, spend, conversions, and more.
Work with custom audiences to analyze targeting, sizes, types, and expiration dates for remarketing strategies.
Schedule automated refreshes – hourly or daily – to keep your reports up to date without lifting a finger.
Use incremental loading to pull only new or changed data, reducing load time and optimizing performance.
Enjoy built-in error handling that protects against API rate limits and ensures smooth, reliable data imports.
Automatically clean up old data to keep your spreadsheets lightweight and well-structured.
Data Types You Can Import
This connector supports the full spectrum of TikTok Ads data, including:
Advertiser Information: Basic details, balance data, and account-level metadata.
Campaigns: Budget info, targeting options, performance settings, and statuses.
Ad Groups: Bid settings, placements, targeting filters, and group-level controls.
Ads: Creative data, CTAs, status, URLs, and landing pages.
Performance Metrics: All the KPIs you care about: clicks, conversions, views, engagement, and advanced video metrics, including support for TikTok organic data to Google Sheets.
Custom Audiences: Insights into size, type, creation dates, and validity for audience segmentation.
and much more…
What You’ll Need to Get Started
A Google Account with access to Google Sheets
A TikTok Business Account with advertiser access
A TikTok API access token with the right permissions (we’ll show you how to set up one)
Step-by-Step: Import TikTok Ads Data to Google Sheets
Setting up your TikTok data takes just a few minutes – no dev time, no coding, no friction. Here’s how to go from zero to insights with ease.
Step 1: Copy the Google Sheets Template (~1 min)
Start with a ready-made template designed for TikTok Ads – no need to build one from scratch.
Redirect URL (you can use a placeholder like http://localhost:8080)
Select the following scopes:
Read Ad Account Information
Read Campaigns
Read Ad Groups
Read Ads
Read Custom Audiences
Click “Submit”
App approval can take up to 7 business days. If your submission isn’t approved the first time, try updating your app description to make it clearer, then resubmit. Once approved, you’ll receive a confirmation email like the one shown below.
Generate an Access Token
Copy the Advertiser Authorization URL and open it in your browser
After login, you’ll receive an auth_code in the redirect URL
Exchange the code for an access token by POSTing to: https://business-api.tiktok.com/open_api/v1.3/oauth2/access_token/
Include:
app_id – Your app’s ID
auth_code – The received code
secret – Your app secret
4. Getting Advertiser IDs
Once you’ve got your token, call: https://business-api.tiktok.com/open_api/v1.3/oauth2/advertiser/get/
Include the token in the Access-Token header. The response will list available advertiser IDs.
5. Manage Credentials
Go to the custom menu and click: OWOX → Manage Credentials This confirms your access token is active and tied to your spreadsheet.
6. Enter Your TikTok Business API Credentials
Open the configuration tab in your connector template
Enter the app ID, app secret, access token, and advertiser ID as instructed
Token Validity
TikTok tokens are valid for 24 hours
For daily use, generate a new token or implement a refresh process
Security Notes
Keep your access token and app secret secure
Don’t share credentials
For production environments, always implement secure token refresh logic
Step 4: Run the Source (~1 min)
Let’s bring that data in. You can run it manually or automate it on your schedule.
Manual Run
Select OWOX > Run Import Process from the custom menu
Track progress in the “Logs” sheet
Scheduled Run
Daily: OWOX > Schedule > Set Daily Schedule
Hourly: OWOX > Schedule > Set Hourly Schedule Remove all: OWOX > Schedule > Delete All Schedules
Step 5: View Available Objects (~30 sec)
Stay informed about what data you can bring in at any time.
Select OWOX > Show Available Objects
View a list of all supported objects and their fields in the “Logs” sheet
Data Import & Troubleshooting
This connector is designed to give you fast, structured, and resilient access to TikTok Ads data in Google Sheets – but like any API-based tool, there are a few technical nuances to keep in mind. Here’s how data is imported and what to do if something goes wrong.
How Data Import Works
Catalog data (like advertisers, campaigns, ad groups, and ads) is fetched immediately when the connector runs.
Time series data (such as ad_insights) is retrieved day by day based on your configured lookback window.
Each type of data is automatically stored in its own sheet, clearly labeled (e.g., "advertiser", "campaigns", "ad_insights").
When new data is available, the connector updates existing rows or adds new ones, ensuring you always work with the latest version.
Troubleshooting Common Issues
1. Authentication Errors
Make sure your TikTok access token is valid and not expired.
Tokens expire every 24 hours, so you’ll need to generate a fresh one regularly.
2. Missing Data
Double-check your date range settings in the template.
Ensure you’ve entered the correct advertiser IDs.
Confirm that TikTok has data available for the fields and dates you selected.
3. Rate Limiting
If you encounter API rate limit errors, try reducing your refresh frequency.
TikTok API rate limits vary depending on app type and permissions, so plan accordingly.
4. Ad Insights Data Level Errors
If you see a message like “Missing required field(s): data_level”, be sure to set the DataLevel parameter.
Supported values:
AUCTION_ADVERTISER
AUCTION_CAMPAIGN
AUCTION_ADGROUP
AUCTION_AD
Each level changes how your metrics are aggregated and which dimensions are allowed.
The connector automatically:
Adjusts dimensions to match your selected DataLevel.
Filters out invalid metrics and retries the request with valid ones.
Limits the number of dimensions to 4 or fewer to stay within TikTok’s API restrictions.
5. Metric Restrictions
TikTok’s API enforces strict rules: metrics and dimensions must not overlap.
The connector removes dimension fields (like date_start, stat_time_day) from the metrics list to stay compliant.
It uses a predefined list of valid metrics, and if none match, it will fall back to safe defaults like spend, impressions, and clicks.
Real-Time Visualization with OWOX Reports
Want to go beyond raw data?
Use the OWOX Reports Extension for Google Sheets to turn your TikTok to Google Sheets data into interactive dashboards – no scripts, formulas, or Studio required.
With OWOX Reports, you can: 📥 Pull fresh TikTok data directly into Sheets 📊 Create shareable dashboards with filters, breakdowns, and charts ✅ Empower your team with real-time access to campaign performance
No code. No copy-paste. Just smarter decisions.
What’s Next?
This free TikTok to Google Sheets connector from OWOX Data Marts (Community Apps Script Edition) advances our goal of giving everyone clear, transparent control over their data.
Explore more resources below:
🔗 More free connectors – including Reddit Ads and Microsoft Ads Connector for Sheets, and other key marketing platforms.
🎥 Step-by-step video tutorials – so you can follow along and set everything up with ease.
📊 Prebuilt dashboard templates – designed to help you get actionable insights instantly.
Check out our GitHub repo, leave us a ⭐ star, and let’s build better tools together.
.jpg)
