Send LinkedIn Pages reports to Google Chat
Load LinkedIn Pages into your data warehouse first, link it to the rest of your data with SQL keys, then post organic and paid follower gain where the brand team already talks. The message comes from your source of truth, not from an API call that can break.
LinkedIn PagesConnectedFollower Statist…Time-Bound Follo…
Google ChatOrgan…TimeTimeDaily 09:00The brand team asks in Google Chat if the page is still growing, and waits for someone to open LinkedIn Pages.
Paste this into your AI assistant. It builds a LinkedIn Pages follower Data Mart in your data warehouse and posts organic and paid follower gain to the Google Chat space through a webhook every week.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/linkedin-pages-insights-to-google-chat.md. The task: post last week's organic and paid LinkedIn Pages follower gain to our brand team's Google Chat space every Monday, compared with the week before. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
LinkedIn Pages Endpoints
2 LinkedIn Pages endpoints you can import. Each lands in its own table in your data warehouse.
Why LinkedIn Pages does not go straight to Google Chat
LinkedIn Pages reports how many people followed the page, not what the page did for pipeline. A message built straight from the source puts the source's own numbers in the space and does not tie them to the rest of the business reliably, at scale or business-ready, so the join happens in a warehouse first.
- Follower gain is an organic page metric, set apart from the ad spend that pushed it
- The data analyst links the tables by SQL keys and controls what a message may say
- The space reads one scheduled message instead of several tabs and an export
LinkedIn PagesPage followersGoogle Chat
Data warehouseJoined by idStep 1: Load LinkedIn Pages into your data warehouse first
Create a Data Mart with LinkedIn Pages as the source and choose where the data lands. It works with any popular data warehouse.
- Two endpoints, Follower Statistics and Time-Bound Follower Statistics, each in its own table
- Open the LinkedIn Pages connector for your data warehouse below
LinkedIn Pa…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databrickslinkedin_pages.follower_stati…Step 2: Link LinkedIn Pages follower statistics in one Data Mart
In your data warehouse the model joins the follower tables on the organization, so follower gain by period sits in one Data Mart.
- Both endpoints share one key, organization_urn, so they join without a guess
- Organic and paid gain per period come from one table, not two exports
- The numbers are defined once, in the Data Mart
Step 3: Send LinkedIn Pages reports to Google Chat
Add an incoming webhook in the Chat space (Apps & integrations, Add webhooks), paste its URL into a Google Chat destination in OWOX, and attach a report of the LinkedIn Pages Data Mart. The message is a Markdown template.
- The message is a card with the subject, the Data Mart name, your text and a link back to the report
- The table carries time_range_start, organic_follower_gain, paid_follower_gain and organization_urn
- Tables arrive as monospace blocks, and a long report is split into numbered parts
Google ChatWeeklyWeekly LinkedIn page growthtime_range_startorganic_followe…paid_follower_g…organization_urnStep 4: Add a short analysis under the LinkedIn Pages report in Chat
Write the reading under the table in the template, or let an Insight on the same Data Mart write it. Then add a trigger on the Triggers tab: OWOX runs the Data Mart first and checks the sending condition.
- Send always, or only when the result is not empty, so a quiet week stays quiet
- The reading comes from the report's fields and adds no cause the data does not show
- One space can receive several reports, each with its own trigger
Google ChatWeekly LinkedIn page growthtime_range_startorganic_followe…paid_follower_g…organization_urnAnalysisOrganic and paid follower gain for each period.Paid gain beside organic shows what advertising added.Gain is per page and period, not split by segment.Step 5: Reuse LinkedIn Pages inside OWOX MCP
The Data Mart behind your Chat message also works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- Change the LinkedIn Pages report once and the next Chat message reads the change
Google SheetsOpen
ExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.41.0Reuse one Google Sheets or Google Chat key across Destinations
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.36.0Start a connector run without expanding the Input Source card
Why OWOX for LinkedIn Pages in Google Chat
Hand-built bots and webhook scripts post numbers into a space. OWOX also keeps the data yours, linked and ready to model.
- You own the data. LinkedIn Pages lands in your own data warehouse, in tables you control.
- Brand growth in the thread. Follower gain lands in the space the brand team reads, so a quiet period gets noticed the same day.
- The webhook stays simple. Paste the space's webhook URL once; it is stored write-only and several destinations can share it.
- Same numbers everywhere. The LinkedIn Pages Data Mart behind the message also feeds your reports and your AI assistant.
- Maintained for you. No bot code to fix when LinkedIn Pages changes its API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.