Social media reporting automations

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.

Open in

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.

Open in

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.

Open in

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.

Open in

Using the EmbedSocial MCP, pull LinkedIn mentions of our company page from [widget] for the last [90] days. Group the posts by author and rank each author by number of mentions, number of active weeks, and average sentiment. Sort them into three tiers: top advocates, rising advocates, and one-time mentioners. Export the results into Google Sheets with a ranked advocates tab, a top posts tab with links, and a raw data tab.

Open in

Using the EmbedSocial MCP, pull my TikTok videos from [widget] and the competitor videos added as sources. Extract every hashtag from the captions. For each brand, calculate how often each hashtag is used, average engagement per hashtag, and the top 10 hashtags by engagement. List the hashtags the competitor uses that I don’t. Export the results into Google Sheets with a raw data tab, a hashtag comparison tab, and a summary with recommendations.

Open in

Using the EmbedSocial MCP, pull my TikTok account videos and TikTok mention videos from [widget] for [last month] and [the month before]. For both my videos and mentions, calculate total videos, total engagement, and month-over-month change. Find the top 5 videos by engagement, the top 5 creators mentioning the brand, the sentiment breakdown of mentions, and the main trending themes. Then use Gamma to create a 10-slide report with an executive summary, key metrics, top content, creators, sentiment, themes, and three recommendations for next month.

Open in

Using the EmbedSocial MCP, pull all posts from [widget] tracking #[event hashtag] between [start date] and [end date]. Calculate total posts, posts per day, total engagement, top 10 posts by engagement, and top 10 contributors. Group the main themes and overall sentiment. Write a recap report in Google Docs with an executive summary, key numbers, top posts with links, and themes, and export the raw post data into a Google Sheet.

Open in

Using the InvisibleAPI MCP, get Instagram account insights for [account] for the last 30 days. Request two separate reach breakdowns: one by media product type (Reels, feed posts, Stories), and one by follow type (followers vs. non-followers). Keep the breakdowns separate. Do not calculate non-follower reach per format. Export the results into Google Sheets with a raw data tab and a summary comparison with a recommendation on content mix.

Open in

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.

Open in

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.

Open in

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.

Open in

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].

Open in

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

Open in

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.

Open in

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.

Open in

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

Open in

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.

Open in

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.

Open in

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.

Open in

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].

Open in

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.

Open in

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.

Open in

Using the EmbedSocial MCP, pull TikTok campaign posts from my TikTok mentions and added videos where the caption contains [campaign keyword]. Analyze sentiment as positive, negative, or neutral, identify recurring reactions, highlight the top 10 posts by engagement, and export the results into Google Sheets.

Open in

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.

Open in

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.

Open in

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

Open in

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

Open in

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.

Open in

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

Open in

Using the EmbedSocial MCP, pull YouTube videos from [widget] tracking #[brand one] and #[brand two]. Calculate video volume, total views, total engagement, and main recurring themes for each hashtag. Export the results into Google Sheets with a raw data tab and a summary comparison.

Open in

Using the EmbedSocial MCP, pull X posts from [widget] tracking hashtags, mentions, and keywords for [brand one] and [brand two]. Calculate share of voice, sentiment breakdown, and main conversation themes for each brand across all tracked terms. Export the results into Google Sheets with a raw data tab and a summary comparison.

Open in

Using the InvisibleAPI MCP, get the follower demographics and the engaged audience demographics for [account name] for this month: age, gender, top cities and top countries. Summarize who follows us versus who actually engages, and tell me if anything should change in what we post.

Open in