Route customer feedback between Salesforce, Jira, and Qwen OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Salesforce
n8n-nodes-base.salesforce - Jira Software
n8n-nodes-base.jira - Merge
n8n-nodes-base.merge - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Switch
n8n-nodes-base.switch
What it does
Quick overview This workflow runs weekly (or manually) to collect recent customer feedback from Salesforce Cases and Jira tickets, redact and deduplicate it, classify it with an OpenAI-compatible LLM, then cluster and route issues by category by creating or updating Jira VOC issues and creating Salesforce follow-up tasks. How it works 1. Runs on a weekly schedule (or on demand) and computes a lookback time window for collecting new feedback. 2. Pulls recent Salesforce Cases, Jira issues for a configured project, and Salesforce Account data (or uses built-in sample feedback when enabled). 3. Normalizes the text, redacts emails and phone numbers, drops duplicates using workflow static data, and flags VIP items based on account revenue, rating, or an allowlist. 4. Sends the batch of feedback to an OpenAI-compatible chat model (configured for Featherless AI) to classify each item by category, theme, sentiment, urgency, and churn risk. 5. Aggregates the classified feedback into category clusters, assigns priority, and builds an HTML weekly digest summary. 6. When live mode is enabled, routes clusters by team by commenting on or creating labeled VOC issues in Jira for product topics and creating Salesforce follow-up Tasks for billing, onboarding, sales/engagement, and escalations. Setup 1. Add credentials for Salesforce and Jira Software Cloud, and an OpenAI-compatible API credential for the LLM node (update the base URL/model if you are not using Featherless AI). 2. In the Config values, set your Jira project key, Jira project ID, and Jira issue type ID, and decide your lookback period, VIP rules, and max items per run. 3. Set usesampledata to false to pull from Salesforce and Jira, then set dryrun to false to allow the workflow to create Jira issues/comments and Salesforce Tasks. 4. (Optional) Enable and configure Google Sheets logging by setting the spreadsheet ID and ensuring a “Feedback Log” sheet exists. 5. (Optional) Enable the Gmail node and provide Gmail credentials, then set the recipient email to send the weekly digest.