Multi-Platform Customer Review Aggregator to Google Sheets - n8n Workflow

E-commerce managers who need a single source of truth for all customer feedback.
Marketing analysts focused on sentiment analysis and reporting.
Users seeking advanced n8n templates for complex API data aggregation.
Businesses relying on timely and centralized reporting without manual data entry.

Managing customer reviews across multiple platforms—like Trustpilot, Google Business, and Facebook—is challenging because the data lives in silos and uses different formats. This powerful n8n workflow solves this problem by providing a daily, automated aggregation solution. It acts as a single centralized processor that fetches raw data from three distinct sources, uses a custom code n8n node to harmonize the disparate structures, and then commits the clean data to a single Google Sheets spreadsheet. This n8n workflow ensures your team always has the freshest, unified review data, allowing for immediate analysis and proactive customer service responses. This n8n template is essential for scaling review management efficiently.

The entire process is initiated by the 'Daily Review Sync,' which functions as the primary n8n trigger, executing the flow on a predefined schedule (likely daily).

1. Preparation (Get Products): The workflow starts by interacting with the Shopify n8n node, which may be configured to retrieve necessary business context, product IDs, or company information needed for the subsequent API calls.


2. Parallel Fetching: The execution branches immediately into three parallel paths, utilizing separate HTTP Request n8n node instances to simultaneously fetch reviews from: 'Fetch Trustpilot Reviews,' 'Fetch Google Reviews,' and 'Fetch Facebook Reviews.' This parallel execution maximizes efficiency.


3. Normalization: The output from all three HTTP Request nodes is merged into the critical 'Normalize Review Data' n8n node (a Code node). This node contains custom JavaScript logic required to parse the unique JSON structures from each platform and transform them into a unified, consistent format suitable for spreadsheet entry.


4. Conditional Check: The 'Check if Reviews Found' n8n node (an If node) verifies that the normalization step yielded actual data. This prevents unnecessary writes to Google Sheets if no new reviews were found during the sync.


5. Final Storage: If new reviews are present, the data proceeds to the 'Store Reviews Database' Google Sheets n8n node, which appends the normalized review entries to a designated spreadsheet, completing the execution of this comprehensive n8n workflow.

To deploy this centralized review aggregator n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and import it directly into your n8n instance via the 'New' menu and 'Import from JSON' option.


2. Set up Credentials: You will need to configure credentials for the following services:

1. Customize API Calls: Open the three 'Fetch' HTTP Request n8n node instances and configure the specific URLs, headers, and query parameters necessary to fetch your company's reviews from each platform.


2. Verify Code Node Logic: Review the 'Normalize Review Data' n8n node. Ensure the custom code correctly maps the field names from your specific API responses to the desired output fields for Google Sheets.


3. Activate: Set the 'Daily Review Sync' n8n trigger to active mode and save the n8n workflow.

Daily Review Sync (Schedule Trigger): The primary n8n trigger that schedules this n8n workflow to run automatically, typically once per day.
Get Products (Shopify n8n node): Used here to retrieve initial data context from Shopify, such as list of products or company details, which might be needed for targeted review fetching.
Fetch Reviews (HTTP Request n8n node): Three separate instances ('Trustpilot,' 'Google,' 'Facebook') used for making custom API calls to retrieve raw review data from each platform. Proper configuration of URLs and headers is essential.
Normalize Review Data (Code n8n node): A critical n8n node containing custom JavaScript to standardize the diverse input JSON formats into one consistent structure before it is written to the database.
Check if Reviews Found (If n8n node): A flow control n8n node ensuring that the Google Sheet operation only runs if the 'Normalize Review Data' step actually produced valid review items.
Store Reviews Database (Google Sheets n8n node): The final action n8n node configured to append the cleaned and normalized dataset as new rows into the target Google Sheet.