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.
14 nodeswebhook trigger136 views0 copiesOther
Twitter/X

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

  1. 1Copy the workflow JSON above using the Copy Workflow JSON button.
  2. 2Open your n8n instance and go to Workflows.
  3. 3Click Import from JSON and paste the copied workflow.

Don't have an n8n instance? Start your free trial at n8nautomation.cloud

Related Templates

KB Tool - Confluence Knowledge Base

Quickly retrieve information from your Confluence knowledge base with this n8n workflow. It connects to your Confluence instance via an HTTP Request node, allowing you to query for specific content directly from n8n. This workflow is ideal for support teams needing to rapidly access articles, developers looking up documentation, or anyone who frequently references Confluence pages and wants to integrate that data into other automated processes. By centralizing Confluence queries within n8n, you save significant time and effort previously spent manually navigating and searching, streamlining information retrieval and improving operational efficiency.

7 nodes

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.

5 nodes

Hacker News Throwback Machine - See What Was Hot on This Day, Every Year!

Discover what was trending on Hacker News on this exact day, every year, with the Hacker News Throwback Machine. This n8n workflow automates the process of fetching historical Hacker News front pages and summarizing the top stories, delivering a daily dose of tech nostalgia directly to your Telegram chat. A Schedule Trigger initiates the workflow, which then dynamically generates a list of past years. For each year, it uses an HTTP Request node to retrieve the Hacker News front page for today's date, then an HTML Extract Details node parses the headlines and links. These headlines are then compiled and fed into a Google Gemini Chat Model via a Basic LLM Chain, which summarizes the most interesting stories. Finally, the summarized insights are sent to your designated Telegram chat, providing a unique historical perspective without any manual effort. This workflow is perfect for tech enthusiasts, developers, or anyone curious about the evolution of tech news, saving significant time and effort compared to manually searching through archives.

13 nodes

Ready to automate with n8n?

Get affordable managed n8n hosting with 24/7 support.