WeblineIndia This workflow corresponds to n8n.io template #12066 — we link there as the canonical source.
This workflow follows the Airtable → 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 →
{
"id": "REid0mWy2RPzGGKE",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "WooCommerce Review Sentiment Analysis with Slack Summary",
"tags": [],
"nodes": [
{
"id": "bb34add7-02c0-40c1-ae29-47cc424699d5",
"name": "Set WooCommerce Domain",
"type": "n8n-nodes-base.set",
"position": [
-5024,
-640
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3a9c6d3d-4d92-4dfc-9995-d36a1628a1d6",
"name": "wc_domain",
"type": "string",
"value": "{{Your_Woocommerce_Domain}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7504ae47-1e01-4fab-9f40-22009fdc0039",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5936,
-1264
],
"parameters": {
"width": 416,
"height": 624,
"content": "## How it works\n\nThis workflow automatically fetches new product reviews from WooCommerce every 10 minutes. Each review is sent to an AI model for sentiment analysis (positive, neutral, negative). Results are stored in Airtable and summarized in a single count of positive, neutral, and negative reviews. High-priority reviews (negative sentiment or low rating) are highlighted. The workflow then sends a Slack message with a summary of all processed reviews, helping your team quickly monitor customer feedback and take action if needed.\n\n## Setup steps\n\n**1.** Add your WooCommerce credentials for the HTTP Request node.\n\n**2.** Connect your OpenAI API key for the sentiment analysis node.\n\n**3.** Set up Airtable credentials for storing review data.\n\n**4.** Add Slack credentials to send summary messages.\n\n**5.** Activate the workflow in n8n.\n\n**6.** Adjust the schedule if needed (default is every 10 minutes)."
},
"typeVersion": 1
},
{
"id": "63767daf-22e6-4995-b155-111d21e0af4d",
"name": "Every 10 min trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-5248,
-640
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 10
}
]
}
},
"typeVersion": 1.2
},
{
"id": "274aa24b-a225-48c3-bd6e-2335abcd1227",
"name": "Get latest product reviews",
"type": "n8n-nodes-base.httpRequest",
"position": [
-4800,
-640
],
"parameters": {
"url": "=https://{{ $json.wc_domain}}/wp-json/wc/v3/products/reviews",
"options": {},
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.3,
"alwaysOutputData": false
},
{
"id": "0b3ad706-09d7-4193-a9b1-071205d34154",
"name": "Process reviews in batches",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4576,
-640
],
"parameters": {
"options": {},
"batchSize": "=1"
},
"typeVersion": 3
},
{
"id": "60d867e6-077a-4c18-be97-ba98874b50f1",
"name": "Analyze Review Sentiment",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-4352,
-560
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4-turbo",
"cachedResultName": "GPT-4-TURBO"
},
"options": {},
"responses": {
"values": [
{
"content": "=Analyze sentiment of the following product review. \nReturn JSON only.\n\nReview: {{$json[\"review\"]}}\n\nOutput MUST be:\n{\n \"sentiment\": \"positive\" | \"neutral\" | \"negative\",\n \"confidence\": number,\n \"short_summary\": string\n}\n"
}
]
},
"builtInTools": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 2
},
{
"id": "c75fbbe1-1d06-4799-b957-b2ff36199a2e",
"name": "Merge Review & AI Data",
"type": "n8n-nodes-base.merge",
"position": [
-4000,
-640
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "1ffbcfb4-b253-4813-95ef-80d72ddf5ea6",
"name": "Combine Review & AI Results",
"type": "n8n-nodes-base.code",
"position": [
-3776,
-640
],
"parameters": {
"jsCode": "const output = [];\nconst half = items.length / 2;\n\nif (!Number.isInteger(half)) {\n\tthrow new Error(\"Invalid input: reviews and AI results count mismatch\");\n}\n\nfor (let i = 0; i < half; i++) {\n\tconst review = items[i].json;\n\tconst ai = items[i + half].json;\n\n\tlet parsed = {\n\t\tsentiment: \"unscored\",\n\t\tconfidence: null,\n\t\tshort_summary: \"AI failed\"\n\t};\n\n\ttry {\n\t\tlet text = ai.output?.[0]?.content?.[0]?.text;\n\t\tif (text) {\n\t\t\ttext = text.replace(/```json/g, '').replace(/```/g, '').trim();\n\t\t\tparsed = JSON.parse(text);\n\t\t}\n\t} catch {}\n\n\toutput.push({\n\t\tjson: {\n\t\t\treview_id: review.id,\n\t\t\tproduct_id: review.product_id,\n\t\t\tproduct_name: review.product_name,\n\t\t\treview_text: review.review,\n\t\t\trating: review.rating,\n\t\t\tcreated_at: review.date_created,\n\t\t\tsentiment: parsed.sentiment,\n\t\t\tconfidence: parsed.confidence,\n\t\t\tshort_summary: parsed.short_summary\n\t\t}\n\t});\n}\n\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "e9aa4109-ca6c-45b4-ab67-625ce54b2de7",
"name": "Check Sentiment Type",
"type": "n8n-nodes-base.if",
"position": [
-3552,
-640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "7e8963df-a6ee-4d1e-b143-42d2899b4c5c",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.sentiment }}",
"rightValue": "positive"
},
{
"id": "f660f238-c4b1-47f0-92a7-e1894371239d",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.sentiment }}",
"rightValue": "natural"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "57297894-2bf5-431d-8842-6f6b7405e2cd",
"name": "Save Review in Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
-3328,
-704
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appF2iYPgVqqyXDC1",
"cachedResultUrl": "https://airtable.com/appF2iYPgVqqyXDC1",
"cachedResultName": "n8n Demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl6sDESNiBIeyhpb",
"cachedResultUrl": "https://airtable.com/appF2iYPgVqqyXDC1/tbl6sDESNiBIeyhpb",
"cachedResultName": "Product Review"
},
"columns": {
"value": {
"Rating": "={{ $json.rating }}",
"Review ID": "={{ $json.review_id }}",
"Sentiment": "={{ $json.sentiment }}",
"Product ID": "={{ $json.product_id }}",
"Product Name": "={{ $json.product_name }}",
"Review Summary AI": "={{ $json.short_summary }}"
},
"schema": [
{
"id": "Product Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Product Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Product ID",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Product ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sentiment",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Sentiment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Review Summary AI",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Review Summary AI",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Review ID",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Review ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rating",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Rating",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "e380722a-84a5-4285-bd01-8431326def42",
"name": "Merge Summary with Workflow",
"type": "n8n-nodes-base.merge",
"position": [
-3104,
-640
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "aa4fa9ab-443d-4116-8926-47d007fc20ff",
"name": "Summarize Sentiments",
"type": "n8n-nodes-base.code",
"position": [
-2880,
-640
],
"parameters": {
"jsCode": "let positive = 0;\nlet neutral = 0;\nlet negative = 0;\n\nfor (const item of items) {\n // Determine sentiment from either Airtable format or standard format\n const sentiment = item.json.sentiment || item.json.fields?.Sentiment;\n\n if (!sentiment) continue; // skip if no sentiment\n\n if (sentiment.toLowerCase() === \"positive\") positive++;\n else if (sentiment.toLowerCase() === \"neutral\" || sentiment.toLowerCase() === \"natural\") neutral++;\n else if (sentiment.toLowerCase() === \"negative\") negative++;\n}\n\n// Stop workflow if nothing found\nif (positive + neutral + negative === 0) {\n return [];\n}\n\n// Return a single summary item\nreturn [\n {\n json: {\n positive_count: positive,\n neutral_count: neutral,\n negative_count: negative,\n total: positive + neutral + negative\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "5d81b161-15f8-41f3-a3c3-d54d4eb2d297",
"name": "Send Slack Summary",
"type": "n8n-nodes-base.slack",
"position": [
-2656,
-640
],
"parameters": {
"text": "=** Product Review Sentiment Summary:** \nPositive Reviews: {{$json.positive_count}}\nNeutral Reviews: {{$json.neutral_count}}\nNegative Reviews: {{$json.negative_count}}\nTotal Reviews Processed: {{$json.total}}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "C09S57E2JQ2",
"cachedResultName": "n8n"
},
"otherOptions": {
"includeLinkToWorkflow": false
}
},
"credentials": {
"slackApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.3
},
{
"id": "37194cfe-ccb3-4038-b787-c2ad6b0329c5",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5328,
-720
],
"parameters": {
"color": 7,
"height": 224,
"content": "This node runs the workflow every 10 minutes automatically."
},
"typeVersion": 1
},
{
"id": "af032ca2-e69e-4f43-825d-a6fa6966e1f2",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5056,
-816
],
"parameters": {
"color": 7,
"width": 400,
"height": 368,
"content": "## Fetch WooCommerce Reviews\n\nThis process sets your WooCommerce store address and then fetches all the latest product reviews using your store credentials, so the workflow knows which reviews to process next."
},
"typeVersion": 1
},
{
"id": "5278685d-3d66-4ecb-aad2-8577f2c3ba5e",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3600,
-816
],
"parameters": {
"color": 7,
"width": 1152,
"height": 448,
"content": "## Save and Share Review Insights\n\nThis part of the workflow saves each review and its sentiment in Airtable, merges all the data together, counts how many reviews are positive, neutral, or negative, and then sends a clear summary to your Slack channel so the team can quickly see the overall feedback."
},
"typeVersion": 1
},
{
"id": "41d5eefd-c79d-40a4-a50b-5c18a64469ba",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4640,
-816
],
"parameters": {
"color": 7,
"width": 1008,
"height": 448,
"content": "## Analyze Reviews with AI\n\nThis process breaks reviews into smaller groups, sends each review to AI to determine its sentiment and create a short summary, and then combines the AI results with the original review data so everything is ready for the next steps in the workflow."
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "99a340f8-2baa-4ddf-8de3-167b94e6985e",
"connections": {
"Send Slack Summary": {
"main": [
[
{
"node": "Process reviews in batches",
"type": "main",
"index": 0
}
]
]
},
"Check Sentiment Type": {
"main": [
[
{
"node": "Save Review in Airtable",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge Summary with Workflow",
"type": "main",
"index": 1
}
]
]
},
"Every 10 min trigger": {
"main": [
[
{
"node": "Set WooCommerce Domain",
"type": "main",
"index": 0
}
]
]
},
"Summarize Sentiments": {
"main": [
[
{
"node": "Send Slack Summary",
"type": "main",
"index": 0
}
]
]
},
"Merge Review & AI Data": {
"main": [
[
{
"node": "Combine Review & AI Results",
"type": "main",
"index": 0
}
]
]
},
"Set WooCommerce Domain": {
"main": [
[
{
"node": "Get latest product reviews",
"type": "main",
"index": 0
}
]
]
},
"Save Review in Airtable": {
"main": [
[
{
"node": "Merge Summary with Workflow",
"type": "main",
"index": 0
}
]
]
},
"Analyze Review Sentiment": {
"main": [
[
{
"node": "Merge Review & AI Data",
"type": "main",
"index": 1
}
]
]
},
"Get latest product reviews": {
"main": [
[
{
"node": "Process reviews in batches",
"type": "main",
"index": 0
}
]
]
},
"Process reviews in batches": {
"main": [
[],
[
{
"node": "Analyze Review Sentiment",
"type": "main",
"index": 0
},
{
"node": "Merge Review & AI Data",
"type": "main",
"index": 0
}
]
]
},
"Combine Review & AI Results": {
"main": [
[
{
"node": "Check Sentiment Type",
"type": "main",
"index": 0
}
]
]
},
"Merge Summary with Workflow": {
"main": [
[
{
"node": "Summarize Sentiments",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApihttpBasicAuthopenAiApislackApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow automatically fetches product reviews from your WooCommerce store, analyzes the sentiment of each review using AI, stores the results in Airtable and sends a summary of positive, neutral and negative reviews to Slack. It helps teams quickly understand overall…
Source: https://n8n.io/workflows/12066/ — 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.
A scheduled process aggregates content from eight distinct data sources and standardizes all inputs into a unified format. AI models perform sentiment scoring, detect conspiracy or misinformation sign
HTTP Request, OpenAI, Postgres +2
This workflow automatically turns any audio file uploaded to Google Drive into a complete podcast episode. It handles transcription, content generation, blog drafting, social copy creation, thumbnail
Google Drive Trigger, Google Drive, OpenAI +3
Imagine a dedicated financial expert tirelessly working behind the scenes, sifting through every transaction, every investment move, and every accounting entry. That's exactly what this automated syst
HTTP Request, Google Sheets, OpenAI +3
AI-Powered Fake Review Detection Workflow Using n8n & Airtable. Uses httpRequest, airtable, openAi, slack. Webhook trigger; 27 nodes.
HTTP Request, Airtable, OpenAI +1
Automate your social media content pipeline from idea to scheduled post. This workflow reads content ideas from a Google Sheet, uses OpenAI to generate platform-optimized posts for LinkedIn, X (Twitte
Google Sheets, OpenAI, HTTP Request +2