8
n8n 中文网amn8n.com

TradingView 信号提取器

中级

这是一个Finance领域的自动化工作流，包含 15 个节点。主要使用 If, Code, Gmail, DateTime, Telegram 等节点。 TradingView 信号提取器，支持 Gmail、Google Sheets 和 Telegram 通知

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Telegram Bot Token
  • •Google Sheets API 凭证

使用的节点 (15)

If
Code
Gmail
DateTime
Telegram
StickyNote
GmailTrigger
GoogleSheets

分类

财务
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "761a3dddae2bb21eb8973ffca0ba97d5b4f499405873760164a536f547546882",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "a5f53559-6b91-45a9-8822-53439b9c306d",
      "name": "清理邮件",
      "type": "n8n-nodes-base.code",
      "position": [
        -160,
        180
      ],
      "parameters": {
        "jsCode": "// Make sure From exists and is a string\nconst rawFrom = $input.first().json.From;\n\nlet cleanEmail = \"\";\n\n// Proceed only if rawFrom is a valid string\nif (typeof rawFrom === \"string\" && rawFrom.trim() !== \"\") {\n  const match = rawFrom.match(/<(.+?)>/);\n  cleanEmail = match ? match[1] : rawFrom.trim();\n} else {\n  cleanEmail = \"[Missing From field]\";\n}\n\nreturn [\n  {\n    json: {\n      cleanEmail\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "e6a332b0-529d-489c-9d67-8d7d06bc8044",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -160,
        -20
      ],
      "webhookId": "0c25cbb3-b954-4c3a-aabc-9f4473b9f733",
      "parameters": {
        "messageId": "={{ $json.id }}",
        "operation": "markAsRead"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "6I8sq2IhPgySI6XX",
          "name": "Gmail account 2 - infodpatel15"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "032629d7-d41b-4d8f-b545-e98df9cf796c",
      "name": "发送消息",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1380,
        180
      ],
      "webhookId": "836270b1-beef-4520-b024-30b72af1582a",
      "parameters": {
        "text": "=KITE 11: {{ $('Get Email').item.json.snippet }}",
        "chatId": "1520681602",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "bAaBU3SFXiLAdyvU",
          "name": "Telegram account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "f7e47b44-5ea8-43fa-9054-539e710d3a39",
      "name": "验证邮件",
      "type": "n8n-nodes-base.if",
      "position": [
        60,
        180
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "7f6c2c11-6204-4f36-8e57-dcc9efc93433",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.cleanEmail }}",
              "rightValue": "=noreply@tradingview.com"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "66b91b39-49f7-44cc-8d9a-f4392c11ff77",
      "name": "提取公司名称",
      "type": "n8n-nodes-base.code",
      "position": [
        500,
        180
      ],
      "parameters": {
        "jsCode": "// Get subject from previous node (e.g., IMAP Email node)\nconst subject = $input.first().json.Subject;\n\nconst stockSymbol = subject.split('for ')[1]?.trim() || '';\n\nreturn [\n  {\n    json: {\n      symbol: stockSymbol,\n      originalSubject: subject,\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "ffbbff24-1959-4254-b05c-4a6327edec95",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1160,
        180
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $json.formattedDate }}",
            "Stock": "={{ $('Extract Company Name').item.json.symbol }}"
          },
          "schema": [
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Stock",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Stock",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1PBvePZN2yvVg23hDIDB62e91ogTgbuNXVduZTai-bZc/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1PBvePZN2yvVg23hDIDB62e91ogTgbuNXVduZTai-bZc",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1PBvePZN2yvVg23hDIDB62e91ogTgbuNXVduZTai-bZc/edit?usp=drivesdk",
          "cachedResultName": "KITE FINAL 11"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "9NecV5qrcx7kjh5f",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "dde99d76-79fe-4650-b7a2-948047b62a16",
      "name": "当前日期和时间",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        720,
        180
      ],
      "parameters": {
        "options": {
          "timezone": "Asia/kolkata"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "7a60d22e-8027-423c-9927-aa2e0759744d",
      "name": "格式化日期和时间",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        940,
        180
      ],
      "parameters": {
        "date": "={{ $json.currentDate }}",
        "format": "custom",
        "options": {},
        "operation": "formatDate",
        "customFormat": "DD"
      },
      "typeVersion": 2
    },
    {
      "id": "288dec30-51c9-4206-a0d8-5bca9317ec57",
      "name": "获取邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        300,
        180
      ],
      "webhookId": "1fd0763d-5989-4fc4-aa5f-191eb8ee51bc",
      "parameters": {
        "messageId": "={{ $('Email Received').item.json.id }}",
        "operation": "get"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "6I8sq2IhPgySI6XX",
          "name": "Gmail account 2 - infodpatel15"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "20ac9cda-60e1-4a52-a41d-e83485f2c76f",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -80
      ],
      "parameters": {
        "color": 7,
        "width": 380,
        "height": 400,
        "content": "## 读取邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "9a8cae5e-9601-4500-bde6-8a84837fc378",
      "name": "邮件已接收",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -380,
        80
      ],
      "parameters": {
        "filters": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "6I8sq2IhPgySI6XX",
          "name": "Gmail account 2 - infodpatel15"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ff7bbb0d-29a1-458d-8437-089fb0bb4ef4",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        120
      ],
      "parameters": {
        "color": 7,
        "width": 180,
        "height": 200,
        "content": "## 识别邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "70ed236c-3d55-48ec-884c-8bf707139f61",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        80
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 260,
        "content": "## 获取邮件数据 - 提取买入或卖出信号"
      },
      "typeVersion": 1
    },
    {
      "id": "a86e1c5f-9059-4971-835c-3e39dc176a3e",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        660,
        120
      ],
      "parameters": {
        "color": 7,
        "width": 440,
        "height": 220,
        "content": "## 获取当前日期和时间"
      },
      "typeVersion": 1
    },
    {
      "id": "84d9bbe3-ebe6-4edb-b02b-f37c3dfdabdf",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1120,
        120
      ],
      "parameters": {
        "color": 7,
        "width": 420,
        "height": 220,
        "content": "## 更新表格数据并通知"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Get Email": {
      "main": [
        [
          {
            "node": "Extract Company Name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean Email": {
      "main": [
        [
          {
            "node": "Verify Mail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Verify Mail": {
      "main": [
        [
          {
            "node": "Get Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Message": {
      "main": [
        []
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Send Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Received": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          },
          {
            "node": "Clean Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Current Date & Time": {
      "main": [
        [
          {
            "node": "Formatted Date & Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Company Name": {
      "main": [
        [
          {
            "node": "Current Date & Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Formatted Date & Time": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 财务

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

发票处理与验证 - n8n 模板
基于Gmail、Drive、表格和OCR AI的发票验证与确认
If
Set
Code
+13
47 节点Dhrumil Patel
财务
基于OCR、AI和Google表格的发票处理与验证器
基于OCR、AI和Google表格的发票处理与验证器
If
Set
Code
+8
22 节点Dhrumil Patel
财务
使用Gmail、GPT-4和向量知识库的自动化客户支持系统
使用Gmail、GPT-4和向量知识库的自动化客户支持系统
If
Set
Code
+15
32 节点Khair Ahammed
AI RAG 检索增强
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
AAVE投资组合专业AI助手
Telegram + 邮件 + GPT-4o + Moralis
Set
Code
Gmail
+7
23 节点Don Jayamaha Jr
财务
智能资金管理器
基于Telegram、Google Sheets和OpenAI的AI驱动收据和支出追踪器
If
Set
Code
+13
50 节点Khairul Muhtadin
财务
工作流信息
难度等级
中级
节点数量15
分类1
节点类型8
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Dhrumil Patel

Dhrumil Patel

@itechdp

🚀 Automation Enthusiast | n8n Creator | SaaS & AI Innovator. I'm Dhrumil Patel, founder of SentIIMenta AI. I build smart solutions using n8n to automate workflows, connect data, and boost efficiency. Passionate about AI, SaaS, and no-code tools. Let’s simplify work and create impact together! 🌐 https://sentiimenta-ai.com | 📩 founder@sentiimenta-ai.com

外部链接
在 n8n.io 查看 →

分享此工作流