Export widget engagement metrics into Google Sheets
Use EmbedSocial's widget engagement agent to pull performance data for your widgets and turn it into a spreadsheet you can track over time.
ClaudeGoogle SheetsOne connection. Runs on your live EmbedSocial data.
What does it do?
Connect EmbedSocial with Claude or ChatGPT and Google Drive to create an agent that exports widget-level engagement metrics: post clicks, icon clicks, lightbox opens, and CTA clicks, into a spreadsheet. Instead of checking each widget's dashboard individually, the agent pulls the numbers for the period you specify and logs them in one place your team can filter and compare.
Useful for
- Tracking widget performance over time: build a running log instead of checking dashboards one by one;
- Comparing engagement across widgets: see at a glance which placements are driving the most interaction;
- Reporting to stakeholders: export a clean spreadsheet ready to share or plug into other reports.
How to set up
- 1
Create your EmbedSocial account
Sign up for a free EmbedSocial trial to connect your widgets and turn on the MCP.
Start free trial - 2
Confirm your widgets are live
Make sure the widgets you want metrics for are published and collecting data.
- 3
Connect Google Drive in your AI tool
Make sure your AI environment can create or update a spreadsheet.
- 4
Set up the EmbedSocial MCP in Claude or ChatGPT
Paste the MCP URL into your AI tool and authorize access with your EmbedSocial account.
- 5
Run the prompt
Ask your AI tool to pull the engagement metrics and export them 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.
Real-world use case
Imagine you manage several widgets across different pages and want a single view of how each is performing. Instead of opening each widget's analytics one at a time, you ask Claude or ChatGPT:
Using the EmbedSocial MCP, pull media and engagement metrics: post clicks, icon clicks, lightbox opens, and CTA clicks, for my widget [widget] over the last 90 days. Export the results into Google Sheets with one row per day and clear column headers.
Your AI tool pulls the widget's engagement history and creates a spreadsheet your team can use for reporting or trend tracking.
More Analytics automations
Compare Instagram competitor hashtags in Google Sheets
Using the EmbedSocial MCP, pull Instagram posts from [source] tracking #[brand one] and #[brand two]. Calculate share of voice, track daily post volume for each hashtag, break down sentiment as positive, negative, neutral, or sarcastic for each brand, group posts into recurring conversation themes, and list the top related hashtags for each brand. Export the results into Google Sheets with a raw data tab and a summary dashboard.
Build an Instagram competitor comparison report in Google Slides
Using the EmbedSocial MCP, pull Instagram posts from [source] tracking #[brand one] and #[brand two]. Calculate share of voice, daily volume trend, sentiment breakdown, main conversation themes, and top related hashtags for each brand. Export the output as a Google Slides presentation with slide titles and short slide copy, including a methodology slide and suggested next steps.
Send weekly social proof report to Slack
Using the EmbedSocial MCP, pull last-7-days widget analytics (post clicks, lightbox opens, CTA clicks), identify top movers, and post a weekly social proof report to #growth in Slack.
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.