Google Sheets automations
Browse Google Sheets automations you can run from a prompt. Connect EmbedSocial to Claude or ChatGPT and run any of these automations on your live data.
Automate Instagram product mention tracking in Google Sheets
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.
Find YouTube creators by keyword and add them to Google Sheets
Using the EmbedSocial MCP, pull YouTube media from my keyword-tracking source for [keywords]. Extract each creator's channel name, video title, URL and view count, then write them as rows to a "YouTube creators" tab in my Google Sheet.
Track X (Twitter) keyword mentions and log them to Google Sheets
Using the EmbedSocial MCP, pull X posts matching [keywords] for the last 30 days and log author, post text, URL and engagement to an "X mentions" tab in my Google Sheet.
Threads MCP alternative: get posts by keyword into Google Sheets
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.
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.
Log widget engagement metrics to Google Sheets
Using the EmbedSocial MCP, pull widget analytics for the last 30 days and append a dated row per widget (post clicks, icon clicks, lightbox opens, CTA clicks) to my "Widget metrics" Google Sheet.
Export Threads sentiment analysis into Google Sheets
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.
Turn Threads audience topics into a content calendar
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.
Rank Threads brand advocates in Google Sheets
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.
Export Instagram product feedback into Google Sheets
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.
Rank Instagram brand advocates in Google Sheets
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.
Export TikTok campaign sentiment 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.
Analyze TikTok hashtag mentions by market in Google Sheets
Using the EmbedSocial MCP, pull TikTok hashtag mentions from [source] for [hashtag]. 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.
How to set up
- 1
Connect your social media sources in EmbedSocial
Add the social media accounts, hashtags, and sources you want to work with.
- 2
Set up the EmbedSocial MCP in Claude or ChatGPT
Paste the EmbedSocial MCP URL (https://embedsocial.com/admin/mcp) into Claude, ChatGPT, or any MCP tool, then sign in with your EmbedSocial account to authorize access.
- 3
Run a prompt
Copy any prompt below into your AI tool and let the agent run it on your live EmbedSocial data.
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.