Import Linkedin Company Pages to Google Sheets


Maintain your SEO traffic with seamless website migration. Schedule a consultation and start your brand relaunch!

LinkedIn is a major channel in the advertising industry. Companies want to know their company’s social media presence and organic brand reach. LinkedIn allows companies to gain insights into their brand performance and organic reach.

Whether it’s company page posts or organic followers, reporting is super important. But these types of reporting can be a nightmare. With the right tools, you can manage data from LinkedIn to Google Sheets. It eliminates to manually transfer and update data in both systems. This makes it easier to track and measure every post that goes out.

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.

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 marketing campaigns.

How To Import LinkedIn Company Pages To Google Sheets

This article shows two options on how to import LinkedIn page insights 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. This article focuses on LinkedIn pages and not LinkedIn Ads.

You’ll use Two Minute Reports for this option. Two Minute Reports imports data from the LinkedIn Ads API directly to Google Sheets in minutes. Another Google Sheets add-on to use is Supermetrics.

tmr sheets 01

Installation

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 extension installed on your Google Sheets file.

sheets tmr 01

Import LinkedIn Page Data Source

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

sheets tmr 02

2 – Click on Add + under Data Sources.

tmr 16

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

linkedin page to sheets 02

4 – Log in to your LinkedIn account.

linkedin page to sheets 05

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.

ga4 to sheets 03 template

Import LinkedIn Page Data Query

This point in the process is importing data from the LinkedIn Analytics 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 source you imported earlier.

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

linkedin page to sheets 06b

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

linkedin page to sheets 07

8 – Click on Run query.

linkedin page to sheets 08b

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 Page 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 overtime. No more copy and paste manual reports every day, or every week, or every month.

Conclusion: Build LinkedIn Company Page Reports Faster

Avoid import and export spreadsheet hell. Maintain everything in Google Sheets with tools if needed. Stop wasting time on repetitive tasks. With this automation, companies can understand how their campaigns are performing and make necessary changes faster. Start focusing on important stuff that impacts the business. Hire a digital analyst to help you.


About The Author

photo