Automate testimonials in Strapi with n8n
Collect and manage testimonials for your business directly within Strapi using this n8n workflow. This automation connects to Twitter/X to automatically find positive mentions and also processes form submissions, leveraging Google Cloud Natural Language for sentiment analysis before storing approved testimonials in your Strapi content management system. Businesses can use this to continuously populate their website with fresh, authentic customer feedback from social media or dedicated submission forms, ensuring a steady stream of social proof without manual effort. This workflow significantly reduces the time and resources spent on gathering, reviewing, and publishing testimonials, allowing marketing teams to focus on other strategic initiatives. It monitors Twitter/X every 30 minutes for relevant tweets, analyzes their sentiment, and also processes incoming webhook-triggered form submissions, only storing positively-rated content in Strapi.
Workflow JSON
{"nodes": [{"name": "Simplify Result", "type": "n8n-nodes-base.set", "position": [680, 100], "parameters": {"values": {"string": [{"name": "Content", "value": "={{$json[\"full_text\"].replace(/(?:https?|ftp):\\/\\/[\\n\\S]+/g, '')}}"}, {"name": "Author", "value": "={{$json[\"user\"][\"name\"]}} (@{{$json[\"user\"][\"screen_name\"]}})"}, {"name": "Created", "value": "={{new Date($json[\"created_at\"]).toISOString()}}"}, {"name": "URL", "value": "=https://twitter.com/{{$json[\"user\"][\"screen_name\"]}}/status/{{$json[\"id_str\"]}}"}]}, "options": {}, "keepOnlySet": true}, "typeVersion": 1}, {"name": "Store in Strapi", "type": "n8n-nodes-base.strapi", "position": [1780, 100], "parameters": {"columns": "Content,Author,Created,URL", "operation": "create", "contentType": "posts"}, "credentials": {"strapiApi": {"id": "", "name": "[Your strapiApi]"}}, "typeVersion": 1}, {"name": "Every 30 Minutes", "type": "n8n-nodes-base.interval", "position": [240, 100], "parameters": {"unit": "minutes", "interval": 30}, "typeVersion": 1}, {"name": "Is Retweet or Old?", "type": "n8n-nodes-base.if", "position": [900, 100], "parameters": {"conditions": {"string": [{"value1": "={{$json[\"Content\"]}}", "value2": "RT @", "operation": "startsWith"}], "dateTime": [{"value1": "={{$json[\"Created\"]}}", "value2": "={{new Date(new Date().getTime() - 30 * 60 * 1000)}}", "operation": "before"}]}, "combineOperation": "any"}, "typeVersion": 1}, {"name": "Search Tweets", "type": "n8n-nodes-base.twitter", "position": [460, 100], "parameters": {"operation": "search", "searchText": "(strapi OR n8n.io) AND lang:en", "additionalFields": {"tweetMode": "extended", "resultType": "recent"}}, "credentials": {"twitterOAuth1Api": {"id": "", "name": "[Your twitterOAuth1Api]"}}, "typeVersion": 1}, {"name": "Webhook", "type": "n8n-nodes-base.webhook", "position": [240, -120], "webhookId": "6f833370-9068-44ef-8e56-4ceb563a851e", "parameters": {"path": "6f833370-9068-44ef-8e56-4ceb563a851e", "options": {}, "httpMethod": "POST"}, "typeVersion": 1}, {"name": "Simplify Webhook Result", "type": "n8n-nodes-base.set", "position": [460, -120], "parameters": {"values": {"string": [{"name": "Content", "value": "={{$json[\"body\"][\"data\"][\"fields\"][1][\"value\"]}}"}, {"name": "Author", "value": "={{$json[\"body\"][\"data\"][\"fields\"][0][\"value\"]}}"}, {"name": "Created", "value": "={{new Date().toISOString()}}"}, {"name": "URL"}]}, "options": {}, "keepOnlySet": true}, "typeVersion": 1}, {"name": "Analyze Form Submission", "type": "n8n-nodes-base.googleCloudNaturalLanguage", "position": [680, -220], "parameters": {"content": "={{$json[\"Content\"]}}", "options": {}}, "credentials": {"googleCloudNaturalLanguageOAuth2Api": {"id": "", "name": "[Your googleCloudNaturalLanguageOAuth2Api]"}}, "typeVersion": 1}, {"name": "Analyze Tweet", "type": "n8n-nodes-base.googleCloudNaturalLanguage", "position": [1120, 200], "parameters": {"content": "={{$json[\"Content\"]}}", "options": {}}, "credentials": {"googleCloudNaturalLanguageOAuth2Api": {"id": "", "name": "[Your googleCloudNaturalLanguageOAuth2Api]"}}, "typeVersion": 1}, {"name": "Merge Form Sentiment with Source", "type": "n8n-nodes-base.merge", "position": [900, -120], "parameters": {"mode": "mergeByIndex"}, "typeVersion": 1}, {"name": "Merge Tweet Sentiment with Source", "type": "n8n-nodes-base.merge", "position": [1340, 100], "parameters": {"mode": "mergeByIndex"}, "typeVersion": 1}, {"name": "Positive Form Sentiment?", "type": "n8n-nodes-base.if", "position": [1120, -120], "parameters": {"conditions": {"number": [{"value1": "={{$json[\"documentSentiment\"][\"score\"]}}", "value2": 0.4, "operation": "larger"}]}}, "typeVersion": 1}, {"name": "Store Form Submission in Strapi", "type": "n8n-nodes-base.strapi", "position": [1340, -120], "parameters": {"columns": "Content,Author,Created,URL", "operation": "create", "contentType": "posts"}, "credentials": {"strapiApi": {"id": "", "name": "[Your strapiApi]"}}, "typeVersion": 1}, {"name": "Positive Tweet Sentiment?", "type": "n8n-nodes-base.if", "position": [1560, 100], "parameters": {"conditions": {"number": [{"value1": "={{$json[\"documentSentiment\"][\"score\"]}}", "value2": 0.3, "operation": "larger"}]}}, "typeVersion": 1}], "connections": {"Webhook": {"main": [[{"node": "Simplify Webhook Result", "type": "main", "index": 0}]]}, "Analyze Tweet": {"main": [[{"node": "Merge Tweet Sentiment with Source", "type": "main", "index": 1}]]}, "Search Tweets": {"main": [[{"node": "Simplify Result", "type": "main", "index": 0}]]}, "Simplify Result": {"main": [[{"node": "Is Retweet or Old?", "type": "main", "index": 0}]]}, "Every 30 Minutes": {"main": [[{"node": "Search Tweets", "type": "main", "index": 0}]]}, "Is Retweet or Old?": {"main": [null, [{"node": "Analyze Tweet", "type": "main", "index": 0}, {"node": "Merge Tweet Sentiment with Source", "type": "main", "index": 0}]]}, "Analyze Form Submission": {"main": [[{"node": "Merge Form Sentiment with Source", "type": "main", "index": 0}]]}, "Simplify Webhook Result": {"main": [[{"node": "Analyze Form Submission", "type": "main", "index": 0}, {"node": "Merge Form Sentiment with Source", "type": "main", "index": 1}]]}, "Positive Form Sentiment?": {"main": [[{"node": "Store Form Submission in Strapi", "type": "main", "index": 0}]]}, "Positive Tweet Sentiment?": {"main": [[{"node": "Store in Strapi", "type": "main", "index": 0}]]}, "Merge Form Sentiment with Source": {"main": [[{"node": "Positive Form Sentiment?", "type": "main", "index": 0}]]}, "Merge Tweet Sentiment with Source": {"main": [[{"node": "Positive Tweet Sentiment?", "type": "main", "index": 0}]]}}}How to Import This Workflow
- 1Copy the workflow JSON above using the Copy Workflow JSON button.
- 2Open your n8n instance and go to Workflows.
- 3Click Import from JSON and paste the copied workflow.
Don't have an n8n instance? Start your free trial at n8nautomation.cloud
Related Templates
Visualize your SQL Agent queries with OpenAI and Quickchart.io
Visualize your SQL Agent queries with OpenAI and Quickchart.io empowers you to instantly transform complex SQL Agent query results into insightful charts and graphs, all through a simple chat interface. This workflow connects an OpenAI Chat Model to interpret your chat messages, determine if a chart is needed using a Text Classifier, and then leverages Quickchart.io by generating a chart definition with structured output via an HTTP Request node. It automates the entire process from receiving a chat message to extracting the user's question, passing it to an AI Agent, and then conditionally generating and displaying a chart, saving significant time and effort for data analysts, developers, and business intelligence professionals who frequently need to visualize their SQL data. By automating chart generation, this workflow eliminates the manual steps of data extraction, chart selection, and configuration, allowing users to quickly gain visual insights from their SQL Agent queries without needing to switch between multiple tools or possess advanced charting skills.
Analyze the sentiment of feedback and send a message on Mattermost
Automatically analyze customer feedback sentiment and notify your team on Mattermost with this n8n workflow. This automation connects Typeform submissions directly to Google Cloud Natural Language for sentiment analysis, then routes the results to your Mattermost channel. When a user submits a form through Typeform, the workflow extracts the feedback, sends it to Google Cloud Natural Language for sentiment scoring, and based on that score, sends a message to a designated Mattermost channel, allowing for immediate team awareness of positive, negative, or neutral feedback. This workflow is ideal for product managers, customer support teams, or marketing departments who need to quickly gauge public opinion or customer satisfaction from surveys, support tickets, or product reviews, enabling faster response times to critical feedback and reducing the manual effort of monitoring and reporting. It saves significant time and ensures that important customer insights are never missed, fostering a more responsive and customer-centric operation.
Qualify replies from Pipedrive persons with AI
Automate the qualification of inbound email replies from Pipedrive contacts using artificial intelligence. This workflow connects Gmail and OpenAI to your Pipedrive CRM, streamlining your lead nurturing process. When a new email arrives in either of your specified Gmail inboxes (Email box 1 or Email box 2), the workflow searches for the sender as a person in Pipedrive. It then retrieves their full person details and sends the email content to OpenAI for an AI-powered assessment of interest (Is interested?). Based on OpenAI's response, if the person is deemed interested, a new deal is automatically created in Pipedrive, ensuring hot leads are immediately acted upon. This is ideal for sales teams, marketers, and business development professionals who receive a high volume of email replies and need to quickly identify and prioritize genuinely interested prospects, saving significant manual review time and accelerating sales cycles.