Analyze LinkedIn Post Performance in Google Sheets
Use EmbedSocial’s LinkedIn performance agent to analyze website widget activity for your company page posts in Google Sheets.
One connection. Runs on your live EmbedSocial data.
What does it do?
Connect EmbedSocial with Claude and Google Sheets to create an agent that pulls posts from your LinkedIn company page and retrieves activity for the website widget displaying them. The agent pulls widget post clicks, icon clicks, lightbox opens, and CTA clicks for the period you specify. It exports the available widget metrics and company page posts into a spreadsheet. These are website widget interactions, not LinkedIn platform performance.
Useful for
- Tracking widget performance over time: build a running log instead of checking dashboards one by one;
- Comparing widget activity: compare post clicks, lightbox opens, and CTA clicks by date;
- Reporting to stakeholders: export a clean spreadsheet ready to share or plug into other reports.
How to analyze LinkedIn Post Performance in Google Sheets
- Create your EmbedSocial account. Sign up for a free EmbedSocial trial to connect LinkedIn and turn on the MCP.
- Connect your LinkedIn company page as a source. EmbedSocial will collect your page’s posts.
- Let the widget collect posts. Give it time to pull in enough posts to compare. Publish the widget on your website and let it collect widget activity before reporting on clicks.
- Connect Google Sheets in your AI tool. Enable the separate Google Sheets connector in Claude on the web or Claude Desktop to create and edit spreadsheets. Google Drive alone does not provide these editing tools. Authenticate with a Google account that can access the target sheet. Team and Enterprise owners must enable connectors for their organization.
- Set up the EmbedSocial MCP in Claude. Paste the MCP URL into Claude and authorize access with your EmbedSocial account. Use a Claude environment that supports the connected tools required below.
- Run the prompt. Ask your AI tool to analyze your posts and export the results into Google Sheets.
Note: Depending on the connectors you are using, you may be prompted to authenticate your platform connections by logging into your accounts. LinkedIn tracking covers posts from the connected company Page only. It does not cover personal profiles or LinkedIn-wide keyword searches. Widget clicks, lightbox opens, and CTA activity measure interactions on your website, not reactions, comments, or reposts on LinkedIn. Only report metrics returned for the selected widget and period.
Real-world use case
Imagine you post on your company page three times a week and want to report on the website widget displaying those posts. Instead of checking each widget’s dashboard individually, you ask Claude:
Using the EmbedSocial MCP, pull posts from our LinkedIn company page in [widget] for the last [90] days. Pull available website widget post clicks, icon clicks, lightbox opens, and CTA clicks for the same period, with one row per day. Keep the company post inventory separate from widget-level metrics. Do not infer per-post LinkedIn performance or posting-time recommendations from widget totals. Export the results into Google Sheets with a raw data tab, a widget metrics tab, and a summary with three recommendations.
Your AI tool pulls your posts, analyzes them, and builds a spreadsheet of company posts and website widget activity.
Prefer to build this into your own app instead of running it from a prompt? The same posts, mentions, reviews and widget analytics are available through the social media API.
More Analytics automations
Send LinkedIn Mentions to Slack
Using the EmbedSocial MCP, pull LinkedIn mentions of our company page from [widget] posted in the last 24 hours. For each mention, write a one-line summary and include the author, sentiment, and post link. Flag any negative mentions or questions that need a reply. Post the results to the #[channel] Slack channel.
Track LinkedIn Mentions in Google Sheets
Using the EmbedSocial MCP, pull LinkedIn mentions of our company page from [widget] for the last [30] days. For each mention, log the author, date, post text, link, sentiment, and main theme. Export the results into Google Sheets with a mentions log tab and a summary tab showing weekly mention volume, sentiment breakdown, and top themes.
Build a Monthly LinkedIn Analytics Report in Gamma
Using the EmbedSocial MCP, pull our LinkedIn company page posts and LinkedIn mentions from [widget] for [last month] and [the month before]. Calculate total collected posts and mentions, and month-over-month change. Pull available website widget post clicks, icon clicks, lightbox opens, and CTA clicks separately. These measure website widget activity, not LinkedIn platform performance. Include 5 example posts, the top 5 authors by mention frequency, the sentiment breakdown of mentions, and the main themes. Report missing metrics as unavailable rather than estimating them. Then use Gamma to create a 10-slide report with an executive summary, key metrics, example posts, mentions, themes, and three recommendations for next month.
Put your social content to work from any AI tool
EmbedSocial is the social media automation platform for UGC and reviews: connect the MCP, then run any workflow from a prompt.