Google Sheets automations

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

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