Review Insights Miner

This automation acts as a powerful market research assistant. You provide a product name (like 'Salesforce') and a review website (like 'G2' or 'Capterra'), and it gets to work.

1. It starts by using a search engine to find the correct review page for your specified product.
2. Once on the page, it smartly navigates, dismissing any pop-ups and sorting reviews by "Most Recent" to get the latest feedback.
3. It then meticulously extracts key details from each review, such as the review text, star rating, and date. It's designed to scroll and click "load more" to gather as many reviews as you need.
4. If you choose, it uses AI to analyze the sentiment of each review, labeling it as positive, negative, or neutral.
5. Finally, it creates a brand new Google Sheet in your account, neatly organizing all the extracted data and sentiment analysis into columns for you to slice, dice, and share.

Usage Ideas

• Competitive Analysis: Scrape reviews for your top 3 competitors to identify their weaknesses and your opportunities.
• Product Feedback Loop: Set up a recurring schedule to monitor reviews for your own product and pipe new feedback directly to your product team.
• Voice of Customer Research: Gather raw customer language to use in marketing copy, ad campaigns, and on your website.
• Sales Enablement: Create battle cards for your sales team highlighting common competitor pain points mentioned in reviews.

Customization Ideas

This template is a powerful starting point that can be easily customized to fit your exact needs. You can:

• Target Any Website: Change the review source from the default "Software Advice" to any other site like G2, Capterra, or even an e-commerce site like Amazon. The automation's scraping logic can be adapted to fit the new site's layout.
• Customize Your Data: Decide exactly what information to extract. You can modify the automation to grab "Pros" and "Cons," reviewer job titles, company size, or any other data point visible on the page.
• Choose Your Destination: While this template saves results to a new Google Sheet, you can change the final step to append data to an existing sheet, send it to a different service, or even trigger a Slack notification.
• Control the Scope: Specify the maximum number of reviews to collect, or set it to grab every review it can find. You can also toggle the AI-powered sentiment analysis on or off.