Import TikTok Lead Generation Data To Google Sheets

“How do I connect TikTok’s lead generation to Google Sheets?”
“Can you link TikTok ads to Google Sheets?”
“How can I see my TikTok ads performance in a spreadsheet

– Advertiser

You are a TikTok advertiser. You spend hours every day on data entry and analysis to keep up with the latest developments in your industry. It takes hours to manually track the results of your TikTok ads. As advertisers, we have to stay on top of everything from analytics to lead generation campaigns.

It’s tough to juggle work when you’re also responsible for handling almost all the work, especially on the reporting side. You’re switching between your TikTok and other tools like a headless chicken. In this article, I’ll show a simple hack on how to automate this nightmarish task.

Why Pay for Automation at All?

Automations solve huge problems in organizations. So, most automation tools are paid products. Yes, you can do everything manually for free to save money. But in perspective, you might want to spend a little to save time. The number of hours that you take back to avoid hellish and repetitive work is worth the price. You choose.

busy desktop

I hate a super cluttered desktop. You ever experienced a desktop full of spreadsheet files? I hate them. It increases stress and productivity comes to an all-time low. The amount of time I clicked the Export CSV button is unbearable. Automation avoids all of this and is useful when you’re tracking a lead generation campaigns.

How To Import TikTok Ads Data To Google Sheets

This article shows two options on how to import TikTok ads data to Google Sheets. Option 1 is using a Google Sheets add-on. Option 2 is using a third-party integration tool. Both don’t require coding skills.

Option 1: Google Sheets Add-On

You’ll use Two Minute Reports for this option. Two Minute Reports imports data from the TikTok ads manager account directly to Google Sheets in minutes. Another Google Sheets add-on to use is Supermetrics.

two minute reports 01

Installing the Google Sheets Add-on

1 – Go to your Google Drive workspace.

2 – Click + New then create a new Google Sheets file.

tmr 0
tmr 00

3 – At the top of your file, click on Extensions. Then click on Add-ons. Then click on Get add-ons.

sheets 01

4 – Search for Two Minute Reports. Then install it.

tmr 1

5 – You now have the add-on installed on your Google Sheets file.

sheets tmr 01

Import TikTok Ads Data Source

1 – Launch the add-on. A navigation pane on the right side appears.

sheets tmr 02

2 – Click on Add + under Data Sources.

tmr 4

3 – Name your data source. Then select TikTok Ads.

tiktok ads sheets 01

4 – Sign-in to your TikTok ads manager account. Click on Authorize.

tiktok ads sheets 02

5 – In the permissions page, select all for access. Then click on Confirm. Make sure the account you’re giving access to has access to TikTok ads manager as well to proceed.

tiktok ads sheets 03

5 – Go through the Verification process until the tool instructs you to close the tab since the sign-in is successful.

ga4 to sheets 03 template

Import TikTok Ads Data Query

This point in the process is importing data from the TikTok ads manager to the spreadsheet.

1 – Click on the burger icon. Then click on Data Queries.

2 – Click on Add +.

tmr 11

3 – Name your data query. Then find the TikTok ads data source you imported earlier.

4 – Save on Sheet is the location of the sheet where the data is imported to, so make you know what your tabs are named after. Add A1 under Cell in this example.

tiktok ads sheets 04

5 – Under Query, select the TikTok ads account you want to get data from.

6 – Under Metrics, select the metrics you want to import. In this example, we use Impressions, Clicks, CPC, Reach, Impressions, and Conversions.

7 – Under Dimensions, select the dimensions you want to import. In this example, we use Campaign name, and Ad name.

8 – Under Date, Select the date range to your use case. In this example, it’s the Last 30 days.

As for the Filters and other Data Options, you may leave them unticked or empty for now.

tiktok ads sheets 05b

9 – Click on the Run query button.

Viola! You imported your TikTok ads data to Google Sheets much quicker! You can create reporting templates from here depending on your business needs.

Schedule TikTok Ads Reports

Two Minute Reports has a scheduling function. This means the spreadsheet refreshes the acquired data from the API. Reports are automated even more.

1 – Click on the burger icon. Then click on Schedule Refresh.

2 – Click on New +.

tmr fb5

3 – Once inside, you can set the terms of the report schedule.

-Name
-Repeats: This is where you set how often the data refresh happens. Two Minute Reports can do hourly refreshes.
-Timezone

tmr li3

4 – You can also set the notification terms. Two Minute Reports can email you a PDF or Excel of the data. You can also decide to have the email contain the sheet content in the email body.

tmr fb7
tmr fb8

5 – Click on Save.

Scheduling helps when you need to report on GA4 events and engagements overtime. No more copy and paste every day, or every week, or every month.

Option 2: Integration Tool

You’ll use Make for this option. Make is a powerful integration platform that allows you to visualize, design, and automate your work in minutes. In other words, it lets apps talk to each other so that you can remove repetitive tasks.

Create a Make account and get started.

make 01

Getting Started

1 – Click on + Create a new scenario. This is where you start building the connection between tools.

make 02b

2 – Once inside, click on the HUGE circle with a PLUS SYMBOL.

make 03

Setting Up TikTok Connection

1 – Search for TikTok ads. Then select List Ad Reports.

tiktok ads sheets 06 make 1

2 – Under Connection click on Add.

3 – Under Connection name, name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

tiktok ads sheets 07 make

4 – Click on Save. A pop-up window appears.

4 – Inside the pop-up window, Log-in to the TikTok account you want to get data from.

5 – In the permissions page, select all for access. Then click on Confirm. Make sure the account you’re giving access to has access to TikTok ads manager as well to proceed.

tiktok ads sheets 03

Back in Make, input all necessary parameters.

6 – Under Advertising ID, select the TikTok advertiser account you want to get data from. Note that yours is different so you need to familiarize yourself with the names and labels.

7 – Under Service Type, select Auction.

8 – Under Report Type, select Basic Report.

9 – Under Data Level, select Auction Ad.

10 – Under Dimensions, select any based on your needs. In this example select Campaign ID and Ad Group ID.

11 – Under Metrics, select any based on your needs. In this example select cpc, impressions, clicks, reach, and conversion.

12 – Under Lifetime, select Yes. This will import data since the start of data collection.

13 – Under Limit, just select 10. This is the maximum number of results be reported.

tiktok ads sheets 08 make

14- Click on OK.

Done! At this point, you’re finished with the TikTok ads connection side. The tool prompts you if there are missing values in the fields.

Go back to the canvas and press right-click. Then select Add a module.

Setting Up Google Sheets Connection

Next is setting up the Google Sheets connection. But first, you need to go to Google Drive and create a new Google Sheets file.

1 – Go to your Google Drive workspace.

2 – Click on + New then create a new Google Sheets file.

tmr 0
tmr 00

3 – Name the Google Sheets file. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

integromat 07 sheets

4 – Name the tab or sheet on the bottom. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

integromat 07 sheets2

5 – Name the headers. It’s helpful to map out the correct data point in the integration process later.

Column A
Column B
Column C
Column D

integromat 07 sheets3

The first steps are done! Go back to Make.

1 – Press right-click. Click on + Add a module. Or you can double-click then click on the HUGE circle with a PLUS SYMBOL.

2 – Search for Google Sheets. Then select Add a Row.

mailchimp sheets integromat 06

3 – Under Connection, click on Add.

4 – Name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

make 06 sheets

5 – Click on Continue. A pop-up window appears.

6 – Inside the pop-up window, select the Gmail account that stores the Google Sheets file.

make 04

7 – Click on Allow. Make asks permission to access your Google account. This is standard procedure. The window closes after clicking it.

make 05

Back in Make you add the additional parameters.

8 – Under Choose a Method, choose Select by path.

9 – Under Choose a Drive, select My Drive. The spreadsheet you created earlier is likely located here.

10 – Under Spreadsheet ID, select the Google Sheets file you created earlier. Find the name you gave it.

11 – Under Sheet Name, select the Google Sheets tab from earlier. Find the name you gave it.

12 – Under Table contains headers, select Yes.

After which, the Values are created.

make 07 sheets

11 – Under Values is where it gets tricky. The headings from the Google Sheets file are the parameters where you decide the values. Once you click on the field, you’re presented with different parameters. Don’t be overwhelmed. Read the context of the parameters to know which one is mapped to which.

integromat 07 sheets7

Under (A), select Dimensions: Campaign ID.
Under (B), select Metrics: Impressions.
Under (C), select Metrics: Clicks.
Under (D), select Metrics: Cpc.

The parameters that appear here are from the TikTok connection you added earlier. Other parameters are also available. Make sure to add an extra column and name it on the Google Sheets spreadsheet so on and so forth.

12 – Click on Ok. Now it’s time to run and process the integration.

13 – Click on Run once with a play button icon.

make 08

A spinning wheel and a Log on the bottom right appear. Wait for the integration to finish. How long the integration takes depends on the Maximum number of results you select. It’s finished when a) green checkmarks appear, and when b) The scenario run was completed appears in the Log.

tiktok ads sheets 09

Go to your Google Sheets file and you now see the organic posts successfully imported from TikTok. Viola! Congratulations you imported campaign reports to Google Sheets with complete information! You may also add other parameters or fields if you need them.

Schedule Automation and Reports

Make can schedule the automation based on cycles. The schedule is up to you.

1 – On the screen, click on the Scheduling button and turn it on.

make 08

2 – Under Run scenario, select the schedule you need. What you select on this parameter dictates the next ones.

If you select At regular intervals, you need to select the minutes that Make processes the automation.

If you select Once, you need to select the date.

If you select Every day, you need to select the time.

If you select Days of the week or Days of the week, you need to select the days.

make 09

3 – Click on Ok. Ignore any advanced settings for now.

Viola! Congratulations you’re automating sending TikTok ads data to Google Sheets!

Conclusion: Build TikTok Ads Reports Faster

This is one of the many was to import TikTok ad campaigns data in Google Sheets: integrate third-party tools. These add-ons cost money, but the benefits outweigh more. Avoid import and export hell. Stop wasting time on repetitive tasks and start taking action.

Running a business is a never-ending cycle of work. This no-code solution doesn’t need you to learn coding or Python. It’s frustrating to juggle all of your responsibilities. Invest in tool automation and avoid repetitive tasks. Integrate apps you use every day. Time is precious for you so get back to doing what matters most: growing your business.


About The Author