Automated Customer Review Sentiment Analysis using Google Sheets and Code - n8n Workflow

E-commerce managers needing quick, automated sentiment visibility for new feedback.
Marketing teams monitoring customer satisfaction without manual classification.
Users seeking robust n8n templates for data enrichment within Google Sheets.
Developers looking for practical examples of utilizing the custom Code n8n node for simple NLP tasks.

This essential n8n workflow solves the problem of manually reading and classifying high volumes of customer feedback. By leveraging a Google Sheets n8n trigger, the process starts instantly whenever a new review is logged into your spreadsheet. The core logic resides in a custom Code n8n node, which performs a simple, fast keyword-based sentiment analysis.

This robust n8n automation provides immediate feedback classification (Positive, Negative, Neutral, or Mixed), allowing teams to prioritize support follow-ups or gauge product reception based on automated sentiment trends recorded directly in Google Sheets. It demonstrates the power and flexibility of combining common services with custom logic in an n8n workflow, offering a perfect practical n8n template for data processing.

The entire process is initiated by the primary n8n trigger and executes a three-step data flow:

1. Trigger on New Row: The Google Sheets Trigger n8n trigger constantly polls the designated spreadsheet. When a new row containing a customer review is detected (using the rowAdded event), the n8n workflow begins execution, passing the full row data forward.


2. Analyze Sentiment: The Analyze Sentiment n8n node (a Code node) retrieves the Review Text. It runs a custom JavaScript script that checks the text against predefined lists of positive and negative keywords to assign a sentiment label (Positive, Negative, Neutral, or Mixed).


3. Update Google Sheet: The final Update Google Sheet with Sentiment n8n node takes the calculated sentiment and the corresponding Review ID. It connects back to the original sheet, uses the Review ID as a matching key, and updates the designated 'Sentiment' column in the exact row where the review originated. This completes the fully automated n8n workflow cycle.

1. Import the n8n Workflow: Copy this n8n workflow JSON data and paste it into your n8n instance using the 'Import from JSON' option.


2. Set up Google Sheets Credentials: You will need to create Google Sheets OAuth2 API credentials within n8n. Ensure the account linked has read and write permissions to your target spreadsheet.


3. Prepare the Spreadsheet: Ensure your Google Sheet is set up with columns corresponding to the data inputs and outputs, specifically columns for Review Text and Review ID.


4. Configure the Google Sheets Trigger n8n trigger: Select your Google Sheets credentials, and specify the exact Document ID and Sheet Name where new reviews will appear.


5. Configure the Google Sheets Update n8n node: Select the same Document ID and Sheet Name. Ensure that the 'Matching Columns' parameter is correctly set to Review ID to guarantee the sentiment update occurs on the correct row.


6. Activate: Save and activate the n8n workflow using the toggle switch. Test by manually adding a row to your Google Sheet to confirm the sentiment column updates within a minute.

Google Sheets Trigger n8n trigger: Initiates the n8n workflow upon detecting a new row (rowAdded) in the configured Google Sheet. This crucial n8n node ensures real-time processing of new feedback.
Analyze Sentiment (Code n8n node): This highly flexible n8n node contains the core logic. It uses a custom JavaScript script to perform basic sentiment analysis by counting positive and negative keyword occurrences in the review text and outputting a categorical sentiment (Positive, Negative, Mixed, Neutral).

• Update Google Sheet with Sentiment (Google Sheets n8n node): This n8n node is configured for the Update operation. It uses the Review ID passed from the trigger as the identifier to match the row, and updates the Sentiment column with the result determined by the Code n8n node, enriching the original data set.