Compare X competitor mentions and keywords in Google Sheets

What does it do?

Connect EmbedSocial with Claude or ChatGPT and Google Drive to create an agent that pulls X posts tracked by hashtag, mention, and keyword for two competing brands and compares them side by side. The agent calculates share of voice, sentiment, and recurring themes across all three tracking types, then exports the comparison into a spreadsheet.

Useful for

• Getting a complete competitor view: X allows tracking hashtags, mentions, and keywords for brands you don't own, unlike YouTube;
• Benchmarking sentiment by brand: compare positive, negative, and neutral sentiment side by side;
• Spotting conversation differences: see what themes come up around each brand across all tracked terms.

How to compare X competitor mentions and keywords in Google Sheets

1. Create your EmbedSocial account. Sign up for a free EmbedSocial trial to connect your X tracking and turn on the MCP.
2. Create a widget tracking both brands. Add hashtags, mentions, and keywords for each brand you want to compare.
3. Let the widget collect posts. Give it a few days to pull public X posts matching either brand's tracked terms.
4. Connect Google Drive in your AI tool. Make sure your AI environment can create or update a spreadsheet.
5. Set up the EmbedSocial MCP in Claude or ChatGPT. Paste the MCP URL into your AI tool and authorize access with your EmbedSocial account.
6. Run the prompt. Ask your AI tool to compare the two brands 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.

Your AI tool pulls the tracked posts across all three signal types, calculates the comparison, and creates a spreadsheet ready to share internally or with a client.

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.