Social media reporting automations

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.

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.

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.

Using the EmbedSocial MCP, find low-rated Google reviews and send each review with a short summary to Slack [choose channel]. Check this widget [widget name].

Using the EmbedSocial MCP, pull recent Google reviews from [source] and analyze sentiment, recurring themes, complaints, praise, and recommended actions.

Using the EmbedSocial MCP, pull all Google Reviews from the last calendar month, plus the month before it as a baseline, for [business/location]. Summarize average rating, review volume, rating trend versus the month before, top praise themes, top complaint themes, and recommended actions. Create a formatted executive report in Google Docs with clear headings and a short summary at the top.

Using the EmbedSocial MCP, export reviews and daily rating averages for the last 90 days into a "Review trends" tab in my Google Sheet. Append only the dates that are not already in the tab and leave existing rows in place, so the tab keeps its full history each time this runs.

Using the EmbedSocial MCP, pull Threads mentions from [source] and summarize topics, sentiment, standout posts, and recommended responses.

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.

Using the EmbedSocial MCP, pull Threads mentions from [source] for the last 30 days. Analyze sentiment as positive, negative, or neutral, group recurring themes, quote one example post for each theme, and export the results into a Google Sheet.

Using the EmbedSocial MCP, compare Threads posts mentioning [my brand] and [competitor] from [widget/source]. Compare mention volume, sentiment, recurring praise, recurring complaints, and standout posts. Summarize the results in a table and give me 3 positioning takeaways.

Using the EmbedSocial MCP, scan today's Threads mentions from [source]. Find negative posts or complaints that need attention. For each flagged post, include severity, reason, suggested response, and post link. Send the summary to Slack channel [channel].

Using the EmbedSocial MCP, pull this month's Threads posts from [source]. Create a monthly listening report with mention volume, sentiment breakdown, top posts, recurring themes, risks, opportunities, and recommendations for next month. Format the output as a Gamma-ready report outline with slide titles and short slide copy.

Using the EmbedSocial MCP, pull Instagram mentions and UGC posts from [source]. Extract product feedback, complaints, feature requests, recurring questions, and praise. Group the feedback by theme, count how often each theme appears, include example posts, and export the results into Google Sheets.

Using the EmbedSocial MCP, pull TikTok campaign posts from [source] for [campaign hashtag]. Analyze sentiment as positive, negative, or neutral, identify recurring reactions, highlight the top 10 posts by engagement, and export the results into Google Sheets.

Using the EmbedSocial MCP, pull TikTok mentions from [source]. Analyze the posts by market or language where possible. For each market, summarize mention volume, sentiment, top themes, top posts, and recommended actions. Export the results into Google Sheets.

Using the EmbedSocial MCP, pull this month's Instagram mentions and UGC posts from [source]. Create a monthly Instagram listening report with mention volume, top posts, sentiment, recurring themes, product feedback, campaign highlights, and recommendations. Format the output as a Gamma-ready report outline with slide titles and short slide copy.

Using the EmbedSocial MCP, pull this week's reviews and rating average, then save a summary with highlights and concerns to my Notion workspace.

Using the EmbedSocial MCP, sync new reviews from [widget] into my Airtable base with reviewer, rating, date, and text.

Using the EmbedSocial MCP, list the pages and widgets with review or UGC placements, then compare against Google Search Console impressions and CTR to find pages where social proof lifts SEO.

Compare CTA clicks on product widgets with Amplitude conversion rates for the last 30 days.