Code Automate

This workflow is ideal for:

• Marketing Professionals: Who want to monitor competitor reviews efficiently.
• Product Managers: Seeking insights on user feedback for product improvement.
• Business Analysts: Analyzing customer sentiment towards different products.
• Small Business Owners: Who need to keep track of reviews to enhance their service offerings.

This workflow addresses the challenge of manually tracking competitor reviews on platforms like G2. By automating the process, it ensures:

• Timely notifications about new reviews, allowing for quick responses.
• Structured data collection, making it easier to analyze trends and sentiments over time.
• Integration with Google Sheets for easy access and record-keeping of past reviews.

1. Schedule Trigger: The workflow runs every day at 8 AM, ensuring timely data collection.
2. Competitor List: A predefined list of competitors is used to gather reviews.
3. Data Retrieval: G2 reviews are fetched using ScrapingBee API, ensuring up-to-date information.
4. HTML Extraction: The workflow extracts relevant sections from the HTML response to focus on reviews.
5. Review Iteration: Each review is processed individually to extract structured data such as date, review content, user profile, rating, and review URL.
6. Markdown Conversion: Review HTML is converted to Markdown for better readability and formatting.
7. Comparison with Past Reviews: New reviews are compared against existing ones in Google Sheets to filter out duplicates.
8. Notifications: If a new review is detected, notifications are sent to a designated Slack channel and the review is added to Google Sheets.