Fahmi Fahreza This workflow corresponds to n8n.io template #9985 — we link there as the canonical source.
This workflow follows the Agent → Form Trigger 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b3967ef3-95ea-4e07-b861-7375b1cb1027",
"name": "Decodo Review Scraper",
"type": "@decodo/n8n-nodes-decodo.decodoTool",
"position": [
3008,
592
],
"parameters": {},
"typeVersion": 1
},
{
"id": "395d0b28-b2ba-4d3b-bdf1-e0cb35eda325",
"name": "Parse: Structured JSON Output",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
3248,
592
],
"parameters": {
"jsonSchemaExample": "{\n \"business_name\": \"Shein\",\n \"industry_field\": \"Online Fast Fashion Retail\",\n \"company_summary\": \"Shein is a global e-commerce fashion brand offering low-cost clothing and accessories, primarily targeting young consumers worldwide.\",\n \"trustpilot_reviews\": [\n { \"rating\": \"4/5\", \"summary\": \"Customers like the variety and prices but complain about slow shipping.\" },\n { \"rating\": \"3/5\", \"summary\": \"Quality can be inconsistent but returns are easy.\" }\n ],\n \"sitejabber_reviews\": [\n { \"rating\": \"3.5/5\", \"summary\": \"Affordable fashion but poor customer service response times.\" },\n { \"rating\": \"4/5\", \"summary\": \"Trendy products and frequent restocks are appreciated.\" }\n ],\n \"overall_sentiment\": \"Positive\",\n \"source_links\": {\n \"trustpilot\": \"https://www.trustpilot.com/review/shein.com\",\n \"sitejabber\": \"https://www.sitejabber.com/reviews/shein.com\"\n }\n}"
},
"typeVersion": 1.3
},
{
"id": "8321a7a0-7150-4733-a2bb-ac10034cde3e",
"name": "LLM: Summarize & Recommendations",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
3536,
288
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "models/gemini-2.5-flash",
"cachedResultName": "models/gemini-2.5-flash"
},
"options": {},
"messages": {
"values": [
{
"content": "=Analyze this business reviews, if there is no review from one of the website, add a message \"There's no data in this website\"\nTrustpilot: {{ $json.output.trustpilot_reviews.toJsonString() }}\nSitejabber: {{ $json.output.sitejabber_reviews.toJsonString() }}\nResellerratings: {{ $json.output.resellerratings_reviews.toJsonString() }}\n\nGive conclusion, what to improve and overall aspect."
}
]
}
},
"typeVersion": 1
},
{
"id": "5dd6eeb6-27a6-483d-a07a-7295544991b4",
"name": "Merge: Business Data + Review Summary",
"type": "n8n-nodes-base.merge",
"position": [
3888,
368
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3.2
},
{
"id": "e07ad46f-92db-4a5c-adf5-34c52e01ced0",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1312,
128
],
"parameters": {
"width": 800,
"height": 736,
"content": "## Analyze Trustpilot & Sitejabber sentiment with Decodo + Gemini to Sheets\n\nSign up for Decodo [HERE](https://visit.decodo.com/discount) for Discount\n\nThis template scrapes public reviews from **Trustpilot** and **Sitejabber** with a Decodo tool, converts findings into a **flat, spreadsheet-ready JSON**, generates a concise sentiment summary with **Gemini**, and appends everything to **Google Sheets**. It\u2019s ideal for reputation snapshots, competitive analysis, or lightweight BI pipelines that need structured data and a quick narrative.\n\n## Who\u2019s it for?\nMarketing teams, growth analysts, founders, and agencies who need repeatable review collection and sentiment summaries without writing custom scrapers or manual copy/paste.\n\n## How it works\n1. A **Form Trigger** collects the *Business Name or URL*.\n2. **Set (Config Variables)** stores `business_name`, `spreadsheet_id`, and `sheet_id`.\n3. The **Agent** orchestrates the Decodo tool and enforces a **strict JSON schema** with at most **10 reviews per source**.\n4. **Gemini** writes a succinct summary and recommendations, noting missing sources with: \u201cThere\u2019s no data in this website.\u201d\n5. A **Merge** node combines JSON fields with the narrative.\n6. **Google Sheets** appends a row.\n\n## How to set up\n1. Add **Google Sheets**, **Gemini**, and **Decodo** credentials in Credential Manager.\n2. Replace `(YOUR_SPREADSHEET_ID)` and `(YOUR_SHEET_ID)` in **Set: Config Variables**.\n3. In **Google Sheets**, select **Define below** and map each column explicitly.\n4. Keep the parser and agent connections intact to guarantee flat JSON.\n5. Activate, open the form URL, submit a business, and verify the appended row.\n"
},
"typeVersion": 1
},
{
"id": "ab87b014-b4a0-42a6-82fc-507de7676392",
"name": "Trigger: Business Review Form",
"type": "n8n-nodes-base.formTrigger",
"position": [
2304,
368
],
"parameters": {
"options": {},
"formTitle": "Business Review Lookup",
"formFields": {
"values": [
{
"fieldLabel": "Business Name or URL",
"requiredField": true
}
]
}
},
"typeVersion": 2.3
},
{
"id": "6225118a-a9d8-4cba-93b2-b66e3a063874",
"name": "Set: Config Variables",
"type": "n8n-nodes-base.set",
"position": [
2608,
368
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b9f1e501-0234-4d32-a7ba-8287c5d3f80e",
"name": "business_name",
"type": "string",
"value": "={{ $json['Business Name or URL'] }}"
},
{
"id": "5f681a78-395f-4ff8-b56a-2d31d425ee15",
"name": "=chatInput",
"type": "string",
"value": "=I\u2019d like to know more about the business reputation of {{ $json['Business Name'] }}. Please summarize the company profile and collect recent customer reviews"
},
{
"id": "30674f1c-a98f-4af8-b560-f8ac00fcf345",
"name": "spreadsheet_id",
"type": "string",
"value": "(YOUR_SPREADSHEET_ID)"
},
{
"id": "5e34efe2-8eff-4f67-a516-83ddc89c79e1",
"name": "sheet_id",
"type": "string",
"value": "(YOUR_SHEET_ID)"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "75df53bb-75ef-4315-a94f-9c4665eb86bc",
"name": "Agent: Business Review Scanner",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2928,
368
],
"parameters": {
"options": {
"systemMessage": "=# System Message \u2014 Business Review Scanner Agent (Structured JSON Version)\n\nYou are a Business Review Scanner Agent, an intelligent assistant specialized in analyzing and summarizing customer reviews for a specific business.\n\nYour goal is to collect data and generate structured JSON output that can be directly stored in spreadsheets or databases.\n\n---\n\n## Tools\n\nDecodo Tool \u2014 used for scraping and extracting reviews only from:\n\n- Trustpilot\n- Sitejabber\n\n---\n\n## Task Description\n\nWhen the user provides a business name, you must:\n\n1. Scrape and extract available company details and reviews from the sources above.\n2. Analyze the company profile, recent customer sentiment, and summarize the key points.\n3. Return a clean, valid JSON object using the format described below.\n\n---\n\n## Output Rules\n\n1. The output must be strictly JSON (no markdown, no text outside `{}`).\n2. JSON must be flat and machine-readable, ideal for spreadsheets or database import.\n3. If a source (Trustpilot, Sitejabber, or ResellerRatings) is missing, leave the corresponding field with \"Data not found\".\n4. Include no more than 10 summarized reviews per source.\n5. Do not include raw HTML, emojis, or extra text.\n6. All fields are required \u2014 if unavailable, set the value as `null` or empty string.\n\n## Required JSON Structure\n{\n \"business_name\": \"string\",\n \"industry_field\": \"string\",\n \"company_summary\": \"string\",\n \"trustpilot_reviews\": [\n {\n \"rating\": \"number or string\",\n \"summary\": \"string\"\n }\n ],\n \"sitejabber_reviews\": [\n {\n \"rating\": \"number or string\",\n \"summary\": \"string\"\n }\n ],\n \"overall_sentiment\": \"Positive | Negative\",\n \"source_links\": {\n \"trustpilot\": \"string\",\n \"sitejabber\": \"string\",\n \"resellerratings\": \"string\"\n }\n}\n"
},
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "276b185c-d39b-4b04-b590-07cbb6fc0153",
"name": "Google Sheets: Append Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
4192,
368
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Set: Config Variables').item.json.sheet_id }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Set: Config Variables').item.json.spreadsheet_id }}"
}
},
"executeOnce": false,
"typeVersion": 4.7
},
{
"id": "cd647de7-742b-4f06-8080-c07aa88381c2",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2224,
272
],
"parameters": {
"color": 5,
"width": 256,
"height": 320,
"content": "Use one required field: Business Name or URL."
},
"typeVersion": 1
},
{
"id": "cfe0365e-9499-4398-ad67-16f3ad509c09",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2512,
272
],
"parameters": {
"color": 5,
"width": 288,
"height": 320,
"content": "Make sure to replace (YOUR_SPREADSHEET_ID) and (YOUR_SHEET_ID) with your own ID."
},
"typeVersion": 1
},
{
"id": "57a50323-5a6d-4ba1-9586-af416018aa6d",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2928,
576
],
"parameters": {
"color": 3,
"height": 256,
"content": "\n\n\n\n\n\n\n\n\n\n\n\nCommunity node; works on self-hosted n8n. Make sure to add your Decodo API credentials."
},
"typeVersion": 1
},
{
"id": "3cfcc791-c731-4c6f-acf9-a295584c013d",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3184,
576
],
"parameters": {
"color": 3,
"width": 224,
"height": 256,
"content": "\n\n\n\n\n\n\n\n\n\n\n\nKeep the provided schema. Output must be strictly flat JSON."
},
"typeVersion": 1
},
{
"id": "0df84067-d98a-44f1-948c-c1628dd0231d",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
4096,
144
],
"parameters": {
"color": 5,
"width": 304,
"height": 400,
"content": "Google Sheets columns for mapping (suggested)\n- business_name, \n- industry_field, \n- company_summary, \n- overall_sentiment,\n- summary_text,\n- trustpilot_url, \n- sitejabber_url"
},
"typeVersion": 1
},
{
"id": "3970e8f3-7873-4691-8ea7-12fb64b1d8eb",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2144,
0
],
"parameters": {
"color": 3,
"width": 480,
"height": 96,
"content": "> **Disclaimer:** This workflow relies on a **community Decodo node** and therefore requires **self-hosted n8n**. Install the node from the community marketplace and configure the Decodo API credential."
},
"typeVersion": 1
},
{
"id": "4952fed2-fada-4908-b3af-1355eb45f6c2",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
2144,
128
],
"parameters": {
"color": 4,
"width": 2288,
"height": 736,
"content": "## Analyze Business Reputation (Trustpilot + Sitejabber) with Gemini and Decodo\n\nSelf-hosted template using a community Decodo node. Scrapes reviews, produces flat JSON, summarizes with Gemini, and appends results to Google Sheets."
},
"typeVersion": 1
},
{
"id": "d2d1b267-1b21-473b-9ae7-1cda964b9ffc",
"name": "AI Model: Google Gemini (Agent)",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2800,
656
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.5-pro"
},
"typeVersion": 1
},
{
"id": "11ecf6e7-11c3-40ce-befa-2ddd98b17774",
"name": "Set: Output Fields",
"type": "n8n-nodes-base.set",
"position": [
3280,
368
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "5fd2f317-d25e-478c-a013-37cf49f68170",
"name": "output.business_name",
"type": "string",
"value": "={{ $json.output.business_name }}"
},
{
"id": "b643e944-69f2-4a30-b5ed-4cd21d225d14",
"name": "output.industry_field",
"type": "string",
"value": "={{ $json.output.industry_field }}"
},
{
"id": "767fa26e-2227-4a2f-92fd-ee5946c9ef75",
"name": "output.company_summary",
"type": "string",
"value": "={{ $json.output.company_summary }}"
},
{
"id": "c4b6165b-c697-41d1-a0e2-7980d1ce1d66",
"name": "output.trustpilot_reviews",
"type": "array",
"value": "={{ $json.output.trustpilot_reviews }}"
},
{
"id": "5ce03ddd-cfc2-4c1e-9f63-17af186e654e",
"name": "output.sitejabber_reviews",
"type": "array",
"value": "={{ $json.output.sitejabber_reviews }}"
},
{
"id": "17713d7e-4434-4897-8fc5-d6fdaf0acf13",
"name": "output.overall_sentiment",
"type": "string",
"value": "={{ $json.output.overall_sentiment }}"
},
{
"id": "0e570aa8-b046-48f1-a1c1-28cb598a136b",
"name": "output.source_links",
"type": "object",
"value": "={{ $json.output.source_links }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9069b871-8512-44d8-b5f0-899fc1012564",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2752,
-560
],
"parameters": {
"width": 1120,
"height": 656,
"content": "@[youtube](PDc0MwcicDQ)\n"
},
"typeVersion": 1
}
],
"connections": {
"Set: Output Fields": {
"main": [
[
{
"node": "LLM: Summarize & Recommendations",
"type": "main",
"index": 0
},
{
"node": "Merge: Business Data + Review Summary",
"type": "main",
"index": 1
}
]
]
},
"Decodo Review Scraper": {
"ai_tool": [
[
{
"node": "Agent: Business Review Scanner",
"type": "ai_tool",
"index": 0
}
]
]
},
"Set: Config Variables": {
"main": [
[
{
"node": "Agent: Business Review Scanner",
"type": "main",
"index": 0
}
]
]
},
"Parse: Structured JSON Output": {
"ai_outputParser": [
[
{
"node": "Agent: Business Review Scanner",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Trigger: Business Review Form": {
"main": [
[
{
"node": "Set: Config Variables",
"type": "main",
"index": 0
}
]
]
},
"Agent: Business Review Scanner": {
"main": [
[
{
"node": "Set: Output Fields",
"type": "main",
"index": 0
}
]
]
},
"AI Model: Google Gemini (Agent)": {
"ai_languageModel": [
[
{
"node": "Agent: Business Review Scanner",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"LLM: Summarize & Recommendations": {
"main": [
[
{
"node": "Merge: Business Data + Review Summary",
"type": "main",
"index": 0
}
]
]
},
"Merge: Business Data + Review Summary": {
"main": [
[
{
"node": "Google Sheets: Append Results",
"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
Sign up for Decodo HERE for Discount
Source: https://n8n.io/workflows/9985/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates batch video publishing prep from a Google Drive folder with AI-generated, platform-specific copy and a simple approval queue in Google Sheets. Perfect for Agencies, content cre
Form Trigger, Google Drive, Google Gemini +5
This workflow automatically creates AI product review videos from a product image and short description using n8n and Veo 3.
Google Gemini Chat, Output Parser Structured, HTTP Request +5
This n8n workflow is a full inbound → outbound hybrid funnel designed for AI agencies. It captures warm leads through instant AI value, then automatically follows up with personalized, context-aware o
Form Trigger, Google Gemini, Microsoft Outlook +4
Sign up for Decodo — get better pricing here
Form Trigger, Google Sheets, Output Parser Structured +4
This n8n template generates high-quality, platform-ready hashtags for beauty and skincare brands by combining AI, live website analysis, and current social media trends. It is designed for marketers,
Form Trigger, Agent, Google Gemini Chat +5