Connect LinkedIn Ads to Google Sheets: Complete Tutorial & Free Templates (2026)

Aug 27, 2026

5 min read

Summarize this blog post with:

Running multiple LinkedIn Ads campaigns for your clients can be exciting, but it also comes with its challenges, especially when KPIs fluctuate and reports pile up. By the time you dig into the numbers, your campaigns may have already shifted path.

Why? Because without a solid tracking and reporting system in place, you’re stuck manually building dashboards and formatting endless spreadsheets, causing ROI to slip through the cracks.

That’s where the streamlined LinkedIn Ads reporting workflow comes in. With the right PPC reporting software, such as Two Minute Reports, you can automate multi-client campaign reports – all within one workspace.

In this guide, I’ll show you two effective ways to connect your LinkedIn Ads data to Google Sheets, so you can generate reports that not only save time but also provide clear, actionable insights to steer your campaigns in the right direction.

Let’s get started.

How to connect LinkedIn Ads data to Google Sheets?

You can import your LinkedIn Ads data to Google Sheets via two methods:

Method 1: Connecting LinkedIn Ads to Google Sheets using the Two Minute Reports Hub.

Method 2: Connecting LinkedIn Ads to Google Sheets using the pre-built templates.

Let’s get started with the first method.

Method 1: Connect LinkedIn Ads to Google Sheets using the Two Minute Reports Hub

The Two Minute Reports Hub is your centralized workspace for managing all your LinkedIn Ads accounts. Here’s how to get started.

Step 1: Creating a Connection

1. Go to hub.twominutereports.com and click Connections → Create Connection.

2. Inside the dialog box, complete these three steps:

Select the LinkedIn Ads connector from the list of options.

Enter the name for your Connection and authorize it by logging in with your credentials.

Enable the LinkedIn Ads accounts you want to measure performance for. Please note that you can’t query the disabled accounts.

Note: With Speedboost, you can handle high-volume LinkedIn Ads datasets and create blazing-fast reports without any delays. This is a proprietary technology of Two Minute Reports built to scale client reporting.

3. Once done, navigate back to the Hub Homepage and click Google Sheets → New Google Sheets Report.

4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.

Step 2: Configure and Run Your Query

1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.

2. Select the LinkedIn Ads accounts that you want to include from the sidebar.

3. If you're managing multiple clients, go to Clients → Manage Clients, map your LinkedIn Ads accounts to the relevant clients and click Save & Close.

4. Choose relevant LinkedIn Ads metrics and dimensions and select your date range.

5. Click Run Query to pull the data into your chosen sheet and cell.

6. The next step is to Save & Automate your query.

Pro Tip: You can set up custom refresh schedules to automate daily, weekly, and monthly LinkedIn Ads performance reporting to your clients. Choose your preferred format – PDF, Excel, or Spreadsheet and keep reports updated automatically without manually exporting data every time.

Prefer to work directly inside Google Sheets? You can also connect LinkedIn Ads to Google Sheets by installing the Two Minute Reports add-on from the Google Workspace Marketplace, following the steps below:

Open a spreadsheet. Launch the add-on from Extensions → Two Minute Reports → Launch.
Click Menu → Connections → Add and select the LinkedIn Ads connector.
Authorize your account and enable the accounts you want to query.
Click Refresh Connections to confirm your accounts appear in the sidebar.

Once connected, follow the same query steps above to start pulling your LinkedIn Ads data directly into Google Sheets.

Set up your data pipeline

PROCEED

Method 2: Using LinkedIn Ads Google Sheets Template

With Two Minute Reports’ pre-built LinkedIn Ads templates for Google Sheets, you can create custom reports within minutes. Here’s how you can:

1. In the template gallery, select the LinkedIn Ads template; let us choose the LinkedIn Ads Campaign Performance.

2. Next, click ‘Get Template for Free’ to open the Google Sheets template.

3. Then, click Use Template. You’ll land on the Google Sheets dashboard.

4. Click Use to launch the Two Minute Report sidebar in your Google Sheets.

5. Finish importing your template by selecting the required LinkedIn Ads accounts from the dropdown. Once done, click Submit to create your report.

6. Click Run Query to fill this template with the necessary data.

7. And that’s it. Your LinkedIn ads data is populated across relevant sections, helping you give a detailed overview of what’s happening and what needs to be improved.

Streamline and automate LinkedIn Ads Reporting in a single dashboard.

Start your free trial

Why import LinkedIn Ads data to Google Sheets?

Here’s why importing LinkedIn Ads data to Google Sheets helps you align better reporting needs:

1. Customize reports for every campaign

Whether you’re working on an account-based marketing campaign or a lead-gen campaign, you must create personalized client reports. With Two Minute Reports’ LinkedIn Ads Google Sheets templates, you can easily map key KPIs and customize dashboards to adapt to any campaign structure, ensuring you have the data you need, in the preferred format you want.

2. Automate data workflows

Manually copying and pasting KPIs from native LinkedIn Ads dashboards is a struggle. To overcome this, you can set up custom refresh schedules to automatically import your latest LinkedIn Ads data directly into Google Sheets. This frees up your time to focus on the strategic aspects of your campaigns, such as refining creatives, audience targeting and conversion optimization.

3. Simplify multi-client reporting

By connecting LinkedIn Ads data to Google Sheets, you create a single hub for your campaign performance data. You can map required client accounts and visualize individual performance breakdown, making it easier to identify trends and spot new opportunities. You don’t have to juggle multiple spreadsheets or send mismatched reports to clients.

4. Streamline campaign adjustments

The ability to quickly assess campaign performance and make adjustments is crucial for maximizing ROI. By extracting key LinkedIn Ads metrics such as cost per lead, click-through rates, conversion rate, etc, you can spot which campaigns are performing better, and areas of improvement – whether it’s refining your targeting, adjusting your budget or creatives.

5. Ensure data consistency

To maintain data consistency across campaigns, you can use a LinkedIn Ads reporting tool to track and report up-to-date performance insights without manual effort. Accuracy in reporting is crucial for optimizing campaigns and maximizing ROI. Remember, even a small error can potentially mislead you into moving in the wrong direction.

Important metrics to measure your LinkedIn Ads campaign performance

Here are the top metrics you can track to analyze and enhance your campaign performance:

Metric	Why does it matter?	Optimization tip
Click-through rate	A higher CTR means your ad is gaining traction and convincing visitors to take action.	Ensure your visuals and ad copy look compelling, and targeting is more relevant.
Cost Per Click	Lower CPC means you’re getting more clicks for your budget, indicating ad spend effectiveness.	Refine your audience targeting to ensure your ads reach the right people who are likely to take action.
Conversion rate	A higher conversion rate indicates your landing page and CTA resonate with your audience.	Use A/B testing to optimize landing pages and ad creatives for higher ROI.
Cost Per Conversion	Lower cost per conversion shows that you’re getting good returns on your ad spend and driving valuable actions.	Improve ad relevance and landing page experience to reduce cost per conversion.
Lead form completion rate	A higher form completion rate indicates your prospects are interested in exploring your benefit-driven offer.	Streamline the form fields and offer an incentive to encourage more completions.
ROAS	Helps you measure the profitability of the campaigns. A higher ROAS ensures you are generating more revenue per dollar spent.	Use retargeting to reach visitors who have shown interest before and improve your bidding to maximize profits.
Engagement rate	Higher engagement shows that users find your ad content relevant and are interacting with it.	Create compelling content that sparks interaction and experiment with different ad formats to boost engagement.
eCPV (Effective Cost Per View)	Helps you measure the cost efficiency of video views, indicating how much you’re paying for each video view.	Focus on targeting the right audience and optimize video content to boost engagement, ensuring you reach niche relevant audiences who are likely to resonate with your content.

Connect your PPC platforms with Google Sheets

Integrate Facebook Ads, LinkedIn Ads, Snapchat Ads, Google Ads, and other advertising platforms in a single Google Sheets dashboard using Two Minute Reports. Track key PPC metrics across all ad platforms, measure performance, and analyze cross-channel ROI. With unlimited reporting, faster data syncs, and automated workflows, stay on top of performance trends and accomplish your client’s goals.

Frequently Asked Questions

Install the Two Minute Reports add-on from the Google Workspace Marketplace. Next, open your spreadsheet, launch the sidebar, connect your LinkedIn Ads accounts and visualize actionable campaign performance insights within minutes without juggling spreadsheets.

With Two Minute Reports, you can set up custom refresh schedules – daily, hourly, weekly or monthly and ensure your campaign reports reflect the latest LinkedIn Ads campaign insights. This ensures you always stay on top of what’s happening, and implement proactive changes to optimize your client’s ROI.

You can access our free, ready-to-share LinkedIn Ads Google Sheets templates to streamline campaign tracking. Once you click “Use Template”, you can launch the Two Minute Reports add-on, import your client’s LinkedIn ad accounts, run queries and auto-populate the dashboard with meaningful insights.

With data blending, you can compare LinkedIn Ads with other advertising platforms, such as Meta, Google Ads, etc, into a single dashboard and visualize cross-channel ROI. No need to toggle between platforms or copy-paste KPIs manually.

You can select your client’s LinkedIn Ads accounts from the Two Minute Reports sidebar and consolidate key KPIs in one place. Alternatively, you can also reuse the existing reports across multiple clients, ensuring you focus more on strategy and accomplish your campaign goals.

You can automate Google Ads, Meta Ads, and LinkedIn Ads reporting with Two Minute Reports by connecting both ad accounts and pulling their campaign data into a single Google Sheets or Looker Studio report. Choose the metrics you want to track, such as spend, clicks, impressions, CTR, conversions, CPC, and ROAS, then set a refresh schedule to keep the report updated automatically. You can also blend data from both platforms to compare campaign performance and schedule recurring reports for clients or stakeholders.

Meet the Author

Shalini Murugan

Shalini is driven by ideas that create a tangible impact. At Two Minute Reports, she specializes in content that helps marketers optimize their reporting workflows. When she's not transforming complex data into meaningful insights, you might find her lost in a book, jotting down ideas in her notebook, or connecting the dots others overlook.

Connect Linkedin Ads in Google Sheets

Try for Free