Google Sheets LinkedIn Ads Overview Report

Linkedin ads Google sheets

LinkedIn is a social networking site that primarily focuses on business connections. It is one of the most well-known social media sites in the world. As of April 2022, LinkedIn had at least 828.1 million members based on advertising audience reach estimates.

Therefore, it is imperative that as a B2B marketer, corporate organization, or small business, you get detailed reporting on your marketing effort on LinkedIn.

However, the LinkedIn Ads dashboard doesn’t provide a comprehensive visualization for effective reporting, making it difficult to make informed decisions about your marketing approach.

To make sense of the data on the LinkedIn Ads dashboard, you need some understanding of its analytics tool, which takes up time and resources you don’t necessarily have.

This blog post reveals how you can connect LinkedIn Ads to Google sheets using  connector that can help you go through this process easily.  

Let’s dig in!


Connect Linkedin Ads to


Step 1 :

Login or Register in’ website.


Step 2 :

Grant access to your Linkedin Ads Account



Step 3 :

click on Google sheet as show below and copy your API KEY

Google Sheets API


Step 4 :

Add’s Extension to Google sheets.

Google sheet extension


Step 5:

Copy The template with clicking on File -> Make a copy
Template Link :  Google Sheet Linkedin Ads Overview Report

Copy tempalte google sheet


Step 6 :

Clear all data from the Raw Data Sheet

Step 7 :

Under Extensions in the top ribbon of Google Sheets, select “Add Data & Analytics by“, then “Login” and Paste your API KEY there:



Step 8 :

Now under “Add Data & Analytics by” extension press on Get Data into Sheets, then Add new query.



Select Data Source, Linkedin Ads account, Field and Data range. Now click on Load Data and your template should be ready.
PS : Make Sure in the Target sheet Name to Write ” Raw Data”