Automated LinkedIn Ads reporting with n8n, Google Sheets and Looker Studio

Overview

LinkedIn Ads are a core B2B channel, but reporting often takes more time than optimisation. This project builds an automated pipeline that pulls campaign data on a schedule, calculates KPIs centrally and delivers them in a clear dashboard.

Scope

• Automated retrieval of campaign, ad and performance data via the LinkedIn Ads API
• Central KPI logic in n8n (CTR, CPC, CPM, conversions) including data cleanup
• Store the processed data in Google Sheets as a historical source of truth
• Looker Studio dashboard with filters, time comparisons and consistent KPIs

Challenges

• Manual CSV exports and multiple spreadsheet versions
• Inconsistent KPI calculations between teams and periods
• Delayed data updates and limited historical comparisons
• Reporting effort without additional insights

Tech stack & integrations

• LinkedIn Ads API for campaign and performance data
• n8n for scheduling, processing and KPI calculations
• Google Sheets as the data layer for BI tools
• Looker Studio for dashboards and reporting views

Result

Reports stay current, KPIs are defined once and comparisons across time ranges are available instantly. Marketing, management and clients access the same dataset without manual exports.

Business impact

• Less manual reporting work
• Reliable KPIs for better decision-making
• Faster check-ins with up-to-date numbers
• Improved comparability across campaigns and time ranges