TikTok Ads to Google Sheets automatically
Automatically export TikTok Ads to Google Sheets: spend, impressions, clicks, reach, frequency, and conversions. API v2 — no code.
LightLead exports TikTok Ads to Google Sheets via API v2: spend, impressions, clicks, CTR, CPC, reach, frequency, and conversions at advertiser, campaign, ad group, and ad level. OAuth tokens refresh automatically and rate limits are tracked via the x-ratelimit-remaining header.
Read more
What gets exported
- Spend, impressions, clicks, CTR, CPC, and CPM
- Reach (unique users) and frequency
- Conversions (results) and cost per result
- Data across advertisers, campaigns, ad groups, and ads
- Default period — the last 30 days
Dimensions & metrics
- Entities: advertiser, campaign, adgroup, ad
- Metrics: spend, impressions, clicks, ctr, cpc, cpm, reach, frequency, conversions, cost_per_result
- Aliases: adset_* ← adgroup_*
- Advertiser list: id, name, status, role, currency, time zone
Auto-refresh
Reports refresh on a schedule — hourly, daily, or weekly. The connector accounts for the 1–3 hour API lag vs. the TikTok Ads Manager UI; compare data older than 2 days.
Example sheet
| Campaign | Date | Impressions | Clicks | CTR | CPC | Spend | Conversions | Reach |
|---|---|---|---|---|---|---|---|---|
| Spark Ads 1 | 2026-07-30 | 76,500 | 2,040 | 2.7% | $0.51 | $1,040 | 58 | 61,200 |
| Catalog Ads 2 | 2026-07-30 | 54,300 | 1,260 | 2.3% | $0.66 | $832 | 41 | 47,900 |
The values illustrate the report structure. Real data comes from your TikTok ad account.
Setup in 4 steps
- Start with LightLead and go to Integrations → Ad connectors → TikTok Ads
- Authorize via TikTok OAuth (the Analyst role is enough)
- Pick an advertiser from the account list
- Add a report: metrics, period, and schedule
Specifics & limitations
- Throttle codes 20001–20003 arrive in the response body with HTTP 200 — LightLead detects them via the code: 0 check
- Rate limit is tracked via x-ratelimit-remaining with no total; reset via x-ratelimit-reset
- Video and engagement metrics (views, likes, shares) are not requested by the connector
- The limiter works per advertiser
- API data lags the UI by 1–3 hours
Who it fits
- TikTok advertising teams: reach, frequency, and cost per result
- E-commerce: linking TikTok spend to sales via attribution
- Agencies: consolidated reports across several advertisers
Pricing
LightLead starts free (1 Meta Ads account + Instagram Insights). TikTok Ads and Ads → CRM attribution start with the Solo plan at $19/month; multiple CRMs come with Agency plans from $49/month.
FAQ
How do I connect TikTok Ads to Google Sheets?
Start with LightLead, authorize via TikTok OAuth, and pick an advertiser. The Analyst role is enough for statistics.
Why do numbers differ from TikTok Ads Manager?
The API lags the UI by 1–3 hours, and different attribution windows change conversion counts. Compare data older than 2 days.
Can I export reach and frequency?
Yes — reach and frequency are available for the selected periods.
What are codes 20001–20003?
TikTok throttles: request limit exceeded, daily quota exhausted, and concurrent request limit. LightLead handles them automatically.
How often do reports update?
On a schedule: hourly, daily, or weekly.
Full TikTok Ads connector reference: https://docs.lightlead.space/integrations/advertising/tiktok-ads/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report