TikTok AdsGoogle Sheets™

Connect TikTok Ads to Google Sheets

Replace recurring TikTok Ads CSV exports with a workspace-scoped spreadsheet query over completed Monstera reporting imports.

Request pilot accessReview setup steps

Workflow details

What this connection supports

Availability is scoped to the certified pilot path. Provider definitions and access requirements still apply.

Reporting data

  • Daily campaign and ad-group performance
  • Spend, impressions, clicks, CTR, and CPC
  • Conversions, revenue, and ROAS when returned by TikTok

Before you start

  • A live TikTok for Business advertiser authorization
  • A Monstera workspace with TikTok Ads enabled
  • The Monstera Google Sheets add-on

Know before relying on it

  • Standard campaign reporting is supported; GMV Max coverage requires separate live-account validation
  • TikTok report tasks must complete before rows are available

From authorization to a report you can verify

  1. 01

    Authorize

    Connect TikTok Ads from the selected Monstera workspace.

  2. 02

    Import

    Choose a date window and run the first warehouse refresh.

  3. 03

    Verify

    Inspect the outcome, row count, and latest metric date in Data Explorer.

  4. 04

    Report

    Open the Google Sheets™ workflow and query the verified workspace data.

Common questions

  • Does this include TikTok Shop?

    No. TikTok Ads and TikTok Shop are separate products. This certified workflow covers TikTok for Business advertising reports.

Compare all certified connector workflows

Trust & security

Built for teams who outgrow manual spreadsheets

Monstera is not a generic spreadsheet — it is a connector workspace with OAuth to your ad platforms, encrypted credentials, and optional delivery to Google Sheets™ or Looker Studio™. You keep ownership of your Google accounts and ad logins.

OAuth & encryption

Platform sign-in uses each vendor's OAuth. Tokens and keys are encrypted at rest. Traffic uses modern TLS. See our Privacy Policy.

What we don't do

We don't sell your ad data. The Sheets add-on is scoped to the active spreadsheet, and reporting data remains scoped to the selected Monstera workspace.

Vs DIY exports

Manual CSVs and one-off scripts break when APIs change. Monstera normalises metrics across TikTok, Meta, Shopee, and Google Ads so your team spends time on decisions — not glue code.

Built for reporting teams across Southeast Asia — configured pricing can be viewed in USD or VND.