Qualify replies from Pipedrive persons with AI
Workflow JSON
{"meta": {"instanceId": "0bd9e607aabfd58640f9f5a370e768a7755e93315179f5bcc6d1f8f114b3567a"}, "nodes": [{"id": "97b36168-7fa8-4a97-a6cc-c42496918c4c", "name": "Search Person in CRM", "type": "n8n-nodes-base.pipedrive", "position": [-880, 400], "parameters": {"term": "={{ $json.from.value[0].address }}", "limit": 1, "resource": "person", "operation": "search", "additionalFields": {"includeFields": ""}}, "credentials": {"pipedriveApi": {"id": "", "name": "[Your pipedriveApi]"}}, "typeVersion": 1}, {"id": "2a17582b-9375-4a01-87d9-a50f573b83db", "name": "In campaign?", "type": "n8n-nodes-base.if", "position": [-420, 400], "parameters": {"conditions": {"string": [{"value1": "={{ $json.in_campaign }}", "value2": "True"}]}}, "typeVersion": 1}, {"id": "2a8d509f-8ac2-4f45-a905-f34552833381", "name": "Get person from CRM", "type": "n8n-nodes-base.pipedrive", "position": [-640, 400], "parameters": {"personId": "={{ $json.id }}", "resource": "person", "operation": "get", "resolveProperties": true}, "credentials": {"pipedriveApi": {"id": "", "name": "[Your pipedriveApi]"}}, "typeVersion": 1}, {"id": "b9c6f3d3-1a6d-4144-8e77-3a3c6e5282d8", "name": "Is interested?", "type": "n8n-nodes-base.openAi", "position": [-180, 380], "parameters": {"model": "gpt-4", "prompt": {"messages": [{"content": "=You are the best sales development representative in the world. You send cold email messages daily to CEOs and founders of companies. You do this to persuade them to make contact. This could be a phone call or a video meeting. \n\nYour task is to assess whether someone is interested in meeting up or calling sometime. You do this by attentively evaluating their response.\n\nThis is the email:\n{{ $('Get email').item.json.text }}\n\nThe response format should be:\n{\"interested\": [yes/no],\n\"reason\": reason\n}\n\nJSON:"}]}, "options": {}, "resource": "chat"}, "credentials": {"openAiApi": {"id": "", "name": "[Your openAiApi]"}}, "typeVersion": 1}, {"id": "f1eb438d-f002-4082-8481-51565df13f5c", "name": "Get email", "type": "n8n-nodes-base.set", "position": [-1100, 400], "parameters": {"fields": {"values": [{"name": "email", "stringValue": "={{ $json.text }}"}]}, "options": {}}, "typeVersion": 3.2}, {"id": "78461c36-ba54-4f0f-a38e-183bfafa576c", "name": "Create deal in CRM", "type": "n8n-nodes-base.pipedrive", "position": [460, 360], "parameters": {"title": "={{ $('Get person from CRM').item.json.Name }} Deal", "additionalFields": {}}, "credentials": {"pipedriveApi": {"id": "", "name": "[Your pipedriveApi]"}}, "typeVersion": 1}, {"id": "efe07661-9afc-4184-b558-e1f547b6721f", "name": "IF interested", "type": "n8n-nodes-base.if", "position": [240, 380], "parameters": {"conditions": {"string": [{"value1": "={{ $json.interested }}", "value2": "yes"}]}}, "typeVersion": 1}, {"id": "7c2b7b59-9d68-4d8c-9b9f-a36ea47526c9", "name": "Get response", "type": "n8n-nodes-base.code", "position": [20, 380], "parameters": {"mode": "runOnceForEachItem", "jsCode": "let interested = JSON.parse($json[\"message\"][\"content\"]).interested\nlet reason = JSON.parse($json[\"message\"][\"content\"]).reason\n\nreturn {json:{\n interested: interested,\n reason: reason\n}}"}, "typeVersion": 1}, {"id": "53f51f8c-5995-4bcd-a038-3018834942e6", "name": "Email box 1", "type": "n8n-nodes-base.gmailTrigger", "position": [-1300, 400], "parameters": {"simple": false, "filters": {"labelIds": []}, "options": {}, "pollTimes": {"item": [{"mode": "everyMinute"}]}}, "typeVersion": 1}, {"id": "bb1254ec-676a-4edc-bf4a-a1c66bac78bb", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-1880, 360], "parameters": {"width": 452.37174177689576, "height": 462.1804790107177, "content": "## About the workflow\nThe workflow reads every reply that is received from a cold email campaign and qualifies if the lead is interested in a meeting. If the lead is interested, a deal is made in pipedrive. You can add as many email inboxes as you need!\n\n## Setup:\n- Add credentials to the Gmail, OpenAI and Pipedrive Nodes.\n- Add a in_campaign field in Pipedrive for persons. In Pipedrive click on your credentials at the top right, go to company settings > Data fields > Person and click on add custom field. Single option [TRUE/FALSE].\n- If you have only one email inbox, you can delete one of the Gmail nodes.\n- If you have more than two email inboxes, you can duplicate a Gmail node as many times as you like. Just connect it to the Get email node, and you are good to go!\n- In the Gmail inbox nodes, select Inbox under label names and uncheck Simplify."}, "typeVersion": 1}, {"id": "c1aaee97-11f4-4e9d-9a71-90ca3f5773a9", "name": "Email box 2", "type": "n8n-nodes-base.gmailTrigger", "position": [-1300, 600], "parameters": {"simple": false, "filters": {"labelIds": []}, "options": {}, "pollTimes": {"item": [{"mode": "everyMinute"}]}}, "typeVersion": 1}], "pinData": {}, "connections": {"Get email": {"main": [[{"node": "Search Person in CRM", "type": "main", "index": 0}]]}, "Email box 1": {"main": [[{"node": "Get email", "type": "main", "index": 0}]]}, "Email box 2": {"main": [[{"node": "Get email", "type": "main", "index": 0}]]}, "Get response": {"main": [[{"node": "IF interested", "type": "main", "index": 0}]]}, "In campaign?": {"main": [[{"node": "Is interested?", "type": "main", "index": 0}]]}, "IF interested": {"main": [[{"node": "Create deal in CRM", "type": "main", "index": 0}]]}, "Is interested?": {"main": [[{"node": "Get response", "type": "main", "index": 0}]]}, "Get person from CRM": {"main": [[{"node": "In campaign?", "type": "main", "index": 0}]]}, "Search Person in CRM": {"main": [[{"node": "Get person from CRM", "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
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.
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.
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.