Compare Instagram competitor hashtags in Google Sheets

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

1. 1

   Create your EmbedSocial account

   Sign up for a free EmbedSocial trial to connect your Instagram sources and turn on the MCP.

   Start free trial
2. 2

   Add your Instagram sources

   Add the two competing brand hashtags you want to track (e.g. #brandone and #brandtwo) as Instagram sources in EmbedSocial.

3. 3

   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.

4. 4

   Set up the EmbedSocial MCP in Claude or ChatGPT

   Paste the MCP URL into your AI tool and authorize access with your EmbedSocial account.

5. 5

   Connect Google Sheets in your AI tool

   Make sure your AI environment can create or update a spreadsheet.

6. 6

   Run the prompt

   Ask your AI tool to compare the two hashtags and export the results into Google Sheets.

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:

The prompt

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.

Copy

Open in

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.