Restflow.io

## Introduction

Gathering user feedback from community forums is an essential practice for product teams aiming to improve features, fix bugs, and enhance user satisfaction. However, manually collecting and organizing this feedback can be time-consuming and error-prone. Automating the process saves time, ensures no valuable insights are lost, and creates a centralized repository for actionable feedback.

In this article, we’ll walk through a step-by-step tutorial to automate logging user feedback from community forums using n8n, an open-source workflow automation tool. This tutorial is designed for product managers, automation engineers, and startup teams looking to streamline feedback collection from platforms like Discourse, Reddit, or other API-accessible forums.

—

## Use Case & Benefits

**Problem:** Product teams spend hours manually reviewing forum posts and extracting relevant user feedback.

**Solution:** Automatically fetch new forum posts or comments containing user feedback and log them into a centralized system, such as Google Sheets, Airtable, or a ticketing tool like Jira.

**Who benefits:**
– Product managers gain on-demand access to categorized feedback.
– Customer support teams identify common issues without manual searches.
– Engineering teams prioritize improvements based on real-time insights.

—

## Tools and Services Integrated

– **n8n:** Automation platform to create the workflow.
– **Community forum API:** e.g., Discourse API, Reddit API.
– **Google Sheets/Airtable/Jira:** Destination for logging feedback.
– **Slack (optional):** To notify the product team when new feedback is logged.

—

## Setting Up the Automation Workflow in n8n

### Prerequisites

– Access to n8n instance (either self-hosted or via n8n.cloud).
– API credentials for the forum platform (e.g., API key for Discourse or Reddit). Ensure permission to read posts/comments.
– Destination account credentials (Google Sheets, Airtable, or Jira).

### Workflow Overview

1. **Trigger:** Schedule node or Webhook trigger to check for new forum posts or comments periodically.
2. **Fetch Data:** HTTP Request node calling the forum API to fetch recent posts or comments.
3. **Filter:** Function node or IF node to filter relevant feedback (e.g., posts containing keywords like “bug”, “feature request”, “feedback”).
4. **Transform:** Prepare the data structure for the destination (e.g., parse user, timestamp, content).
5. **Log:** Insert records into Google Sheets/Airtable or create issues in Jira.
6. **Notify (optional):** Send Slack message to product channel with summary.

### Step-by-Step Detailed Tutorial

#### Step 1: Create a Scheduled Trigger

– In n8n, add a **Cron** node.
– Configure it to run every hour/day depending on feedback volume.

#### Step 2: Fetch Latest Posts via HTTP Request

– Add an **HTTP Request** node.
– Set the method to GET.
– Enter the forum API endpoint that returns recent posts or comments. For example, Discourse recent posts API:
`https://discourse.example.com/latest.json`

– Add authentication headers as necessary (e.g., API key in headers).
– Configure query parameters to filter by date to only retrieve recent data.

#### Step 3: Filter Relevant Feedback

– Add a **Function** node to iterate over the fetched posts and filter those containing feedback.

Example JavaScript code in the Function node:
“`javascript
return items.filter(item => {
const content = item.json.raw.toLowerCase();
return content.includes(‘bug’) || content.includes(‘feature’) || content.includes(‘feedback’);
});
“`

– This step filters only posts containing target keywords, reducing noise.

#### Step 4: Transform Data

– Add another **Function** node (or within the previous if preferred) to map each post to the required schema for Google Sheets/Airtable/Jira.

Example:
“`javascript
return items.map(item => {
return {
json: {
username: item.json.username,
date: item.json.created_at,
content: item.json.raw,
url: `https://discourse.example.com/t/${item.json.topic_id}/${item.json.post_number}`
}
}
});
“`

#### Step 5: Log Feedback to Destination

– For **Google Sheets:**
– Use the **Google Sheets node**.
– Select ‘Append’ operation to add rows.
– Map the transformed fields to columns (e.g., Username, Date, Feedback, URL).

– For **Airtable:**
– Use the **Airtable node** with ‘Create Record’ operation.
– Map fields accordingly.

– For **Jira:**
– Use the **Jira node** to create new issues, possibly of type ‘Bug’ or ‘Improvement’.
– Fill relevant fields: Summary, Description, Reporter, Labels.

#### Step 6: Notify Product Team via Slack (Optional)

– Add **Slack node** configured to send messages.
– Generate a summary message listing new feedback logged.

Example message:
“`
New user feedback has been added:
– Bug report by {username} on {date}
– Feature request: {summary}
See details in {url}
“`

—

## Handling Common Pitfalls and Tips

– **API Rate Limits:** Implement error handling and exponential backoff in case of API throttling.
– **Duplicate Logging:** Store the ID of processed posts in n8n workflow state or external storage to avoid duplicates.
– **Keyword Sensitivity:** Adjust filtering keywords periodically based on forum language and slang.
– **Data Privacy:** Ensure compliance with user privacy policies and do not log sensitive information.
– **Error Notifications:** Configure error triggers in n8n to alert admins if the workflow fails.

—

## Scaling and Adapting the Workflow

– **Add More Forums:** Extend the workflow with additional HTTP Request nodes for multiple forums.
– **Advanced NLP Filtering:** Integrate services like Google Cloud Natural Language or AWS Comprehend to classify feedback sentiment and topic automatically.
– **Automated Ticketing:** Automatically assign Jira tickets to appropriate teams.
– **Multiple Destinations:** Mirror feedback logs to a data warehouse for analytics.

—

## Summary

Automating the logging of user feedback from community forums with n8n significantly enhances a product team’s efficiency in tracking, prioritizing, and responding to user needs. By setting up a scheduled workflow that fetches posts, filters relevant content, and logs this into a central place like Google Sheets or Jira, teams minimize manual effort and maximize insight clarity.

**Bonus Tip:** Schedule periodic review of your filtering criteria and destination fields to continuously optimize the workflow and incorporate new feedback channels.

—

Adopting this automated approach puts startup teams and product departments in a strong position to build user-centric products driven by real, actionable feedback.