How to Connect TikTok Ads to Google Sheets

TikTok Ads Manager doesn't have a native Google Sheets export. Unlike Google Ads or Facebook Ads, TikTok hasn't built in direct spreadsheet integrations. But you can still automate your TikTok reporting with the right tools—and get your data updating daily with zero manual work.

This guide walks you through four methods, from the easiest (5-minute setup) to the most flexible (custom API integration). By the end, you'll have your TikTok Ads data flowing automatically into Google Sheets, ready for analysis, client reports, or executive dashboards.

Why TikTok Ads + Google Sheets?

TikTok's native analytics dashboard has limitations. You get basic metrics, but combining data across multiple ad accounts or comparing TikTok performance against Meta and Google Ads requires exporting data repeatedly and pasting it into spreadsheets—which is slow and error-prone.

Google Sheets solves this by becoming your centralized reporting hub:

• Unified Reporting: Pull TikTok, Meta, Google, and LinkedIn ads data into one dashboard
• Historical Tracking: Store performance data week-over-week and month-over-month to spot trends
• Client Sharing: Share live dashboards with clients or stakeholders without exposing your ad accounts
• Custom Analysis: Build formulas to calculate ROAS, ROI, efficiency metrics, or any KPI specific to your business
• No Manual Work: Set it once, and data syncs automatically every day

Whether you're managing ads for your own business or handling multiple client accounts, automated reporting saves hours every week.

Method 1: Using MetricNexus (Easiest)

MetricNexus is the fastest way to get TikTok Ads into Google Sheets. It's built specifically for this—no coding, no complicated setup, no worrying about API rate limits.

Step 1: Connect Your TikTok Account

First, sign up at MetricNexus and navigate to the integrations page. Click "Connect TikTok Ads."

You'll be redirected to TikTok's login. Sign in with the account that has admin access to your Business Center. MetricNexus will ask for permission to read your ad accounts, campaigns, and performance metrics.

Important: This requires Business Center access. If you're managing ads for a client, ask them to add you as an admin or use a Business Center invitation link.

[Screenshot: MetricNexus TikTok OAuth flow]

Step 2: Select Campaigns and Metrics

After connecting, MetricNexus shows all your active campaigns. Select which ones you want to sync to Google Sheets (or select "All campaigns" for automatic updates when you launch new ones).

Then choose the metrics you need:

Performance Metrics:

• Impressions, clicks, CTR
• Spend, CPM, CPC

Video Metrics:

• Video views (2-second, 6-second, complete view)
• Average watch time
• Video completion rate

Conversion Metrics:

• Conversions, conversion rate
• Cost per acquisition (CPA)
• Return on ad spend (ROAS)

Engagement:

• Likes, comments, shares
• Engagement rate

Most users start with: Spend, Impressions, Clicks, Conversions, CPA, ROAS. You can add more later.

[Screenshot: MetricNexus metric selection interface]

Step 3: Connect Google Sheets

Click "Connect Google Sheets." MetricNexus will ask for permission to create and edit spreadsheets in your Google account. Authorize it, and you're done with authentication.

Next, choose whether to:

• Create a new spreadsheet (MetricNexus creates one with your preferred name)
• Use an existing spreadsheet (select from your Google Drive)

MetricNexus will set up all the column headers automatically—no manual setup needed.

[Screenshot: Google Sheets connection confirmation]

Step 4: Set Your Sync Schedule

Choose how often data syncs to Google Sheets:

• Daily (most popular—data updates every morning)
• Weekly (Sunday recommended)
• Custom (choose your own days/times)

MetricNexus also offers hourly sync for enterprise plans if you need real-time dashboards.

Hit "Activate," and you're done. Data will start flowing into Google Sheets within a few minutes.

Setup time: 5-10 minutes Cost: Free tier includes up to 3 ad accounts; paid plans start at $29/month

Method 2: Using Coupler.io

Coupler.io is a general-purpose data integration tool with TikTok Ads support. It's more flexible than MetricNexus but requires a bit more setup.

Setup Steps:

1. Sign up at coupler.io
2. Create a new integration and select "TikTok Ads" as the source
3. Authenticate: Log in with your TikTok Business account (same OAuth flow as MetricNexus)
4. Select data: Choose campaigns and metrics you want
5. Choose destination: Select Google Sheets
6. Map columns: Coupler asks which columns to use (it pre-fills these, but you can customize)
7. Set schedule: Choose daily, weekly, or custom sync times
8. Run: Hit save, and the first sync happens immediately

Coupler.io Pros & Cons:

Pros:

• Free tier available
• Supports many ad platforms (great if you want to integrate multiple sources)
• Good UI for non-technical users

Cons:

• Slightly longer setup than MetricNexus
• Free tier has a 10-row limit (paid starts at $19/month for unlimited)
• Less TikTok-specific optimization than MetricNexus

Best for: Users who need to integrate multiple ad platforms or want a lower-cost option

Method 3: Using Windsor.ai

Windsor.ai focuses on multi-platform attribution and has a TikTok Ads connector. It's designed for agencies and performance marketers.

Setup:

1. Go to windsor.ai and create an account
2. Add a new data source and select TikTok Ads
3. Authenticate with your TikTok Business account
4. Select campaigns and metrics
5. Choose Google Sheets as the destination
6. Set up your sync schedule

Windsor.ai Pros & Cons:

Pros:

• Built-in attribution modeling (good if you care about multi-touch attribution)
• Optimized for agency workflows
• Competitive pricing ($50-200/month depending on scale)

Cons:

• More expensive than MetricNexus for small teams
• Limited metric selection compared to native TikTok reporting
• Steeper learning curve

Best for: Agencies managing multiple client accounts with complex attribution needs

Method 4: TikTok API (For Developers)

For developers who want full flexibility, TikTok's official Marketing API lets you query any data and push it to Google Sheets however you want.

High-Level Steps:

1. Register an app in TikTok's developer portal
2. Get API credentials (Client ID, Client Secret)
3. Implement OAuth 2.0 to authenticate your application
4. Write code to query the Marketing API (Python, Node.js, etc.)
5. Push data to Google Sheets using the Sheets API
6. Deploy as a scheduled job (Heroku, AWS Lambda, Cron job on your server)

Example Flow:

Code block (markdown)Your Script → TikTok Marketing API → Google Sheets API → Your Sheet

Resources:

• TikTok Marketing API Docs
• Google Sheets API Docs
• Node.js + TikTok API Example

Setup time: 2-6 hours (depending on your coding experience) Cost: Free (just server/hosting costs if you use cloud services) Best for: Custom solutions, developers, or high-volume data needs

TikTok Ads Metrics Explained

When setting up your integration, you'll see many metric options. Here's what each category means:

Video Performance Metrics

Video Views: TikTok tracks views at different completion thresholds:

• 2-second views: User watched at least 2 seconds (still-scrolling territory)
• 6-second views: User watched at least 6 seconds (they're paying attention)
• 100% completion: User watched the entire video (high engagement signal)

Average Watch Time: The average length (in seconds) that users watched your video before scrolling.

Completion Rate: Percentage of viewers who watched the full video. A 40%+ completion rate is good for TikTok; 60%+ is excellent.

Engagement Metrics

Clicks: How many times users clicked your ad (usually the link or CTA). This includes link clicks, button clicks, and engagement clicks (likes, comments).

Click-Through Rate (CTR): Clicks divided by impressions. A 5%+ CTR is solid for TikTok ads; top performers hit 10%+.

Engagement Rate: (Likes + Comments + Shares) / Impressions. Shows how much the content resonates beyond just clicking.

Conversion Metrics

Conversions: Actions users took after clicking your ad (purchases, signups, app installs, etc.). Requires TikTok Pixel setup.

Conversion Rate: Conversions / Clicks. Shows what percentage of clickers actually convert.

Cost Per Acquisition (CPA): Spend / Conversions. How much each conversion costs. Lower is better.

Return on Ad Spend (ROAS): Revenue / Spend. If you made $10,000 in revenue from a $2,000 ad spend, your ROAS is 5x.

Cost Metrics

Spend: Total amount spent on the campaign in your currency.

Cost Per Mille (CPM): Spend / (Impressions / 1000). Cost per 1,000 impressions. Helps compare cost efficiency across campaigns with different reach.

Cost Per Click (CPC): Spend / Clicks. How much each click costs. Varies wildly by industry (ecommerce: $0.50-$2; SaaS: $2-$10).

Pro Tip: Pull all of these into Google Sheets, then create formulas to calculate ratios like Impressions/Spend (efficiency) or ROAS/CPA (conversion quality). This reveals which campaigns are actually profitable, not just which ones get clicks.

Building Your TikTok Reporting Dashboard

Once data flows into Google Sheets automatically, you can build a reporting dashboard that surfaces the metrics that matter most.

Essential Dashboard Sections:

1. Campaign Performance Overview

• A summary table showing each campaign's spend, conversions, ROAS, and CPA
• Sort by spend or ROAS to identify top performers
• Add conditional formatting (green for ROAS >3x, red for <2x) to spot winners and losers at a glance

2. Video Performance Metrics

• List your top-performing creative assets by video views, completion rate, and CTR
• This helps you understand what creative resonates with TikTok audiences
• Use this to inform your next batch of ads

3. Spend Pacing

• A daily spend tracker showing you whether you're on pace to hit your budget
• Simple formula: (Daily Spend Average) × (Days in Month) = Projected Spend
• Alert yourself if you're running out of budget early or underspending

4. Trend Analysis

• Plot weekly ROAS, CPA, and CTR over time using line charts
• Spot seasonal trends, algorithm shifts, or the impact of creative refreshes
• Compare performance before and after major changes to your campaigns

5. Cross-Platform Comparison (if you use MetricNexus for other platforms)

• Side-by-side TikTok vs. Meta vs. Google Ads performance
• Which platform delivers the best ROAS? Lowest CPA? Highest conversion volume?
• Helps you allocate budget to your most efficient channels

6. Client-Ready Summary

• If reporting to clients, create a simple 1-page summary showing:
  • Total spend this month
  • Total conversions
  • Average ROAS
  • Top 3 performing campaigns
  • Month-over-month trend (up/down)

Dashboard Templates

MetricNexus includes pre-built dashboard templates that come with the integration—you don't need to build from scratch. But if you're using another tool or building custom, here's a free TikTok Ads Reporting Template you can duplicate and customize.

TikTok vs. Meta vs. Google: Comparing Data

Many businesses run ads on all three platforms. Comparing performance requires understanding that TikTok, Meta, and Google measure things differently.

Key Differences:

Attribution Windows

• TikTok: 7-day and 30-day attribution (you choose)
• Meta: 1-day and 7-day click, 1-day and 28-day view
• Google: 30, 60, or 90-day (varies by product)

This means a conversion counted on TikTok might not be counted on Meta if it happened outside the attribution window. Set all platforms to 7-day click for fair comparison.

Conversion Pixel Accuracy

• TikTok: Pixel fires accurately if pixel is installed correctly and HTTPS is enforced
• Meta: Generally more accurate, but sampling applies at low traffic volumes
• Google: Most accurate but requires proper Conversion Linker setup

Click Definition

• TikTok: Any click on the ad (including engagement elements like buttons)
• Meta: Link clicks only (by default; can be customized)
• Google: Search clicks, display clicks, etc. (varies by product)

How to Compare Fairly:

1. Normalize attribution windows: Set all three to 7-day or 30-day
2. Use the same conversion pixel across all platforms (measure the same action)
3. Compare by platform goal: ROAS for ecommerce, CPA for lead gen, CPC for traffic
4. Account for time lag: TikTok API data lags 24-48 hours; Meta is near real-time

Common Mistake: Comparing TikTok's 30-day ROAS to Meta's 7-day ROAS. The longer attribution window always inflates TikTok's ROAS. Apples to apples comparison requires matching windows.

Common Integration Issues & Fixes

Issue: "My ad account isn't showing up in MetricNexus"

Solution: You likely don't have Business Center admin access. Ask your Business Center owner to:

1. Go to TikTok Business Center Settings
2. Click "Members"
3. Invite you as an Admin
4. Try connecting again in MetricNexus

Issue: "Metrics in Google Sheets don't match TikTok's dashboard"

Usual causes:

• Time zone mismatch: TikTok dashboard shows data in your local time zone; exports may default to UTC. Set your time zone in both TikTok and your integration tool.
• Attribution window: You're looking at 30-day window in the dashboard but 7-day in Sheets. Adjust in TikTok Ads Manager > Campaign Settings.
• Data refresh lag: Some integrations sync data with 12-24 hour delay. Check your tool's sync schedule.

Issue: "No conversion data is showing"

Likely cause: TikTok Pixel isn't installed correctly on your website, or it's not firing conversion events. Check:

1. Pixel is installed on all pages (not just checkout)
2. Pixel fires conversion events for your desired action (purchase, signup, etc.)
3. Test pixel firing with browser DevTools or TikTok's Pixel Debugger
4. Wait 24 hours for data to appear (TikTok needs a day to process)

Issue: "Data is delayed—I see yesterday's metrics 2 days late"

This is normal with TikTok. The API has inherent lag because TikTok needs time to aggregate data across millions of daily transactions. All integrations (MetricNexus, Coupler, Windsor) experience the same lag. Plan for 24-48 hour delay.

Issue: "Integration stopped syncing"

Likely causes:

• Your TikTok password changed, breaking the authentication
• Your Google Sheets permissions expired
• MetricNexus/Coupler/Windsor lost API access

Solution: Log back into your integration tool, re-authorize TikTok and Google, and resync. Most tools have a "Test Connection" button to verify everything is working.

FAQ

Q: Can I export TikTok Ads to Google Sheets manually?

A: Yes, but it's tedious. TikTok Ads Manager lets you export CSV reports, but only one campaign at a time. You'd need to export each campaign separately, then manually combine them in Sheets. With 10+ campaigns, this becomes a full-day task weekly. Automation saves enormous time.

Q: Does TikTok have a native Google Sheets connector (like Google Ads does)?

A: Not yet. Google Ads has built-in Sheets integration, but TikTok hasn't created one. This is why third-party tools exist—they fill the gap TikTok's left open.

Q: Can I use Looker Studio with TikTok Ads?

A: Not directly. Looker Studio has Google Ads, Facebook, and Bing connectors, but no native TikTok connector. However, you can use the workaround: sync TikTok data to Google Sheets via MetricNexus (or another tool), then connect that Sheet to Looker Studio. This gives you a live dashboard that updates daily.

Q: What if I manage multiple client accounts?

A: MetricNexus, Coupler, and Windsor all support multiple ad accounts. You can create separate integrations for each client, or use a single integration that syncs all client accounts to a master reporting spreadsheet.

Q: Is my data secure? Does the integration tool see my conversion values?

A: Reputable tools (MetricNexus, Coupler, Windsor) encrypt all data in transit and never store your credentials. They only have read-only access to metrics—not to customer data or payment info. Still, check their privacy policy before connecting.

Q: How far back can I pull historical data?

A: Most tools pull data starting from when you connect. Some offer options to backfill historical data (up to 1-2 years). If historical data matters for your analysis, ask your integration tool about backfill options before signing up.

Next Steps

You now have everything you need to automate TikTok Ads reporting. Here's what to do:

1. Pick a method: Start with MetricNexus if you want fastest setup (5 minutes). Use Coupler if you're also syncing other ad platforms. Use the API if you're a developer building custom solutions.

2. Set up your integration: Follow the steps in your chosen method above. Should take 5-60 minutes depending on which tool.

3. Build your dashboard: Once data flows in, create a reporting sheet with the key metrics that matter to your business (ROAS for ecommerce, CPA for SaaS lead gen, etc.).

4. Sync other platforms: If running ads on Meta or Google, set up integrations for those too. A unified dashboard showing all your ad platform performance is incredibly powerful.

5. Share with stakeholders: Set up automated reports sent to your team, boss, or clients. Most tools support scheduled email reports.

6. Iterate and optimize: With daily data in Sheets, you can now spot trends quickly. Use this to test new creative, adjust budgets, and improve ROAS.

Questions about getting TikTok data into Google Sheets? Contact our team at MetricNexus—we're here to help get your reporting running smoothly.