AutomationFlowsSocial Media › Shopify Review Aggregator: Trustpilot, Google, Facebook to Google Sheets

Shopify Review Aggregator: Trustpilot, Google, Facebook to Google Sheets

ByDavid Olusola @dae221 on n8n.io

The schedule triggers daily review collection from configured platforms and connects to multiple review platform APIs to download latest reviews. The workflow normalizes review data into consistent format with rating, text, date, source, and customer name. It removes duplicates…

Cron / scheduled trigger★★★★☆ complexity13 nodesShopifyHTTP RequestGoogle Sheets
Social Media Trigger: Cron / scheduled Nodes: 13 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #6112 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "VaL3XAWomsvW7ibb",
  "name": "MULTI-PLATFORM REVIEW AGGREGATOR",
  "tags": [],
  "nodes": [
    {
      "id": "746adbc5-aeb8-40fd-ae0c-a3fd9e6fab5a",
      "name": "Daily Review Sync",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -880,
        340
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d3c5a37e-9c39-4b81-a6b8-8752dae02ec2",
      "name": "Get Products",
      "type": "n8n-nodes-base.shopify",
      "position": [
        -660,
        340
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a19fd031-7998-48d4-854d-cb3bd2377686",
      "name": "Fetch Trustpilot Reviews",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -440,
        240
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "c7552932-9ffd-458d-90dd-8876756ce012",
      "name": "Fetch Google Reviews",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -440,
        340
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "dc3e88e5-0e55-4a59-a983-c813a6328dda",
      "name": "Fetch Facebook Reviews",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -440,
        440
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "44d7f0d0-cb0b-4670-ad93-b5e38246dc24",
      "name": "Normalize Review Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -220,
        340
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1127884c-a3b7-4c31-9b3d-442eb4cebc4e",
      "name": "Check if Reviews Found",
      "type": "n8n-nodes-base.if",
      "position": [
        0,
        340
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "91234883-4c8e-4400-9146-079c0746ff67",
      "name": "Store Reviews Database",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        340
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "7a310f10-d88e-45eb-b112-0c59187e4a10",
      "name": "Workflow Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1220,
        120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "30572c35-33fe-4b41-8b63-0ce8009eb65d",
      "name": "Features & Config",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a80c8009-0090-4f2f-ad8a-805af9d5c7b6",
      "name": "Business Value",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "93776d7d-8bae-431b-b424-f193cd88d593",
      "name": "Platforms & Flow",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "86bdf061-24a5-4a2e-93e2-54c75c76822a",
      "name": "API Requirements",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "357f793e-603a-438f-892e-1ed52132c8a6",
  "connections": {
    "Get Products": {
      "main": [
        [
          {
            "node": "Fetch Trustpilot Reviews",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Google Reviews",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Facebook Reviews",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Review Sync": {
      "main": [
        [
          {
            "node": "Get Products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Google Reviews": {
      "main": [
        [
          {
            "node": "Normalize Review Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Review Data": {
      "main": [
        [
          {
            "node": "Check if Reviews Found",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if Reviews Found": {
      "main": [
        [
          {
            "node": "Store Reviews Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Facebook Reviews": {
      "main": [
        [
          {
            "node": "Normalize Review Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Trustpilot Reviews": {
      "main": [
        [
          {
            "node": "Normalize Review Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

The schedule triggers daily review collection from configured platforms and connects to multiple review platform APIs to download latest reviews. The workflow normalizes review data into consistent format with rating, text, date, source, and customer name. It removes duplicates…

Source: https://n8n.io/workflows/6112/ — original creator credit. Request a take-down →

More Social Media workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Social Media

This enterprise-grade n8n workflow automates the Instagram complaint handling process — from detection to resolution — using Claude AI, dynamic ticket assignment, and SLA enforcement. It converts cust

HTTP Request, Google Sheets, Slack
Social Media

This workflow automatically mirrors your YouTube to TikTok and Instagram, so you don’t have to manually download and re-upload your content across platforms.

@Blotato/N8N Nodes Blotato, Execute Command, HTTP Request +2
Social Media

This enterprise-grade n8n workflow automates influencer contract compliance for Instagram campaigns — from deadline tracking to breach detection — using Claude AI, Instagram API, and smart reminders.

Google Sheets, Slack, HTTP Request
Social Media

How it works

Google Sheets, Google Drive, HTTP Request +1
Social Media

This is for founders, service providers and anyone who wants to do more social listening but doesn't want to pay for an expensive tool.

Google Sheets, HTTP Request, XML +1