Analyze Event Feedback with Sentiment Analysis, Google Sheets, Slack & Email

This n8n workflow automates the process of collecting event feedback, performing sentiment analysis, recording the feedback in Google Sheets, notifying a Slack channel, and sending an email summary for negative feedback.

What it does

1. Receives Feedback: Listens for incoming event feedback data via a webhook.
2. Analyzes Sentiment: (Implicit from directory name, but not explicitly in JSON - Note: The JSON provided does not include a sentiment analysis node. This step is inferred from the directory name "analyze-event-feedback-with-sentiment-analysis". If sentiment analysis is desired, an additional node (e.g., OpenAI, Google Cloud Natural Language) would need to be added here.)
3. Records in Google Sheets: Appends the received feedback data to a specified Google Sheet.
4. Notifies Slack: Posts a message to a Slack channel with the feedback details.
5. Checks for Negative Feedback: (Implicit from directory name, but not explicitly in JSON - Note: An 'If' node is present, suggesting conditional logic, likely for sentiment. Without a sentiment analysis node, its current condition is unknown.)
6. Sends Email for Negative Feedback: If the feedback is identified as negative, an email is sent to a designated recipient.
7. Responds to Webhook: Sends a response back to the original webhook caller.
8. Aggregates Data: Combines data from previous steps, likely for the final webhook response.
9. Edits Fields (Set): Modifies or sets specific fields in the data, potentially for formatting or preparing data for subsequent nodes.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: With access to a spreadsheet where feedback will be recorded.
• Slack Account: With a channel to post notifications.
• SMTP Server / Email Service: Configured for sending emails.
• Webhook Source: An application or service that can send HTTP POST requests to the n8n webhook URL.
• (Optional) Sentiment Analysis Service: If sentiment analysis is to be performed (e.g., OpenAI, Google Cloud Natural Language API credentials).

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the JSON.
2. Configure Credentials:
   • Google Sheets Node: Configure your Google Sheets credentials to allow n8n to write to your spreadsheet. Specify the Spreadsheet ID and Sheet Name.
   • Slack Node: Configure your Slack credentials and specify the Channel ID where notifications should be posted.
   • Send Email Node: Configure your SMTP or email service credentials (e.g., Gmail, custom SMTP). Specify the recipient email address(es).
3. Configure Webhook Trigger:
   • The Webhook node is the starting point. Set its "Webhook URL" to "POST" and "Response Mode" to "Last Node".
   • After saving the workflow, activate it. n8n will provide a unique URL for this webhook. This is the URL you will use to send feedback data to.
4. Configure If Node:
   • The If node (id: 20) currently has an unknown condition based on the provided JSON. If you intend to use it for sentiment analysis, you would need to:
     • Add a sentiment analysis node before the If node.
     • Configure the If node to check the sentiment score or label (e.g., {{ $json.sentiment === 'negative' }}).
5. Configure Edit Fields (Set) Node:
   • Review and configure the Edit Fields (Set) node (id: 38) to ensure it's manipulating the data as expected for your use case.
6. Test the Workflow:
   • Send a test POST request to the webhook URL with sample feedback data.
   • Verify that data is recorded in Google Sheets, a Slack notification is sent, and an email is sent if the feedback meets the negative criteria (once configured).