Shopify Review Aggregator: Trustpilot, Google, Facebook to Sheets

This n8n workflow collects the latest customer reviews from multiple platforms including Trustpilot, Google Reviews, and Facebook using their respective APIs. It triggers daily at 10 AM, fetches raw review data, normalizes it into a consistent format (including rating, text, date, source, customer name), removes duplicates, and appends everything to a centralized Google Sheets spreadsheet. This creates a comprehensive review repository ideal for Shopify store owners monitoring social proof.

Benefits include time savings on manual review tracking, centralized data for quick analysis, response management, and marketing content like testimonials. It handles varying API response formats via a Code node for mapping, ensuring reliability across platforms. Use cases: E-commerce businesses aggregating feedback for product improvements, customer service teams triaging responses, or marketers curating testimonials for ads and websites.

Setup is straightforward: Configure API credentials for each platform and Google Sheets, create the spreadsheet with required columns, test individual API nodes, and adjust the schedule as needed. The workflow scales with review volume and supports Shopify context for product-linked reviews, making it a powerful tool for social proof automation.