Compare YouTube competitor hashtags in Google Sheets

What does it do?

Connect EmbedSocial with Claude or ChatGPT and Google Drive to create an agent that pulls YouTube videos tracked under two competing brand hashtags and compares them side by side. The agent calculates video volume, total views, and engagement, and recurring themes for each hashtag, then exports the comparison into a spreadsheet.

Useful for

• Benchmarking video presence against a competitor: see who's generating more hashtag-tagged video content;
• Comparing engagement, not just volume: views and engagement per video, not just a raw post count;
• Spotting theme differences: see what topics each brand's hashtag is associated with.

How to compare YouTube competitor hashtags in Google Sheets

1. Create your EmbedSocial account. Sign up for a free EmbedSocial trial to connect your YouTube hashtag tracking and turn on the MCP.
2. Create a widget with both brand hashtags. Add the two competing hashtags you want to compare, e.g. #brandone and #brandtwo.
3. Let the widget collect videos. Give it a few days to pull public YouTube videos using either hashtag.
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 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.

Your AI tool pulls the tracked videos, calculates the comparison metrics, 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.