HumationHuman + Automation
Back to Catalog

AI competitor review analyzer with Dumpling AI + GPT-4o + Google Sheets

YangYang
742 views
2/3/2026
Data MigrationGoogle DriveHubSpotWebflowCRM
Official Page

Who is this for?

This workflow is perfect for marketers, SEO specialists, product teams, and competitive analysts who want to monitor and summarize public reviews of their competitors. It’s especially helpful for small teams who want fast insights from Google reviews without spending hours manually reading and sorting them.

What problem is this workflow solving?

Manually going through competitor reviews is time-consuming and repetitive. You risk missing patterns or insights, and it’s hard to share summaries with your team quickly. This workflow automatically scrapes reviews from Google and generates a structured summary of pain points and positive feedback. That way, you can focus on strategy instead of sorting through dozens of reviews.

What this workflow does

This automation watches for new competitor entries in a Google Sheet, then:

  1. Uses Dumpling AI to scrape the latest Google reviews (up to 20) for each business.
  2. Splits and cleans the reviews for analysis.
  3. Sends them to GPT-4o, which summarizes the most common complaints and praises.
  4. Saves the structured result back to the same Google Sheet.

You’ll instantly get an overview of what people are saying about any competitor.

Setup

  1. Google Sheet Setup

    • Create a Google Sheet with at least one column: Business
    • Add names or search queries for the competitors you want to analyze
    • Optional: Add columns for Summary of Reviews and Pain Points

  2. Connect Dumpling AI

    • Sign up at Dumpling AI
    • Create an agent using the get-google-reviews endpoint
    • Copy your agent key
    • Use it in the HTTP Request node in this workflow

  3. OpenAI Setup

    • Use your API key with GPT-4o access
    • The prompt is already structured to generate grouped summaries from reviews

  4. Run the Workflow

    • Trigger it manually or schedule it
    • Make sure your Google Sheets, OpenAI, and Dumpling AI connections are active

How to customize this workflow to your needs

  • You can expand the number of reviews retrieved by changing the Dumpling AI agent config
  • Replace Google Sheets with Airtable if you want more robust data views
  • Add more fields like star ratings or review dates in your agent for richer analysis
  • Change the GPT prompt to highlight emotional tone, urgency, or feature mentions

🧠 Node Details

  • Google Sheets Trigger: Watches for new competitor names
  • HTTP Request (Dumpling AI): Scrapes 20 recent reviews from Google
  • SplitOut Node: Breaks review array into individual items
  • Code Node: Extracts and combines review text
  • Edit Fields Node: Structures the review content before GPT
  • GPT-4o Node: Analyzes and summarizes top pain points and praise
  • Google Sheets Output: Saves the summary back to the same sheet

Dependencies

  • Dumpling AI account and review scraping agent setup
  • OpenAI API key with GPT-4o access
  • Google Sheets OAuth2 credentials

AI Competitor Review Analyzer with Dumpling AI (GPT-4o) and Google Sheets

This n8n workflow automates the process of analyzing competitor reviews stored in a Google Sheet using OpenAI's GPT-4o model via Dumpling AI, and then updates the Google Sheet with the analysis results. It streamlines the task of gaining insights from competitor feedback, helping businesses quickly understand sentiment and key themes.

What it does

This workflow performs the following steps:

  1. Triggers on Google Sheet Updates: It listens for new or updated rows in a specified Google Sheet.
  2. Analyzes Reviews with OpenAI (Dumpling AI): For each new/updated row, it sends the competitor review text to OpenAI (via Dumpling AI) to perform an analysis using the GPT-4o model.
  3. Updates Google Sheet: It takes the analysis results from OpenAI and writes them back to the original Google Sheet, enriching the data with AI-generated insights.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Google Sheets Account: A Google Sheets spreadsheet containing competitor reviews.
  • Google Sheets Credential: An n8n credential configured for Google Sheets to allow read/write access.
  • OpenAI API Key: An API key for OpenAI, configured as an n8n credential. This workflow uses a custom HTTP Request node, implying it might be interacting with the OpenAI API directly or through a proxy/wrapper like "Dumpling AI" as hinted by the directory name.
  • Dumpling AI (Optional but implied): While the JSON directly uses the OpenAI node, the directory name suggests an integration with "Dumpling AI". If "Dumpling AI" is a custom API or wrapper around OpenAI, ensure you have access and configuration details for it. The current workflow uses the standard n8n-nodes-langchain.openAi node.

Setup/Usage

  1. Import the workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Google Sheets Trigger:
    • Select your Google Sheets credential.
    • Specify the Spreadsheet ID and Sheet Name where your competitor reviews are located.
    • Configure the trigger to listen for "New Row" or "Updated Row" events, depending on your use case.
  3. Configure OpenAI Node:
    • Select your OpenAI credential.
    • Ensure the model is set to gpt-4o (or your preferred model).
    • Adjust the prompt to guide the AI on how to analyze the competitor reviews (e.g., "Analyze the sentiment and extract key themes from the following competitor review: {{ $json.reviewText }}").
  4. Configure Google Sheets (Update) Node:
    • Select the same Google Sheets credential.
    • Specify the same Spreadsheet ID and Sheet Name.
    • Map the output from the OpenAI node to the desired columns in your Google Sheet (e.g., Sentiment, Key Themes). You will likely need to specify the column to match on (e.g., Row Index or a unique ID column) to update the correct row.
  5. Activate the workflow: Once configured, activate the workflow to start monitoring your Google Sheet for new competitor reviews and automatically analyze them.

Related Templates

Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct

Synchronize WooCommerce Inventory & Create Products with Gemini AI & BrowserAct This sophisticated n8n template automates WooCommerce inventory management by scraping supplier data, updating existing products, and intelligently creating new ones with AI-formatted descriptions. This workflow is essential for e-commerce operators, dropshippers, and inventory managers who need to ensure their product pricing and stock levels are synchronized with multiple third-party suppliers, minimizing overselling and maximizing profit. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. --- How it works The workflow is typically run by a Schedule Trigger (though a Manual Trigger is also shown) to check stock automatically. It reads a list of suppliers and their inventory page URLs from a central Google Sheet. The workflow loops through each supplier: A BrowserAct node scrapes the current stock and price data from the supplier's inventory page. A Code node parses this bulk data into individual product items. It then loops through each individual product found. The workflow checks WooCommerce to see if the product already exists based on its name. If the product exists: It proceeds to update the existing product's price and stock quantity. If the product DOES NOT exist: An If node checks if the missing product's category matches a predefined type (optional filtering). If it passes the filter, a second BrowserAct workflow scrapes detailed product attributes from a dedicated product page (e.g., DigiKey). An AI Agent (Gemini) transforms these attributes into a specific, styled HTML table for the product description. Finally, the product is created in WooCommerce with all scraped details and the AI-generated description. Error Handling: Multiple Slack nodes are configured to alert your team immediately if any scraping task fails or if the product update/creation process encounters an issue. Note: This workflow does not support image uploads for new products. To enable this functionality, you must modify both the n8n and BrowserAct workflows. --- Requirements BrowserAct API account for web scraping BrowserAct n8n Community Node -> (n8n Nodes BrowserAct) BrowserAct templates named “WooCommerce Inventory & Stock Synchronization” and “WooCommerce Product Data Reconciliation” Google Sheets credentials for the supplier list WooCommerce credentials for product management Google Gemini account for the AI Agent Slack credentials for error alerts --- Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node --- Workflow Guidance and Showcase STOP Overselling! Auto-Sync WooCommerce Inventory from ANY Supplier

Madame AI Team | KaiBy Madame AI Team | Kai
600

Automated YouTube video uploads with 12h interval scheduling in JST

This workflow automates a batch upload of multiple videos to YouTube, spacing each upload 12 hours apart in Japan Standard Time (UTC+9) and automatically adding them to a playlist. ⚙️ Workflow Logic Manual Trigger — Starts the workflow manually. List Video Files — Uses a shell command to find all .mp4 files under the specified directory (/opt/downloads/单词卡/A1-A2). Sort and Generate Items — Sorts videos by day number (dayXX) extracted from filenames and assigns a sequential order value. Calculate Publish Schedule (+12h Interval) — Computes the next rounded JST hour plus a configurable buffer (default 30 min). Staggers each video’s scheduled time by order × 12 hours. Converts JST back to UTC for YouTube’s publishAt field. Split in Batches (1 per video) — Iterates over each video item. Read Video File — Loads the corresponding video from disk. Upload to YouTube (Scheduled) — Uploads the video privately with the computed publishAtUtc. Add to Playlist — Adds the newly uploaded video to the target playlist. 🕒 Highlights Timezone-safe: Pure UTC ↔ JST conversion avoids double-offset errors. Sequential scheduling: Ensures each upload is 12 hours apart to prevent clustering. Customizable: Change SPANHOURS, BUFFERMIN, or directory paths easily. Retry-ready: Each upload and playlist step has retry logic to handle transient errors. 💡 Typical Use Cases Multi-part educational video series (e.g., A1–A2 English learning). Regular content release cadence without manual scheduling. Automated YouTube publishing pipelines for pre-produced content. --- Author: Zane Category: Automation / YouTube / Scheduler Timezone: JST (UTC+09:00)

ZaneBy Zane
226

Tax deadline management & compliance alerts with GPT-4, Google Sheets & Slack

AI-Driven Tax Compliance & Deadline Management System Description Automate tax deadline monitoring with AI-powered insights. This workflow checks your tax calendar daily at 8 AM, uses GPT-4 to analyze upcoming deadlines across multiple jurisdictions, detects overdue and critical items, and sends intelligent alerts via email and Slack only when immediate action is required. Perfect for finance teams and accounting firms who need proactive compliance management without manual tracking. 🏛️🤖📊 Good to Know AI-Powered: GPT-4 provides risk assessment and strategic recommendations Multi-Jurisdiction: Handles Federal, State, and Local tax requirements automatically Smart Alerts: Only notifies executives when deadlines are overdue or critical (≤3 days) Priority Classification: Categorizes deadlines as Overdue, Critical, High, or Medium priority Dual Notifications: Critical alerts to leadership + daily summaries to team channel Complete Audit Trail: Logs all checks and deadlines to Google Sheets for compliance records How It Works Daily Trigger - Runs at 8:00 AM every morning Fetch Data - Pulls tax calendar and company configuration from Google Sheets Analyze Deadlines - Calculates days remaining, filters by jurisdiction/entity type, categorizes by priority AI Analysis - GPT-4 provides strategic insights and risk assessment on upcoming deadlines Smart Routing - Only sends alerts if overdue or critical deadlines exist Critical Alerts - HTML email to executives + Slack alert for urgent items Team Updates - Slack summary to finance channel with all upcoming deadlines Logging - Records compliance check results to Google Sheets for audit trail Requirements Google Sheets Structure Sheet 1: TaxCalendar DeadlineID | DeadlineName | DeadlineDate | Jurisdiction | Category | AssignedTo | IsActive FED-Q1 | Form 1120 Q1 | 2025-04-15 | Federal | Income | John Doe | TRUE Sheet 2: CompanyConfig (single row) Jurisdictions | EntityType | FiscalYearEnd Federal, California | Corporation | 12-31 Sheet 3: ComplianceLog (auto-populated) Date | AlertLevel | TotalUpcoming | CriticalCount | OverdueCount 2025-01-15 | HIGH | 12 | 3 | 1 Credentials Needed Google Sheets - Service Account OAuth2 OpenAI - API Key (GPT-4 access required) SMTP - Email account for sending alerts Slack - Bot Token with chat:write permission Setup Steps Import workflow JSON into n8n Add all 4 credentials Replace these placeholders: YOURTAXCALENDAR_ID - Tax calendar sheet ID YOURCONFIGID - Company config sheet ID YOURLOGID - Compliance log sheet ID C12345678 - Slack channel ID tax@company.com - Sender email cfo@company.com - Recipient email Share all sheets with Google service account email Invite Slack bot to channels Test workflow manually Activate the trigger Customizing This Workflow Change Alert Thresholds: Edit "Analyze Deadlines" node: Critical: Change <= 3 to <= 5 for 5-day warning High: Change <= 7 to <= 14 for 2-week notice Medium: Change <= 30 to <= 60 for 2-month lookout Adjust Schedule: Edit "Daily Tax Check" trigger: Change hour/minute for different run time Add multiple trigger times for tax season (8 AM, 2 PM, 6 PM) Add More Recipients: Edit "Send Email" node: To: cfo@company.com, director@company.com CC: accounting@company.com BCC: archive@company.com Customize Email Design: Edit "Format Email" node to change colors, add logo, or modify layout Add SMS Alerts: Insert Twilio node after "Is Critical" for emergency notifications Integrate Task Management: Add HTTP Request node to create tasks in Asana/Jira for critical deadlines Troubleshooting | Issue | Solution | |-------|----------| | No deadlines found | Check date format (YYYY-MM-DD) and IsActive = TRUE | | AI analysis failed | Verify OpenAI API key and account credits | | Email not sending | Test SMTP credentials and check if critical condition met | | Slack not posting | Invite bot to channel and verify channel ID format | | Permission denied | Share Google Sheets with service account email | 📞 Professional Services Need help with implementation or customization? Our team offers: 🎯 Custom workflow development 🏢 Enterprise deployment support 🎓 Team training sessions 🔧 Ongoing maintenance 📊 Custom reporting & dashboards 🔗 Additional API integrations Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
93