Quick Guide to automate your TikTok Ads report with Google Sheets (with template!)

By November 23, 2022No Comments3 min read

There are many tools out there that allow you to pull data easily from your TikTok Ads accounts into a Google Spreadsheet for further processing. However, they usually come at a monthly cost. Therefore, we would like to share a solution to automate this data pulling for free by using our template!

In this article, we will also share what you need in order to use our template, things to look out for, and what the report will look like.


In order to use Tiktok API to pull data, you will first need to register as a developer here and create an app.

For the expected outcome, please refer here to see support dimensions and metrics.

(Keep in mind that there can only be one ID dimension and one time dimension in each request. For example, you can only have campaign_id with stat_time_day but not with the adgroup_id or ad_id ID dimensions)

Wait until your app is approved

After the app is approved, you will see your app id and secret.

The next thing you should get from the app is an authorization code (auth code).
Here is how you can get the auth code:

  1. First, go to
  2. Choose your app

    Click on Marketyze Business Manager
  3. Now you will see app information including app id and secret
  4. Then you will need to copy the URL from Advertiser authorization URL

    Click on Copy

  5. You will need to open the copied URL in a new browser’s tab. It will redirect you to permissions page and you will need to go through verification process
  6. Once you’ve verified, you will again be redirected to whatever you had entered as the app’s Advertiser Redirect URL

    Here you will be able to see your auth code in the URL. See our Marketyze example below!

Please keep in mind that the auth code is for a one time use only. If you need to generate a new auth code, you will need to generate a new token as well.

Now you’re ready to get your TikTok Ads data!

STAGE 1: Generate your access token!

  1. Make a copy of this Google Sheet


  2. In the tab name “(1) Generate Token”, fill in your app id, auth code, and app secret.

    Click on application

  3. Then click on the “Generate Token” button

  4. Once it’s done, you will see the access token with run status and time

Click on application

STAGE 2: Get your report!

  1. In the tab name “(2) Configure”, fill in your report name, ad account id, data level, dimensions, metrics, and date range.

    Click on application
  2. Click on the “Run Report” button. This might take a long while, perhaps around 3-5 minutes

    Click on Drawing

  3. Once done, you will see the run status and the new tab created with a Tiktok_ prefix along with your defined report name

    Your report is ready! Below an example

Untitled step

If you want to run the report again, go back to the sheet and click the “Run report” button in the sheet “(2) Configure.” There is no need to recreate the token. Please keep in mind however, that re-running the report will override — and not merge — the previous data.

We’d love to hear from you if, and how you are using this template. If you need any help, please feel free to contact us via email:

Leave a Reply


Our website uses cookies and other tracking technologies to improve your browsing experience as set in our Privacy policy.

Privacy Preferences

You can turn your cookie settings on and off. Cookies of each type are available on request, except for necessary cookies.

Allow All
Manage Consent Preferences
  • Necessary cookies
    Always Active

    These cookies are strictly necessary for the operation of our website. You cannot disable these cookies.