Import LinkedIn Ads API Data To Google Sheets

LinkedIn advertising is a major channel in the advertising industry. Like other marketing channels, it needs reporting. The LinkedIn Ads API (application programming interface) may be hard to understand for others to start and the interface might be confusing to use.

Google Ads is better with reporting since it’s within the Google ecosystem. So, this means that the integration is easier. And you can start interpreting the data quickly. LinkedIn Ads, and other marketing channels like Facebook, don’t have that luxury.

You CAN import LinkedIn Ads data from the API to Google Sheets. You do copy and paste until your eyes and fingers can’t take the mundane task anymore. That’s manual reporting and it’s an unbearable nightmare.

Who Benefits from this Automation?

I see two groups that might benefit from the automation to import LinkedIn Ads to Google Sheets. Both teams require time to constantly update email messages.

a) LinkedIn marketers: LinkedIn marketers are great at optimizing campaigns. But they don’t have the time to build reports. They need to dedicate hours strategizing which audience to advertise to.

b) Business Development and Sales teams: A salesperson who is involved in Lead Generation saves time when leads are automatically sent to a spreadsheet and then analye the data.

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, instead, 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. Ever experienced a desktop (or Downloads folder) 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 this.

How To Import LinkedIn Ads Data To Google Sheets

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

Method 2: Integration Tool

You’ll use Integromat for this method. Integromat 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 an Integromat account and get started.

Getting Started

1 – Click on Templates. The tool already has a template since this scenario is a standard case.

integromat 02b

2 – Search and click on the template: Add a new row to a Google Sheets spreadsheet from a LinkedIn Lead Generation Ads form submission.

linkedin sheets integromat 04

2 – Click on the Create new scenario from template button from the lower left of the page.

integromat 03

Setting Up LinkedIn Connection

The first section is setting up the Shopify connection.

1 – Under Webhook click on Add.

Once inside, name the Webhook. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

linkedin sheets integromat 05

2 – Once inside, Under Connection, click on Add.

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

3 – Click on Continue.

linkedin sheets integromat 03b

4 – Select the LinkedIn account you want to get data from.

5 – Click on Allow.

linkedin sheets integromat 08

6 – Back in Integromat, Under Ad Account URN, select the Linkedin billing admin.

7 – Click on Save.

linkedin sheets integromat 03

8 – Click on Continue.

9 – To make the integration simple, click on Continue until you reach the Google Sheets integration. Ignore the purple or violet icon. This is an additional setting only.

linkedin sheets integromat 09
Ignore this setting for now

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 Integromat.

1 – Under Connection, click on Add.

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

gmail to sheets integromat 12b

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

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

integromat 04

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

gmail to sheets integromat 13

6 – Back in Integromat, under Mode, choose Select spreadsheet and sheet. This is to make the integration simpler.

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

8 – Under Sheet, select the Google Sheets tab from earlier. Find the name you gave it. After which, the Values are created.

integromat 07 sheets5

9 – 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 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 form answers. 'First name'.
Under (B), select form answers. 'Last name'.
Under (C), select form answers. 'Company name'.
Under (D), select form answers. 'Email name'.

The parameters that appear here are from the LinkedIn connection. 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.

10 – Click on Continue. Now it’s time to run and process the integration.

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

integromat 06

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.

linkedin sheets integromat 06

Go to your Google Sheets file and you now see the campaign data successfully exported from LinkedIn.

Viola! Congratulations you imported LinkedIn Ads data to Google Sheets with complete information! You may also add other parameters or fields if you need them.

Schedule Automation and Reports

Integromat 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.

integromat 06

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 Integromat 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.

gmail to sheets integromat 18b

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

Viola! Congratulations you’re automating LinkedIn ads reporting in Google Sheets!

Method 1: Google Sheets Add-On

You’ll use Two Minute Reports for this example. Two Minute Reports imports data from the LinkedIn Ads API directly to Google Sheets in minutes.

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 Google Sheet, click on Add-ons. Then click on Get add-ons.

tmr 2

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

tmr 1

Import LinkedIn Ads Data Source

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

tmr 15

2 – Click on the burger icon. Then click on Data Sources. Click on Add + button.

tmr 16

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

tmr li1

4 – Log in to your LinkedIn account.

tmr li2

5 – Link your LinkedIn account to the tool. Go through the login process until the tool instructs you to close the tab since the sign-in is successful.

tmr 9

Import LinkedIn Ads Data Query

This point in the process is importing data from the LinkedIn Ads API to the spreadsheet.

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

tmr 11

2 – Name your data query. Find the LinkedIn data source you imported earlier.

3 – Save on Sheet is the location of the sheet where the data is imported to. Add A1 under Cell.

tmr li4

4- Under Query, select the LinkedIn Ad Account you want to get data from.

5 – Select the date range with whatever you need.

6 – Select the Metrics you want to import (Impressions, Clicks, Company Page Clicks, Likes, Comments, etc).

7 – Select the Dimensions you want to import (Campaign name, Creative id, etc).

tmr li5

8 – Click on Run query.

Viola! You imported your LinkedIn ads data to Google Sheets hassle-free. You can create reporting templates from here depending on your business needs.

Schedule LinkedIn Ads Reports

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

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

tmr fb5

2 – 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

3 – You can also set the notification terms. Two Minute Reports can email you a PDF of the data. You can also decide to have the email contain the sheet content in the email body as part of the update.

tmr fb7
tmr fb8

4 – Click on Save.

Scheduling helps when you need to report on Shopify data over time. No more copy and paste every day, or every week, or every month.

How To Add User Permissions on LinkedIn

1 – Go to your LinkedIn Campaign Manager dashboard. Pick one Ad Account.

tmr li6

2 – Once inside the Ad Account, click the gear icon on the upper right. Then click ‘Manage access’.

tmr li7

3 – Click ‘Edit’ then click ‘+ Add user to account’.

tmr li8

4 – Add either the name of the user’s LinkedIn name or LinkedIn Profile URL. Give the user at least ‘Viewer’ access.

tmr li10
tmr li9

5 – Click ‘Save Changes’. That user should now have the ability to import LinkedIn Ads data into Google Sheets.

More articles on automation:
Import Shopify Data to Google Sheets
Import Google Ads Data to Google Sheets
Import WooCommerce Data to Google Sheets
Import Facebook Page Insights to Google Sheets
Import Facebook Ads Data to Google Sheets
Export Gmail to Google Sheets
Connect Mailchimp to Google Sheets

Conclusion – Build LinkedIn Ads Reports Faster

This is one of the many add-ons to connect LinkedIn Ads data in Google Sheets. Another add-on to consider is Supermetrics. These are the current methods to do API integrations between third-party tools. These add-ons cost money but the benefits outweigh more.

Avoid import and export spreadsheet hell. Maintain everything in Google Sheets with tools if needed. Stop wasting time on repetitive tasks. Start focusing on important stuff that impacts the business. Hire a digital analyst to help you.


About The Author

Francis Angelo Reyes

Francis is the owner and runs Lupage Digital. With 5 years of experience, Francis writes everything he knows about digital marketing. There’s a large knowledge gap between developers and digital marketers. Francis is the middleman between where the non-technical and technical meet.