Automated NPS Calculation and Google Sheets Reporting - n8n Workflow

Product Managers & Owners: Needing automated, consistent tracking of customer satisfaction metrics (NPS).
Marketing Analysts: Looking for a reliable, low-code method to gather competitive or brand sentiment data from third-party review platforms.
Data Engineers: Seeking advanced n8n templates that combine AI agents, web scraping, and standard database operations.
Automation Specialists: Interested in utilizing the AI Agent n8n node for sophisticated, dynamic web data extraction.

Maintaining a pulse on customer sentiment is crucial, yet manually monitoring review sites and calculating metrics like Net Promoter Score (NPS) is time-consuming and prone to error. This advanced n8n workflow provides a comprehensive, hands-free solution. This specific n8n template uses a powerful combination of a scheduled n8n trigger, AI Agents (powered by OpenAI), and Bright Data's robust scraping capabilities to reliably extract live customer reviews from sites like Trustpilot. Once the structured data is gathered, a custom n8n node calculates the definitive NPS score (Promoters minus Detractors). Finally, the results are seamlessly logged into a Google Sheet for easy reporting and long-term trend analysis. This automated n8n workflow ensures your team always has the latest satisfaction data at their fingertips.

This powerful n8n workflow operates in three distinct phases:

1. Initiation and Setup: The process begins with the ⏰ Run Weekly NPS Tracker n8n trigger, which activates the entire flow every Monday morning at 9 AM. The subsequent ✏️ Set Survey Page URL n8n node defines the specific review page (e.g., a Trustpilot URL) to be targeted for scraping.


2. AI-Powered Scraping: The core data collection is managed by the 🧠 Scrape Reviews with Agent (MCP) n8n node, an AI Agent. This agent is guided by the 🎯 Prompt & Guide Agent (an OpenAI model) and executes the 🌐 Execute Web Scrape (Bright Data) tool. The tool uses Bright Data's Mobile Carrier Proxy to bypass typical anti-bot measures and scrape dynamic content. The agent is instructed to extract star ratings, comments, and dates. This raw data is then cleaned and structured into a usable JSON format by the Structured Output Parser before moving to the next step of the n8n workflow.


3. NPS Calculation and Reporting: The structured review data feeds into the 📊 Calculate NPS from Ratings custom code n8n node. This node implements the standard NPS calculation logic: mapping 1–5 star ratings to the 0–10 NPS scale and classifying responses into Promoters, Passives, and Detractors to generate the final NPS percentage. The final step of the n8n workflow uses the 📄 Log NPS to Google Sheet n8n node to append the calculated metrics (NPS score, total responses, and breakdowns) into the designated Google Sheet, completing the automated reporting cycle. This entire n8n workflow is designed for efficiency and accuracy.

To deploy this specialized n8n workflow, follow these steps:

1. Import the n8n Template: Copy the provided JSON data and navigate to your n8n instance. Click 'New' and select 'Import from JSON' to load this n8n template.


2. Setup OpenAI Credentials: Locate the 🎯 Prompt & Guide Agent n8n node and the associated language model n8n node. You will need to set up a valid OpenAI API credential. Ensure the API key has access to the chosen model (e.g., gpt-4o-mini).


3. Setup Bright Data (MCP) Credentials: Configure the credentials for the 🌐 Execute Web Scrape (Bright Data) n8n node (MCP Client). This requires an active Bright Data account, which powers the headless scraping capability used by the AI Agent.


4. Setup Google Sheets Credentials: Connect your Google Sheets account to the 📄 Log NPS to Google Sheet n8n node. This typically uses OAuth2 authentication.


5. Configure Target URL: Update the ✏️ Set Survey Page URL n8n node with the specific URL of the customer review site you wish to track.


6. Activate: Once credentials and URLs are set, activate the n8n workflow. The n8n trigger will now execute the flow on its weekly schedule.

⏰ Run Weekly NPS Tracker (Schedule Trigger n8n trigger):
Function: Starts the n8n workflow automatically.
Key Configuration: Configured to run every week, specifically on Mondays at 9 AM.
✏️ Set Survey Page URL (Set n8n node):
Function: Defines the constant URL variable (url) that the scraping agent will use.
Key Configuration: Sets the value to the target review page URL (e.g., https://www.trustpilot.com/review/shopify.com).
🧠 Scrape Reviews with Agent (MCP) (AI Agent n8n node):
Function: Orchestrates the scraping process, combining the OpenAI model with the Bright Data tool to dynamically extract structured data from the specified URL based on a natural language prompt.
Key Configuration: Prompt is set to "Extract Customer reviews, Star ratings (1 to 5 stars), Comments... and Date of review." It utilizes the Bright Data tool (scrapeasmarkdown) for execution.
📊 Calculate NPS from Ratings (Code n8n node):
Function: Executes custom JavaScript logic to perform the NPS calculation based on the 1-5 star ratings scraped by the previous n8n node.
Key Configuration: Contains logic to map ratings (1-6=Detractor, 7-8=Passive, 9-10=Promoter) and calculates the final NPS percentage.
📄 Log NPS to Google Sheet (Google Sheets n8n node):
Function: Appends the final calculated metrics (NPS, Promoters, Detractors, Total Responses) to a dedicated Google Sheet.
* Key Configuration: Operation set to 'append'. Maps output fields like {{ $json.nps }} and {{ $json.totalResponses }} to spreadsheet columns.