Free LinkedIn Pages to BigQuery Connector by OWOX: Own Your Organic Page Insights

Tracking engagement on your LinkedIn Page is simple. But getting that organic data into BigQuery for scalable reporting? That’s where things get messy.

If you’ve ever tried exporting LinkedIn Page insights to BigQuery, you know the pain – limited API endpoints, manual workarounds, and tools that restrict what data you can access or how often you can refresh it.

That’s exactly why we created this.

With this 100% free, no-code connector from OWOX, digital and marketing analysts can easily move raw LinkedIn Pages data to BigQuery – no ETL tools, no dev resources, no platform lock-in. You decide what gets imported, how it’s structured, and when it syncs. 

Why We Made This Free Connector

At OWOX, we believe your LinkedIn Page data should be easy to access, use, and analyze – without jumping through hoops. That’s why we built OWOX Data Marts (Community Apps Script Edition) and made it completely free. No subscriptions, no locked features, and no limits on what you can extract or automate.

Purpose-built for sending LinkedIn organic insights to BigQuery, this connector empowers analysts to move past rigid tools and take full control of how their page data is accessed, structured, and activated.

Whether you're building reporting workflows, joining Page insights with GA4 or CRM data, or just want to skip the pain of manual exports, this tool puts the data in your hands, on your terms.

💡 Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of open marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further. 

Google BigQuery

Data sources

Free Linkedin Pages Connector to Google BigQuery

Download template

Why Bring LinkedIn Pages Data into BigQuery?  

If you’ve ever tried reporting on LinkedIn Page performance at scale, you’ve probably run into common blockers:
❌ Native LinkedIn dashboards don’t support detailed exports or historical insights
❌ Manual CSV downloads are tedious and prone to errors
❌ Most ETL platforms limit your control and charge based on data volume

BigQuery changes all of that – and this connector makes it easy:
✅ Stream raw LinkedIn Page data (followers, updates, engagement) directly into BigQuery tables
✅ Blend Page insights with CRM, GA4, and content attribution data for unified analysis
✅ Automate updates and eliminate complex pipelines or third-party tools

With OWOX, your LinkedIn Page metrics land directly in BigQuery – ready for SQL queries, modeling, and real-time dashboards. 

Check out our other free connectors:
Liking the freedom of custom reports? Take it further with these plug-and-play integrations:
‍
LinkedIn Page Stats → Sheets
LinkedIn Ads → BigQuery
Facebook Ads → BigQuery
Criteo Ads → BigQuery
‍
No fees, no code—only faster, smarter reporting across every ad channel.

Why Choose OWOX Free Connector for LinkedIn Pages to BigQuery  

Many tools that promise LinkedIn Pages reporting fall short, offering limited metrics, fixed exports, and dashboards that aren’t built for flexible analysis. You’re often boxed into someone else’s schema or forced to rely on dashboards that can’t scale with your team’s needs.

This OWOX Data Marts (Community Apps Script Edition) takes a different approach, giving you the structure and flexibility to shape LinkedIn Page data to match your reporting goals.

• Specifically built for LinkedIn Page performance – not a bolt-on to a multi-platform pipeline
• Let's you select only the fields you care about – no cluttered exports or irrelevant columns
• Runs entirely inside Google Sheets via Apps Script – no external tools, subscriptions, or data delays
• Fully open-source and inspectable – you can modify, verify, or extend the logic as needed
• Ideal for brand, content, and community teams that want accurate, adaptable, and easy-to-share insights

Instead of being confined by vendor-defined pipelines, this connector gives you direct control over your LinkedIn Pages data – how it’s fetched, how often it updates, and how it fuels your reporting, without limitations.

How the Connector Works  

This LinkedIn Pages to BigQuery connector delivers what most tools can’t: full flexibility without added complexity.
It runs entirely in Google Sheets using open-source Apps Script, so there’s no need for extra platforms or costly middleware.

Here’s what it lets you do:

• Connects directly to the LinkedIn Pages API to pull data on posts, followers, engagement, and page metrics
• Sends that data straight into your BigQuery tables – no CSV exports or third-party sync tools required
• Offers full transparency and control – modify the script, adapt the logic, and scale reporting to fit your needs
• Completely free – with no usage caps, locked features, or paid plans

If you're looking to bypass expensive ETL tools and build a reporting pipeline you actually control, this connector is made for you.

Step-by-Step: Import LinkedIn Pages Data to BigQuery 

Bringing your LinkedIn Pages data into BigQuery is simple with this connector. No coding, no third-party tools – just clean, structured data in minutes.

Here’s how to set it up step by step. 

Step 1: Copy the BigQuery Template ( ~1 min)

Begin with a pre-built BigQuery template tailored for LinkedIn Pages – no setup from scratch required.

1. Copy the ”LinkedIn Pages → Google BigQuery. Template”.
2. Rename the copy as desired.

Master LinkedIn Pages to BigQuery Reporting With Our Free Template!

Skip manual exports and complex setup – this ready-to-use BigQuery template lets you import LinkedIn Pages data in just a few clicks.

Download your FREE template today!

Step 2: Configure the Template ( ~1 min)

Configure your data import settings directly in the BigQuery template.

• Set the Start Date

• Go to the Config sheet.
• Enter the desired Start Date for importing historical LinkedIn Pages data.

Note: Avoid selecting a long range as it may cause the import to fail due to high data volume.

• Add Your Organization URNs
  
  • Go to LinkedIn Campaign Manager.
  • Navigate to: Ad Account → Assets → Company Page.
  • Copy the numeric portion from the URL (e.g., https://www.linkedin.com/company/123456/admin/).
    In this example, 123456 is your Organization URN.
    

Note: The above image is just for reference purposes.

• Paste the Organization URN into the appropriate field in the Config sheet.

• Select the Data Fields
  
  • Go to the Fields tab in the template.
  • Check the boxes for each metric, breakdown, or dimension you want to include in the import.

Note: Some fields may be preselected by default. 

• Configure the BigQuery destination fields:
  - Enter your Destination Dataset ID in this format: projectid.datasetid
  - Specify the Destination Location (e.g., US, EU) 

If the specified dataset doesn’t exist yet, it will be created automatically when you run the import.

Further Specify the Fields with the Following Parameters:

• MaxFetchingDays: Max number of days to fetch per run (default: 31)
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)

This ensures your LinkedIn Pages to BigQuery data flow has a proper landing zone - clean, structured, and ready for analysis. 

Step 3: Get a LinkedIn Access Token ( ~30 seconds)

To authorize the connector, you’ll need a valid LinkedIn Pages API access token. Here’s how to generate one safely:

• Visit the LinkedIn Developer portal.
  
  
  • Navigate to: https://www.linkedin.com/developers/
    
• Create a new app:
  
  
  • Click the Create App button.

• Enter your App Name.
• Paste the link to your company’s LinkedIn page in the LinkedIn Page field.

• Upload your company logo.
• Accept the legal agreement and click Create App.

• Verify your app:
  
  • Go to the Settings tab.
  • Click the Verify button. 

The admin of your LinkedIn company page will receive a request to approve the app.

• Copy the Verification URL.

• Make sure your LinkedIn app shows as “Verified” under App Settings..

• Request Access to API:
  
  • Once your app is verified, navigate to the Products tab in the LinkedIn Developer Portal.
  • Find the necessary APIs and submit your access request.

Note: To access LinkedIn Page data-such as posts, followers, reactions, comments, shares, and engagement metrics for organic content, you must request access to both of the following APIs:

• Share on LinkedIn
• Community Management API

‍

Note: Approval may take up to 24 hours. You’ll receive an email once approved.

• Once approved, the Share on LinkedIn and Community Management API will appear under the Added Products section.

• Generate an access token:
  
  • Go to the Auth tab.
  • Click OAuth 2.0 Tools on the right-hand panel.

• Click the Create Token button.

• Configure scopes:
  
  • If you see the error: "There aren't any scopes available for this app…", it means the Advertising API access has not been granted yet.

• Ensure the required scopes are selected:

r_organization_social

r_organization_followers

r_social_engagement

• Then click Request access token.

• Authorize and copy the token:
  
  • On the next screen, click Allow to approve access.

• Your access token will be created and ready to use. 
• Copy and securely store the token – you’ll use it to authorize the OWOX template.

Note: Make sure you are copying the Access Token, not the Refresh Token. The Access Token is located at the top of the page.

Step 4: Input Access Token into the Template (~1 min) 

After generating your LinkedIn Pages access token, enter it into the OWOX template to enable data imports.

• In your copied BigQuery template, go to the top menu and click:
  → OWOX → Manage Credentials

• In the credentials popup:
  
  • Paste the access token into the provided field
  • Click OK to save and apply the token

Step 5: Run the Connector & Import Your Data ( ~1 min)

After setting up your credentials and configurations, you're ready to bring LinkedIn Pages data.

• Open the Import Menu
  
  • In the spreadsheet menu, click: OWOX → Import New Data

• The Logs sheet will display “Import is finished” when done.
  Your data appears in dedicated tabs.

📊 Real-Time Reporting with OWOX Reports

Want to turn your LinkedIn Pages data in BigQuery into actionable insights?

With the OWOX Reports Extension for Google Sheets, you can build live dashboards – no SQL or BI tools required. 

Here’s what you can do:
📥 Pull LinkedIn Pages data directly from BigQuery into Google Sheets
📊 Build dynamic dashboards that refresh with a click
✅ Share real-time performance insights with your team – without technical effort

No code. No delays. Just fast, flexible reporting powered by your BigQuery data. 

What’s Next? 

This free LinkedIn Pages to BigQuery connector is our ongoing effort to make data ownership simple, transparent, and accessible for everyone.

Here are more resources to explore:

🔗 More free connectors – including Microsoft Ads, Reddit Ads Connector for BigQuery, and more
🎥 Step-by-step video walkthroughs – to simplify setup and usage
📊 Ready-made dashboard templates – for instant, insightful reporting

Check out our GitHub repo, give us a ⭐ star, and join us in building a more open, transparent future for marketing analytics.

Google BigQuery

Data sources

Free Linkedin Pages Connector to Google BigQuery

Download template