8
n8n 中文网amn8n.com

每日名言

高级

这是一个Multimodal AI领域的自动化工作流,包含 17 个节点。主要使用 Set, Telegram, HttpRequest, GoogleSheets, ScheduleTrigger 等节点。 使用Gemini翻译向Telegram订阅者发送每日励志名言

前置要求
  • Telegram Bot Token
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • Google Gemini API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "j0LrUrmFgSDAaexJ",
  "meta": {
    "instanceId": "f5aa635d637faa7cf397adde51f1a02fdf8ac6454c1c6457738ffd11609a900c",
    "templateCredsSetupCompleted": true
  },
  "name": "每日名言",
  "tags": [],
  "nodes": [
    {
      "id": "42f0e354-1c90-4b25-a241-6bb5d59cf370",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -780,
        40
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "59bdac31-7c2a-4a4c-80cd-f3b32115afba",
      "name": "HTTP 请求",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -420,
        40
      ],
      "parameters": {
        "url": "https://zenquotes.io/api/random",
        "options": {},
        "sendBody": true,
        "bodyParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "22ecfeb7-64b8-4c5d-96a5-627ff13980b1",
      "name": "发送文本消息",
      "type": "n8n-nodes-base.telegram",
      "onError": "continueRegularOutput",
      "position": [
        480,
        60
      ],
      "webhookId": "01aea960-7674-4802-8544-132de83df905",
      "parameters": {
        "text": "=*{{ $('HTTP Request').item.json.a.replaceAll(\".\",\"\\\\.\") }}* :\n\n{{  $('Basic LLM Chain').item.json.text.replaceAll(\".\",\"\\\\.\") }}",
        "chatId": "={{ $json.registered_users }}",
        "additionalFields": {
          "parse_mode": "MarkdownV2"
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "5Ewj8UwMdWwgpZkW",
          "name": "SgsBot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "6c67841d-45b5-4bbd-894d-46b440991b7c",
      "name": "基本 LLM 链",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -180,
        40
      ],
      "parameters": {
        "text": "=First translate the following quote to {{ $('Set Language').item.json.Translate_lang }} then stickerize it using related stickers.\n\nquote:\n{{ $json.q }}\n\nJust answer in this response format without any label:\nStickerized original quote.\n\nStickerized translated quote.",
        "promptType": "define"
      },
      "typeVersion": 1.6
    },
    {
      "id": "65812674-3794-4698-9783-7da34532faa2",
      "name": "Google Gemini聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -40,
        200
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.5-flash"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "YO8IhwgT3GM8pF5N",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ec190b20-4733-49d7-8338-143f52f56d5c",
      "name": "Telegram 触发器",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -100,
        -220
      ],
      "webhookId": "85694268-e4ce-4e44-a13b-9050a6f34bc5",
      "parameters": {
        "updates": [
          "message"
        ],
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "5Ewj8UwMdWwgpZkW",
          "name": "SgsBot"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "750151d2-dc7d-4d77-85d2-f5cfdf87f207",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        100,
        -220
      ],
      "parameters": {
        "columns": {
          "value": {
            "date": "={{ $now }}",
            "registered_users": "={{ $json.message.from.id }}"
          },
          "schema": [
            {
              "id": "registered_users",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "registered_users",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "registered_users"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hQdu0dOFQACIes3RzTcIhYF4u8lCV4ybDjsoW3zqW_Y/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1hQdu0dOFQACIes3RzTcIhYF4u8lCV4ybDjsoW3zqW_Y",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hQdu0dOFQACIes3RzTcIhYF4u8lCV4ybDjsoW3zqW_Y/edit?usp=drivesdk",
          "cachedResultName": "SgsBot"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "DsRaD3Bp2iwLSu9A",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "b3f19d9d-16db-44dd-ae98-8a53e3719658",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        200,
        40
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hQdu0dOFQACIes3RzTcIhYF4u8lCV4ybDjsoW3zqW_Y/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1hQdu0dOFQACIes3RzTcIhYF4u8lCV4ybDjsoW3zqW_Y",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hQdu0dOFQACIes3RzTcIhYF4u8lCV4ybDjsoW3zqW_Y/edit?usp=drivesdk",
          "cachedResultName": "SgsBot"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "DsRaD3Bp2iwLSu9A",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "418a2e7d-c599-4cea-a963-7a580d47e9f5",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        -520
      ],
      "parameters": {
        "width": 540,
        "height": 480,
        "content": "## 📱 带 AI 翻译的每日名言机器人"
      },
      "typeVersion": 1
    },
    {
      "id": "d463226c-0660-4ce0-8944-7f8c95d1fb23",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        -20
      ],
      "parameters": {
        "color": 7,
        "width": 220,
        "height": 220,
        "content": "**每日计划:**"
      },
      "typeVersion": 1
    },
    {
      "id": "10bb45d1-3d94-4bda-8b4a-bdacdc29979d",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -20
      ],
      "parameters": {
        "color": 7,
        "width": 300,
        "height": 220,
        "content": "**名言获取**"
      },
      "typeVersion": 1
    },
    {
      "id": "4d0860f4-c737-4025-9986-56acfbf787a9",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        -20
      ],
      "parameters": {
        "color": 7,
        "width": 320,
        "height": 220,
        "content": "**AI 处理:**"
      },
      "typeVersion": 1
    },
    {
      "id": "1a333d70-5d18-4951-bed5-26ed3dad214a",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        -20
      ],
      "parameters": {
        "color": 7,
        "width": 280,
        "height": 220,
        "content": "**订阅者管理:**"
      },
      "typeVersion": 1
    },
    {
      "id": "faf66c97-1fd5-4314-9f8e-654760ab84d5",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        -20
      ],
      "parameters": {
        "color": 7,
        "width": 300,
        "height": 220,
        "content": "**消息传递:**"
      },
      "typeVersion": 1
    },
    {
      "id": "15f58c31-6ba9-4e72-93dc-5aec988dd008",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -120,
        -280
      ],
      "parameters": {
        "color": 7,
        "width": 580,
        "height": 220,
        "content": "**用户注册:**"
      },
      "typeVersion": 1
    },
    {
      "id": "53e86eb7-655b-4767-9b0f-733f7e648f04",
      "name": "设置语言",
      "type": "n8n-nodes-base.set",
      "position": [
        -620,
        40
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c3d7e921-5fd3-43e7-807f-e527dcfd4403",
              "name": "Translate_lang",
              "type": "string",
              "value": "Persian"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "abfab320-2c39-4cfe-a2fb-43e816691d5a",
      "name": "Telegram",
      "type": "n8n-nodes-base.telegram",
      "notes": "Send welcome message",
      "position": [
        260,
        -220
      ],
      "webhookId": "76c56480-5f36-4d32-80bb-746b40a27fcd",
      "parameters": {
        "text": "=👋 Welcome,\nI will send you daily quote.",
        "chatId": "={{ $('Telegram Trigger').item.json.message.from.id }}",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "5Ewj8UwMdWwgpZkW",
          "name": "SgsBot"
        }
      },
      "notesInFlow": true,
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "96d98ab4-f035-4d0e-8c91-d5fdc43c308b",
  "connections": {
    "Telegram": {
      "main": [
        []
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Language": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Set Language",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 多模态 AI

需要付费吗?

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

工作流信息
难度等级
高级
节点数量17
分类1
节点类型9
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Shohani

Shohani

@shohani

Software Developer Since 2004

外部链接
在 n8n.io 查看

分享此工作流