Compare Instagram competitor hashtags in Google Sheets
Use EmbedSocial's Instagram competitor hashtag agent to compare how two brands are performing on Instagram, side by side, hashtag by hashtag.
One connection. Runs on your live EmbedSocial data.
What does it do?
Connect EmbedSocial with Claude or ChatGPT and Google Sheets to create an agent that pulls Instagram posts tracked under competing brand hashtags and turns them into a comparison report. The agent calculates share of voice, tracks daily post volume, breaks down sentiment by brand, groups posts into conversation themes, and surfaces the related hashtags travelling alongside each brand, then exports everything into a spreadsheet.
Useful for
- Comparing Instagram share of voice: see which brand is generating more hashtag volume, and by how much.
- Tracking daily volume trends: see post volume for each hashtag day by day, not just as a total.
- Benchmarking sentiment by brand: compare positive, negative, neutral, and sarcastic caption sentiment side by side.
- Spotting related-hashtag patterns: find which hashtags and keywords travel with each brand's mentions.
How to compare Instagram competitor hashtags in Google Sheets
- Create your EmbedSocial account. Sign up for a free EmbedSocial trial to connect your Instagram sources and turn on the MCP.
- Add your Instagram sources. Add the two competing brand hashtags you want to track (e.g. #brandone and #brandtwo) as Instagram sources in EmbedSocial.
- Keep your two hashtag sources separate. In EmbedSocial, keep the two brand hashtag sources in separate source groups so the agent can compare them cleanly.
- Set up the EmbedSocial MCP in Claude or ChatGPT. Paste the MCP URL into your AI tool and authorize access with your EmbedSocial account.
- Connect Google Sheets in your AI tool. Make sure your AI environment can create or update a spreadsheet.
- Run the prompt. Ask your AI tool to compare the two hashtags and export the results into Google Sheets.
Note: Depending on the connectors you are using, you may be prompted to authenticate your platform connections by logging into your accounts.
Real-world use case
Imagine you're evaluating a competitive social listening use case for a client and want to compare two competing brands on Instagram. Instead of manually counting posts and reading captions one by one, you ask Claude or ChatGPT:
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.
Your AI tool reviews the tracked posts, calculates the comparison metrics, and creates a spreadsheet with raw data, a summary dashboard, and related hashtags, ready to share internally or with a client.
See how an agency runs this alongside other prompts: How agencies use Claude and ChatGPT for Instagram.
Prefer to build this into your own app instead of running it from a prompt? The same posts, mentions, reviews and widget analytics are available through the social media API.
More Analytics automations
Send LinkedIn Mentions to Slack
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.
Track LinkedIn Mentions in Google Sheets
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.
Analyze LinkedIn Post Performance in Google Sheets
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.
More Instagram automations
Competitor tracking resources
Explore social listening use cases, automations, and guides for competitor analysis.
Other social listening use cases
Browse social listening workflows for specific business goals.
Competitor analysis automations
Compare competitor activity across social channels and reporting tools.
Competitor analysis guides
Learn practical approaches to competitor analysis and social media benchmarking.
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.