{"product_id":"n8n-slack-it-service-catalog-with-postgres-workflows","title":"n8n: Slack IT Service Catalog with Postgres Workflows","description":"\u003ch3\u003eTurn Slack into an IT service catalog—backed by Postgres workflows\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow creates an internal IT service catalog inside \u003cstrong\u003eSlack\u003c\/strong\u003e. Employees request services via a \u003cstrong\u003eSlack modal\u003c\/strong\u003e, approvals happen through \u003cstrong\u003eSlack DMs\u003c\/strong\u003e, and every request is tracked in \u003cstrong\u003ePostgres\u003c\/strong\u003e—either triggering an external automation \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e or placing the work into an \u003cstrong\u003eIT queue\u003c\/strong\u003e for manual completion.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives Slack requests securely:\u003c\/strong\u003e Handles a Slack slash command and interactive payloads via webhooks, verifying each request using the \u003cstrong\u003eSlack signing secret\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a catalog from Postgres:\u003c\/strong\u003e When an employee runs \u003ccode\u003e\/it\u003c\/code\u003e, the workflow loads \u003cem\u003eactive\u003c\/em\u003e catalog items from \u003cstrong\u003ePostgres\u003c\/strong\u003e, then opens a Slack modal for service selection by category.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates request forms dynamically:\u003c\/strong\u003e After selection, it loads the service definition from Postgres and updates the modal with a service-specific request form.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and records requests:\u003c\/strong\u003e On submission, it validates required fields, creates the request and \u003cstrong\u003eaudit entries\u003c\/strong\u003e in Postgres, and notifies the requester in Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes approvals with Slack DMs:\u003c\/strong\u003e If approval is required, it sends the approver a Slack DM with \u003cstrong\u003eApprove\u003c\/strong\u003e and \u003cstrong\u003eDeny\u003c\/strong\u003e buttons and stores the decision back in Postgres.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExecutes or queues work:\u003c\/strong\u003e For approved requests, it either calls a configured \u003cstrong\u003eHTTP automation endpoint\u003c\/strong\u003e and records the result, or posts the request to an \u003cstrong\u003eIT queue channel\u003c\/strong\u003e with a \u003cstrong\u003eMark complete\u003c\/strong\u003e button.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCloses the loop:\u003c\/strong\u003e When IT marks the queued request complete, it updates request status in Postgres, updates the Slack queue message, and notifies the requester.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEmployees request access, devices, or internal changes through a consistent Slack \u003ccode\u003e\/it\u003c\/code\u003e experience.\u003c\/li\u003e\n  \u003cli\u003eApprovals and audit trails are stored in Postgres, with approvers interacting directly in Slack DMs.\u003c\/li\u003e\n  \u003cli\u003eApproved work is either automated via an external HTTP endpoint or handled in an IT queue channel with manual completion.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Slack (slash commands, modals, interactive payloads, DMs, queue messages) + Postgres\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003epostgres\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Configure Postgres credentials and run the manual setup trigger to create required tables and demo catalog data.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46196308705459,"sku":"N8N-20724","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0-r5D96wIEbPxksivejFx_dtaeD004.png?v=1791623116","url":"https:\/\/buyflowscripts.com\/products\/n8n-slack-it-service-catalog-with-postgres-workflows","provider":"N8N Commerce","version":"1.0","type":"link"}