Keyword Based Content Publishing Pipeline to Storyblok with Slack

This workflow automates content publishing to Storyblok, using Webhook, Function, Postgres, HTTP Request, Slack, and Email nodes. It handles keyword-based publishing, AI optimization, approval workflows, and analytics for marketing and content teams. To set up, install n8n by downloading from n8n.io for self-hosting or sign up at cloud.n8n.io for a hosted solution. Create a Storyblok account at storyblok.com, generate a Management API token in your space settings, and configure it in HTTP Request nodes ("Dynamic Content Fetcher", "Storyblok Publisher"). Set up a PostgreSQL database for user permissions and analytics, adding credentials in Postgres nodes ("User Permissions Manager", "Publication Database", "Publishing Analytics"). Create a Slack workspace at slack.com, generate a webhook URL, and set it in the Slack node ("Approval Notification"). Configure an SMTP server for Email nodes ("Basic Email Notification", "User Error Support"). Ensure the Webhook node’s URL (path: content-publishing-factory) is publicly accessible with header authentication. Test the workflow by sending a POST request to the Webhook URL with JSON payload {userId: "123", action: "publish_by_keyword", keywords: ["blog"], workspaceId: "456"}. Use tools like Postman or curl. Validate output in the Webhook Response node for success=true, publication_results, and live_url. Check Postgres analytics for stories_published and success_rate. Errors like missing keywords trigger a 400 status in the Function node ("Publishing Request Validator"). Invalid Storyblok API tokens cause HTTP Request node failures with a 401 status. Insufficient permissions result in a 403 status from the Function node ("Permission Validator"). Deploy by activating the workflow in n8n and integrating the Webhook URL with your platform. Monitor Slack for approval notifications and emails for user confirmations. If no content is found, the Function node ("Content Analyzer") returns a no_content_found error with suggestions to check keywords or content status.