Code Automate

Code Automate streamlines the monitoring of G2 reviews by automatically fetching new reviews daily, notifying you via Slack, and recording them in Google Sheets. This workflow ensures you never miss important feedback from competitors like Zendesk and Intercom, enhancing your competitive analysis and response strategy.

7/8/2025
13 nodes
Complex
schedulecomplexsticky noteschedule triggeritemlistsmarkdowngooglesheetsslackautomationadvancedcronapiintegrationcommunicationnotification
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Sticky NoteSchedule TriggerItemListsMarkdownGoogleSheetsSlack

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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.

    • Customization Guide

    Users can customize the workflow by:
    - Modifying Competitors: Update the competitor list in the 'Add your competitors here' node to track different products.
    - Adjusting Schedule: Change the trigger time in the 'Execute workflow every day' node to fit your needs.
    - API Key: Replace 'YOUR_API_KEY' in the 'Get G2 data with ScrapingBee' node with your actual ScrapingBee API key.
    - Slack Channel: Change the channel ID in the 'Send new review to Slack' node to direct notifications to a different Slack channel.
    - Google Sheets Document: Update the document ID and sheet name in the 'Get all past reviews' and 'Add new review to Google Sheets' nodes to connect to your own Google Sheets.