How to pull TikTok Ads reports straight into Google Sheets

📰 Dev.to · Julian Reiter

Learn to automate TikTok Ads reports into Google Sheets using the TikTok Marketing API and a CLI tool, saving time and increasing productivity.

intermediate Published 20 Apr 2026

Action Steps

Install the aigen-reports CLI tool to interact with the TikTok Marketing API
Set up a TikTok Ads account and generate an API token for authentication
Configure a cron job to run a script that fetches ad reports using the TikTok Marketing API
Use the Google Sheets API to write the fetched reports into a Google Sheet
Schedule the cron job to run daily to automate the report generation process

Who Needs to Know This

This tutorial is beneficial for digital marketers, especially those managing multiple TikTok ad campaigns, as it streamlines report generation and analysis. It also appeals to developers interested in automating tasks using APIs and CLI tools.

Key Insight

💡 The TikTok Marketing API and aigen-reports CLI tool can be used together to automate the process of generating and exporting ad reports to Google Sheets, saving time and effort.