Google Sheets automations

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 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 TikTok mention videos from [widget] for the last [90] days. Group the videos by creator and rank each creator by number of mentions, total engagement, average engagement per video, number of active weeks, and average sentiment. Sort them into three tiers: top advocates, rising advocates, and one-time posters. Export the results into Google Sheets with a ranked advocates tab, a top videos tab with links, and a raw data tab.

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

Find Instagram media in my EmbedSocial feeds mentioning [product keyword] from the last 30 days. Add the post URL, creator, date, caption summary, sentiment, and recommended action to a Google Sheet.

Open in

Using the EmbedSocial MCP, pull YouTube media from my #Hashtag source for [#hashtag]. Extract each creator's channel name, video title, URL, and view count, then write them as rows to a new tab called "YouTube creators" in my Google Sheet.

Open in

Using the EmbedSocial MCP, pull X posts matching the keywords [X, Y] for the last 30 days and log author, post text, URL, and engagement to an "X mentions" tab in my Google Sheet.

Open in

Using the EmbedSocial MCP, fetch Threads media matching [keyword] from the last 30 days and log the author, post text, URL and date to a "Threads posts" tab in my Google Sheet.

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, 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 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, pull the highest-engagement Threads posts from [source] for [niche/keyword]. Identify recurring audience topics, questions, complaints, and formats that are working. Turn them into a 4-week content calendar in Google Sheets with post ideas, angles, hooks, and suggested posting dates.

Open in

Using the EmbedSocial MCP, pull Threads mentions from [source] and aggregate them by author. Rank the top brand advocates by post count, average engagement, sentiment, and brand fit. Export the results into Google Sheets with columns for author, profile link, post count, engagement, sentiment, example post, and suggested outreach angle.

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 Instagram mentions from [source] and aggregate posts by author. Rank the top brand advocates by post count, engagement, content quality, sentiment, and brand fit. Export the results into Google Sheets with columns for handle, profile link, post count, engagement, example post, and suggested outreach angle.

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