Scrape Public Similarweb Data to Google Sheet

During a recent project, I stumbled upon something interesting that I thought was worth sharing: SimilarWeb has a public API endpoint that powers their Chrome extension, and it can be leveraged for automated traffic analysis.

What I Found

SimilarWeb's Chrome extension accesses a public API that provides traffic data for websites. This interface isn't prominently documented, but it's fully accessible and can be used to automate data collection for multiple websites simultaneously.

My Approach

1. Script Creation: I used Claude AI to help develop a script that could interact with this API endpoint
2. Automation Setup: Implemented the script in Google Apps Script to handle the data collection process
3. Mass Analysis: Successfully analyzed over 3000 e-commerce shops in just minutes

The beauty of this approach is that it relies entirely on publicly available data that SimilarWeb themselves provide through their website and extension. I'm not accessing anything that isn't already available to users of their free tools.

If you're interested in website analytics or need to collect traffic data at scale, this method might save you considerable time compared to manual data collection.

Want to copy the sheet including the Script?

This is a free resource for subscribers to my newsletter – you'll receive this file and updates whenever I publish new content. I don't have the time to spam you – I just want to share my knowledge and build a community of like-minded people. And you can obviously unsubscribe anytime if I happen to not deliver on my promise.

Once you've subscribed the article is unlocked and you can directly access & copy the relevant sheet & script.