How to Automate Aggregating Feedback by Product Area with n8n

## Introduction

Product teams in startups and growing companies frequently face the challenge of collecting, aggregating, and analyzing customer feedback to inform their roadmap. Feedback often arrives via multiple channels like email, Slack, forms, or CRM systems and can get siloed or overwhelming. Manually compiling this feedback by product area slows down decision-making and risks missing critical insights.

In this guide, we’ll build an automation workflow using n8n, an open-source workflow automation tool, to automatically aggregate customer feedback by product area. This workflow benefits product managers, customer success teams, and product operations professionals by saving time, reducing manual errors, and enabling faster, data-driven prioritization.

—

## Use Case Overview

**Problem:** Feedback is scattered across channels (such as Gmail and Slack) and not categorized, resulting in inefficiencies and difficulties prioritizing enhancements per product area.

**Solution:** An n8n workflow that captures new feedback inputs from Gmail and Slack, classifies feedback by product area using keyword mapping, appends the categorized feedback to Google Sheets for easy analysis, and notifies the team in Slack.

**Stakeholders:** Product managers, support teams, customer success, and product operations.

—

## Tools and Services Integrated

– **n8n**: The automation platform orchestrating the workflow.
– **Gmail**: Source of customer feedback emails.
– **Slack**: Another feedback source and notification endpoint.
– **Google Sheets**: Centralized data repository for aggregated feedback.

—

## Technical Tutorial

### Prerequisites

1. Set up an n8n instance (cloud or self-hosted).
2. Access to Gmail with API credentials.
3. Slack workspace with token for bot and access to channels.
4. Google Sheets API credentials and a spreadsheet prepared for feedback.

### Step 1: Trigger – Watch for Incoming Feedback

– **Nodes:** Gmail Trigger, Slack Trigger

a) **Gmail Trigger**: Set it to poll your inbox (e.g., a dedicated feedback label) for new emails. Configure polling frequency (e.g., every 5 minutes).

b) **Slack Trigger**: Monitor a dedicated Slack channel where customers or internal teams drop feedback messages.

Tips:
– Apply filters to ignore irrelevant emails.
– Use Slack message filters to avoid bot messages or commands.

### Step 2: Extract Relevant Feedback Content

– **Node:** Function or HTML Extract Node (from Gmail emails)

For Gmail emails:
– Extract the email subject and body text.
– Strip HTML tags if necessary to get clean text.

For Slack messages:
– Extract message text.

Tip:
– Normalize text by trimming whitespace and converting to lowercase for classification.

### Step 3: Classify Feedback by Product Area

– **Node:** Function Node or Code Node

Implement a keyword-based classification to tag feedback by relevant product areas.

Example logic:
“`javascript
const feedbackText = items[0].json.text.toLowerCase();
const productAreas = {
‘ui’: [‘ui’, ‘interface’, ‘user experience’, ‘ux’, ‘design’],
‘performance’: [‘speed’, ‘slow’, ‘performance’, ‘lag’, ‘delay’],
‘backend’: [‘api’, ‘server’, ‘backend’, ‘database’, ‘error’],
‘billing’: [‘billing’, ‘payment’, ‘invoice’, ‘refund’, ‘charge’]
};

let areaTags = [];
for (const [area, keywords] of Object.entries(productAreas)) {
for (const kw of keywords) {
if (feedbackText.includes(kw)) {
areaTags.push(area);
break;
}
}
}

if (areaTags.length === 0) {
areaTags.push(‘uncategorized’);
}

items[0].json.productAreas = areaTags;
return items;
“`

Tips:
– Expand and refine keyword lists continuously based on evolving feedback.
– For more advanced classification, consider integrating NLP services.

### Step 4: Append Feedback to Google Sheets

– **Node:** Google Sheets — Append Row

Structure your Google Sheet with columns for:
– Timestamp
– Source (Email or Slack)
– Feedback Text
– Product Area(s)

In the Append Row node, map these fields from the previous steps.

Tips:
– Batch append if processing multiple feedbacks at once.
– Include a unique ID or timestamp to avoid duplicates.

### Step 5: Notify Team on Slack

– **Node:** Slack — Post Message

Send a notification to a product team Slack channel containing:
– Summary of new feedback
– Product area tags
– Link to the Google Sheet for deeper review

Tips:
– Format messages with Slack blocks for better readability.

—

## Workflow Summary

—

## Common Errors & Troubleshooting Tips

– **API Authorization Failures:** Ensure all API credentials and tokens are current with proper scopes.

– **Data Format Issues:** Confirm email or Slack messages are parsed correctly; malformed HTML can cause extraction issues.

– **Google Sheets Rate Limits:** Keep the append frequency moderate or batch updates.

– **Misclassification:** Expand keywords or implement machine learning for more precise classification.

– **Duplicate Entries:** Implement checks (e.g., message IDs or hashes) to prevent repeated appends.

—

## Scaling and Adaptation Ideas

– **Multi-language Feedback:** Integrate translation APIs before classification.

– **Advanced Classification:** Use a dedicated NLP service or build a custom model with services like Azure Text Analytics, Google Cloud Natural Language, or Hugging Face.

– **Additional Sources:** Extend triggers to CRM systems (e.g., HubSpot feedback tickets), surveys (Typeform), or social media.

– **Dashboards:** Connect Google Sheets with BI tools (Looker Studio, Power BI) for visual summaries.

– **Automated Prioritization:** Add scoring rules based on sentiment analysis or feedback frequency.

—

## Summary & Bonus Tip

Using n8n to automate aggregating feedback by product area streamlines data consolidation, helping product teams prioritize improvements more efficiently. The modularity of n8n and accessible APIs of Gmail, Slack, and Google Sheets make this a highly adaptable and scalable solution.

**Bonus Tip:** Implement periodic workflows that summarize feedback trends weekly or monthly and automatically email or Slack these reports to stakeholders, keeping everyone aligned without manual effort.

—

By following this guide, technical teams can build robust, maintainable automation that transforms raw feedback into actionable insights — a crucial capability for data-driven product development.

Restflow.io

How to Automate Aggregating Feedback by Product Area with n8n

Restflow.io