Free TikTok Ads to Google Sheets Connector by OWOX: Unlock Fresh Ad Insights with Zero Effort

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, 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.

Why Bring TikTok Ads Data into Google Sheets?

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.

Google Sheets

Data sources

Free TikTok Ads Connector to Google Sheets

Download template

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 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:

1. Advertiser Information: Basic details, balance data, and account-level metadata.
2. Campaigns: Budget info, targeting options, performance settings, and statuses.
3. Ad Groups: Bid settings, placements, targeting filters, and group-level controls.
4. Ads: Creative data, CTAs, status, URLs, and landing pages.
5. 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.
6. 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.

1. Copy the TikTok Ads Connector template in Google Sheets.
2. Rename the copy as desired.

Master TikTok Ads → Google Sheets Reporting With Our Free Template!

Skip manual exports and messy API calls – this ready-to-use Google Sheets template helps you import TikTok Ads data in just a few clicks.

Download your FREE template today!

Step 2: Configure the Source (~2 min)

Time to plug in the right settings, so your connector knows what to fetch and from where.

1. In your copy of the spreadsheet, go to the “Config” sheet.
2. Set the Start Date

• Specify when the data import should begin.
  Note: Using a long date range may cause the import to fail due to data volume limits.

3. Locate Your TikTok Advertiser ID

• In your TikTok for Business dashboard, find the Advertiser ID on the left-hand navigation panel.

• Copy and paste it into the AdvertiserIDs field in your Config sheet.

4. Select the Data Fields

• Go to the Fields tab.
• Check the boxes for the metrics, breakdowns, and dimensions you want to include.

Note: Some fields might already be selected by default. 

5. Add Additional Fields (Optional)

• To further customize your data, stay in the Fields tab and check any additional fields you'd like to include.
• Further, specify the following parameters in the sheet:

• IncludeDeleted: Default is FALSE.
• SandboxMode: Default is FALSE.
• Redirect URL – Specify the OAuth callback URL (required only for OAuth authentication).
• Destination Spreadsheet – Leave blank to load data into the currently open spreadsheet.
• Destination Sheet Name – Defaults to a sheet named Data; the sheet is created if it doesn’t exist. Accepts either a sheet name or a sheet ID.
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31) 
• CleanUp To Keep Window: Automatically deletes rows older than the specified number of days from today. Leave blank to retain all.

Step 3: Get a TikTok Ads Access Token ( ~4–5 min)

Before we start importing, let’s make sure you’ve got the right access credentials in place.

Prerequisites

• A TikTok for Business account
• Advertiser-level access to the accounts you want to pull from
• Developer access to create an app

Steps to Obtain Credentials

1. Create a Developer App
   
   • Visit the TikTok for Business Developers portal
     Log in with your TikTok Business credentials
   • Click “Become a Developer” and fill out the form:
     
     • First & Last Name
     • Communication Email
     • Company Type
   • Click “Next” and complete your application

2. Configure the App
   
   • Under “My Apps”, click “Create an App”
   • Enter:
     
     • App name
     • App description
     • 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. 

3. 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

1. Once you’ve got your token, call: https://business-api.tiktok.com/open_api/v1.3/oauth2/advertiser/get/
2. 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.

1. Manual Run

• Select OWOX > Run Import Process from the custom menu
• Track progress in the “Logs” sheet
  
  

2. 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.

1. Select OWOX > Show Available Objects
2. 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 is just the first step in our mission to make data ownership simple, transparent, and accessible for everyone.

Here’s what’s coming soon:

🔗 More free connectors – including LinkedIn Ads, Microsoft Ads (formerly Bing Ads), 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.

Google Sheets

Data sources

Free TikTok Ads Connector to Google Sheets

Download template