智能文章摘要器与邮件广播系统

• •OpenAI API Key
• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证

{
  "name": "智能文章摘要器与邮件广播系统",
  "nodes": [
    {
      "name": "计划触发器",
      "type": "n8n-nodes-base.cron",
      "position": [
        200,
        300
      ],
      "parameters": {
        "cronExpression": "0 9 * * *"
      },
      "typeVersion": 1
    },
    {
      "name": "获取最新文章",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        300
      ],
      "parameters": {
        "url": "https://yourwordpresssite.com/wp-json/wp/v2/posts?per_page=1",
        "responseFormat": "json"
      },
      "typeVersion": 1
    },
    {
      "name": "设置文章详情",
      "type": "n8n-nodes-base.set",
      "position": [
        600,
        300
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "title",
              "value": "={{$json[0].title.rendered}}"
            },
            {
              "name": "content",
              "value": "={{$json[0].content.rendered}}"
            },
            {
              "name": "link",
              "value": "={{$json[0].link}}"
            }
          ]
        },
        "keepOnlySet": true
      },
      "typeVersion": 2
    },
    {
      "name": "使用OpenAI生成摘要",
      "type": "n8n-nodes-base.openAi",
      "position": [
        800,
        300
      ],
      "parameters": {
        "model": "gpt-4",
        "prompt": "Summarize this blog post in 3 key points:\n\n{{$json[\"content\"]}}"
      },
      "credentials": {
        "openAiApi": "YOUR_OPENAI_CREDENTIAL"
      },
      "typeVersion": 1
    },
    {
      "name": "获取订阅者列表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1000,
        200
      ],
      "parameters": {
        "range": "Sheet1!A:A",
        "sheetId": "YOUR_SHEET_ID"
      },
      "credentials": {
        "googleSheetsOAuth2Api": "YOUR_GOOGLE_SHEETS_CREDENTIAL"
      },
      "typeVersion": 3
    },
    {
      "name": "批量分割",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1200,
        200
      ],
      "parameters": {
        "batchSize": 1
      },
      "typeVersion": 1
    },
    {
      "name": "发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1400,
        200
      ],
      "parameters": {
        "text": "Here’s a summary of the latest article:\n\n{{$node[\"Summarize with OpenAI\"].json[\"text\"]}}\n\nRead full post: {{$node[\"Set Article Details\"].json[\"link\"]}}",
        "subject": "New Summary: {{$node[\"Set Article Details\"].json[\"title\"]}}",
        "toEmail": "={{$json[\"Email\"]}}",
        "fromEmail": "you@example.com"
      },
      "credentials": {
        "smtp": "YOUR_EMAIL_CREDENTIAL"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "SplitInBatches": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Subscribers": {
      "main": [
        [
          {
            "node": "SplitInBatches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Fetch Latest Post",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Latest Post": {
      "main": [
        [
          {
            "node": "Set Article Details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Article Details": {
      "main": [
        [
          {
            "node": "Summarize with OpenAI",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Subscribers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}