Whathead
  • Builder
  • MCP server
  • Transfer
  • Guardrails
  • Pricing
  • Blog
  • Docs
Log inSign up free
  1. Home
  2. Google Sheets add-on
  3. Google Sheets connector: TikTok Ads
Google Sheets connector: TikTok Ads

TikTok Ads data in Google Sheets

Whathead for Google Sheets is a TikTok Ads connector for Google Sheets. It writes TikTok Business API report data at the cell you select and refreshes on demand or on a schedule. You get 616 TikTok metrics and 51 dimensions, from cost and video views to website, app, SKAN, TikTok Shop and offline events, split by campaign, ad group, ad or audience. The add-on is free to install; queries need a Whathead trial or plan.

Updated 18 Nov 2026
Get the Sheets add-onSee pricing
Source
TikTok Business API v1.3
Fields
616 metrics, 51 dimensions
Accounts per query
Up to 50 advertisers
Report types
Basic and audience, at 4 levels
Granularity
Total, daily or hourly
Availability
Marketplace listing pending; access via support
On this page
Account totals that match Ads ManagerMetric groupsDimensionsCreate a TikTok Ads reportFAQRelated

Account totals that match Ads Manager

TikTok reports at four data levels: advertiser, campaign, ad group and ad. Whathead picks the level from the fields in your query. A plain "cost by date" query runs at advertiser level, which includes deleted entities and Branded Mission spend, so it matches the account total in TikTok Ads Manager. Adding a campaign, ad group or ad field moves the query down a level, and adding an audience dimension switches it to TikTok's audience report.

TikTok allows at most 30 days per daily request and 1 day per hourly request. Whathead splits longer ranges into allowed chunks and joins them, and it requests large metric sets in batches so you can pull hundreds of columns at once.

Metric groups

GroupExamples
DeliveryCost, net cost, cash and voucher cost, impressions, gross impressions, reach, frequency, CPM, destination clicks and CTR
ResultsResults, cost per result, real-time results, conversions, conversions by conversion time, deep funnel results
Video2-second and 6-second views, 6 and 15-second focused views, 25% to 100% views, average watch time
EngagementPaid likes, comments, shares, follows, profile visits, LIVE views, interactive add-on clicks
Website events (105)Purchases, value and ROAS, adds to cart, checkouts, orders placed, landing page views
App events (154) and SKAN (118)Installs, registrations, purchases, ROAS, retention and in-app events, with SKAdNetwork versions
TikTok Shop (21) and onsite (52)Shop purchases, product page views, items purchased; onsite form submissions and purchases
Offline (80) and attributionOffline purchases, CRM events, contacts; view-through, click-through and engaged view-through conversions

Dimensions

LevelDimensions
AdvertiserAdvertiser ID and name, currency, time zone
CampaignID, name, objective type, budget and budget mode, automation type, campaign type, status
Ad groupID, name, budget, placement type, promotion type, optimization goal, billing event, bid strategy, status
Ad and creativeAd name and text, call to action, ad format, landing page URL, video ID, thumbnail and video preview URLs, display name, post URL, TikTok post ID
AudienceAge, gender, language, device platform, placement, connection type, interest category, country

Create a TikTok Ads report

  1. Connect TikTok in Whathead

    Authorize your TikTok advertiser accounts in the Whathead workspace.

  2. Open the add-on

    Extensions, Whathead for Google Sheets, Launch sidebar, then sign in.

  3. Choose fields

    Select TikTok Ads, the advertisers, metrics, dimensions such as campaign name or age, and a date range.

  4. Write and schedule

    Run the query at the selected cell and add a schedule (up to 5 per spreadsheet) so it refreshes without the file open.

Frequently asked questions

How do I install the TikTok connector?

It is part of the Whathead for Google Sheets add-on. The public Google Workspace Marketplace listing is not live yet, so email [email protected] from your Whathead account address and the team will help you get access.

Is the TikTok Ads to Google Sheets connector free?

The add-on is free to install. Queries need an active Whathead trial or any paid plan, from $29 a month with a 14-day free trial.

Can I split by age and gender?

Yes. Adding an audience dimension such as age, gender, country or placement moves the query to TikTok's audience report. Some combinations are limited by TikTok; for example, interest categories cannot be split by date.

Does it include Spark Ads and creative details?

Yes. Ad-level queries can include the TikTok post ID, post URL, video ID, thumbnails and preview URLs next to performance.

Can I report TikTok and Meta side by side?

Yes. Put a Facebook Ads query and a TikTok Ads query on the same sheet, each writing its own table, and combine them with your own formulas or a summary tab.

Related

  • Whathead for Google Sheets
  • Facebook Ads to Google Sheets
  • Snapchat Ads to Google Sheets
  • TikTok Ads MCP
  • Looker Studio connector
  • Windsor.ai alternative

Run it from one workspace

Every plan starts with a 14-day free trial. Only successful live work is metered.

Get the Sheets add-onCompare plans
Whathead© 2026 Whathead. Multi-platform ad operations and an Ads MCP server.
Product
PricingMCP serverMeta Ads MCPGoogle Ads MCPCross-platform transferAd anomaly detectionServer-side trackingGoogle Sheets add-onLooker Studio connector
Compare
Supermetrics alternativePipeboard alternativeRyze AI alternativeWhathead vs Meta’s official MCP
Resources
BlogDocsAboutSupportContact
Legal
Terms of ServicePrivacy PolicyRefundsSecurity & DataLog in