Connect TikTok Ads to Google Sheets

Connect TikTok Ads to Google Sheets step-by-step:

Step 1: Collect data
First, connect your TikTok Ads account. Next, select the type of report you wish to export.



Once you've done that, go next.

Step 2: Organize and transform
Before you load TikTok Ads to Google Sheets, verify data accuracy. If you need to make some changes, here's a list of transformations you can apply:

• Edit, rearrange, hide, or add columns.
• Apply various filters and sort your data.
• Create new columns with custom formulas.
• Combine data from multiple accounts or apps.

By doing so, you can prepare your data for analysis so you won't have to adjust it after importing.



As soon as you confirm your data is correct, proceed to set up your destination.

Step 3: Load and automate
Authorize the Google Sheets account. Then, you must specify the destination spreadsheet and sheet for data import from TikTok Ads to Google Sheets. Alternatively, you can create a new sheet by providing its name in the corresponding field.



Then, move forward to set up an automated data refresh. The last action you'll take is to save and run the importer.

Enable automated refreshes to keep your imported TikTok Ads data consistently up to date. Set your preferred frequency, whether monthly, daily, hourly, or every 30 or 15 minutes. You can also choose specific days of the week, the time slot, and the time zone.



This feature ensures your ads report is synced with the ever-changing source data. So you always have the most recent information at hand.