No-code pipeline · TikTok Ads → Google Sheets

Send data from TikTok Ads to Google Sheets

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

From TikTok Ads to Google Sheets: managed, scheduled, no code.

Kondado replicates TikTok Ads data to Google Sheets through seven available pipelines including Campaign Report, Ad Group Report, and Advertiser Report, updating automatically every 5 minutes, 15 minutes, hourly, or daily based on your configuration.

Connect TikTok Ads now →

Connect TikTok Ads to Google Sheets Automatically

How to send TikTok Ads data to Google Sheets? Kondado offers a direct integration that automates the replication of your advertising metrics without requiring technical expertise or manual CSV exports. Simply authenticate your TikTok Ads account, select Google Sheets as your destination, and choose which performance data to replicate. The platform supports automated data refreshes on a configurable schedule, ensuring your spreadsheets always contain the latest campaign insights for analysis and reporting.

Marketing teams use this connection to consolidate performance metrics from video advertising campaigns into collaborative spreadsheets where they can build custom dashboards and share insights with stakeholders. By automating the data flow, analysts save hours previously spent on manual downloads and can focus on optimizing creative performance, budget allocation, and audience targeting across multiple campaigns without switching between platforms or managing complex API connections.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With the Campaign Report pipeline, you can monitor budget efficiency and impression trends across all active campaigns directly within your collaborative spreadsheet environment. The Ad Group Report pipeline delivers granular performance data that helps you compare targeting strategies and engagement rates by audience segment, while the Metadata: Ads pipeline provides detailed creative attributes and advertiser information. Together, these datasets enable you to build custom performance dashboards in Google Sheets that reveal which video formats drive conversions, allowing teams to optimize creative rotation and reallocate budgets toward high-performing content without leaving their preferred analysis tool.

Try out all the features for free for 14 days

Replicated to Google Sheets

TikTok Ads data available for Google Sheets

Tables Kondado writes into your Google Sheets, on a schedule you control.

available pipelines

231

extractable fields

Google Sheets

Destination

Available integrations

Ad Group Report

Analyze the performance of ad groups with metrics such as impressions, clicks, and cost, along with dimensions like advertiser id and report date.

Ad Report

Examine ad performance with metrics such as impressions, clicks, and cost, and details like advertiser id and report date.

Advertiser Report

Evaluate advertiser performance with metrics such as impressions, clicks, and cost, along with dimensions like advertiser id and report date.

Campaign Report

Monitor campaign performance with metrics such as impressions, clicks, and cost, and details like advertiser id and report date.

Metadata: Ads

Access detailed information about ads, including advertiser id and performance attributes.

Metadata: Campaigns

Explore data about campaigns, including advertiser id and performance metrics.

Metadata: Ad Groups

Discover information about ad groups, including advertiser id and performance attributes.

See all available data → Send TikTok Ads to Google Sheets →

Try out all the features for free for 14 days

How to send TikTok Ads data to Google Sheets

Sync data automatically — no code, no manual exports.

Connect Your TikTok Ads Account

Log into Kondado and add TikTok Ads as a new data source by providing your authentication credentials to establish the connection.

Configure Google Sheets Destination

Select Google Sheets as your destination and specify the target workbook where your advertising data will be replicated.

Select Pipelines and Schedule

Choose from the seven available pipelines such as Campaign Report or Ad Group Report, then set your preferred update frequency from every 5 minutes to daily.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from TikTok Ads to other destinations

TikTok Ads > Looker Studio

TikTok Ads > Power BI

Other visualizations

TikTok Ads > Amazon S3

TikTok Ads > BigQuery

TikTok Ads > Excel

TikTok Ads > Google Sheets

TikTok Ads > MySQL

TikTok Ads > PostgreSQL

TikTok Ads > Redshift

TikTok Ads > SQL Server

Choose a tool to visualize your TikTok Ads data

If the software you need is not listed, drop us a messagem. You can use almost every tool

TikTok Ads > Airtable

TikTok Ads > Alteryx

TikTok Ads > Amazon Quicksight

TikTok Ads > BIMachine

TikTok Ads > Cortex

TikTok Ads > Data Studio

TikTok Ads > Geckoboard

TikTok Ads > Grafana

TikTok Ads > IBM Cognos Analytics

TikTok Ads > Klipfolio

TikTok Ads > Looker Studio

TikTok Ads > Looker

TikTok Ads > Looqbox

TikTok Ads > Metabase

TikTok Ads > Microstrategy

TikTok Ads > Pentaho

TikTok Ads > Power BI

TikTok Ads > Qlik Cloud Analytics

TikTok Ads > Qlik Sense

TikTok Ads > Qlik

TikTok Ads > QlikView

TikTok Ads > Redash

TikTok Ads > Superset

TikTok Ads > Tableau

TikTok Ads > BI TOTVS

TikTok Ads > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending TikTok Ads data to Google Sheets automatically

What TikTok Ads metrics can I pull into Google Sheets? ▼

Kondado offers seven pipelines including Campaign Report, Ad Group Report, Ad Report, and Advertiser Report, covering metrics such as impressions, clicks, cost, and performance dimensions. You can also access metadata pipelines for Ads, Campaigns, and Ad Groups to analyze creative attributes alongside performance data.

How often does TikTok Ads data update in Google Sheets? ▼

Kondado supports automated refreshes ranging from every 5 minutes to daily intervals, allowing you to balance data freshness with your reporting requirements. Choose your preferred cadence during setup to ensure your spreadsheets reflect the most recent advertising metrics without manual exports.

Can I combine TikTok Ads data with other marketing platforms in Google Sheets? ▼

Yes, you can replicate data from multiple sources into the same Google Sheets workbook, including TikTok Ads, Facebook Ads, or Google Ads. This allows you to build unified cross-channel reports that compare performance metrics across different advertising platforms in one collaborative environment.

What is the difference between Campaign Report and Ad Group Report pipelines? ▼

The Campaign Report pipeline provides high-level performance metrics organized by campaign ID and date, ideal for budget overview and strategic planning. The Ad Group Report pipeline offers more granular data broken down by specific ad groups, enabling detailed analysis of targeting effectiveness and audience engagement within each campaign.

Do I need coding skills to set up TikTok Ads to Google Sheets replication? ▼

No coding is required to configure this connection. Kondado provides a no-code interface where you authenticate your TikTok Ads account, select your desired pipelines, and specify your Google Sheets destination through a guided setup process.

Can I send TikTok Ads data to destinations other than Google Sheets? ▼

Yes, Kondado supports multiple destinations including BigQuery, PostgreSQL, Power BI, and Looker Studio. You can also send data to MySQL, Excel, Redshift, SQL Server, or Amazon S3 depending on your analytics infrastructure needs.

How is the data structured when it arrives in Google Sheets? ▼

Each pipeline creates a separate sheet within your workbook, with columns representing the 231 available fields such as advertiser ID, report date, impressions, clicks, and cost. The data arrives in a clean, structured format ready for pivot tables, charts, and custom formulas without requiring additional cleaning or transformation.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days