8
n8n 中文网amn8n.com

从 Google Sheets 生成每日销售报告,附带格式化邮件摘要

中级

这是一个CRM领域的自动化工作流,包含 12 个节点。主要使用 If, Code, EmailSend, GoogleSheets, ManualTrigger 等节点。 从 Google Sheets 生成每日销售报告,附带格式化邮件摘要

前置要求
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "zSBNXj6rphbGp4Or",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177"
  },
  "name": "每日销售报告",
  "tags": [],
  "nodes": [
    {
      "id": "4b10d0b5-5e37-404b-876c-b9131b2070d5",
      "name": "读取 Google 表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        96
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "2bcb8791-30dd-4275-8c8b-d055e1b8502d",
      "name": "检查数据是否存在",
      "type": "n8n-nodes-base.if",
      "position": [
        448,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ab1eb7f4-2184-45e3-9189-016636720a2d",
      "name": "格式化报告",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8b803b96-c46c-4f25-9eaa-927e71014f1c",
      "name": "无数据处理程序",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        192
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "bb98df11-3730-4024-815d-08b6e26b87c7",
      "name": "点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "878e2ae4-fc35-4e58-b3f7-2ddba51e8b55",
      "name": "发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        896,
        96
      ],
      "webhookId": "4891c6e7-fba9-4491-a38c-a159f17c73eb",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "c2dd97d2-0486-4627-b3f1-bbb4e57083fc",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -288
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6895ddb3-7487-48b4-81a5-c778313528f6",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "969a10c6-9fdd-4778-9365-212c2acc8677",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        -368
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1d59e50c-f0a0-473d-ab80-23bea73385f2",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        -592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a45eac5c-b94f-4390-9ec3-f016e0f08cb0",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        336
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6ec4c16a-cadd-4b7d-8c75-c03eddf69599",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "73404a1e-b59a-4939-8513-defd95852cb1",
  "connections": {
    "ab1eb7f4-2184-45e3-9189-016636720a2d": {
      "main": [
        [
          {
            "node": "878e2ae4-fc35-4e58-b3f7-2ddba51e8b55",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8b803b96-c46c-4f25-9eaa-927e71014f1c": {
      "main": [
        [
          {
            "node": "878e2ae4-fc35-4e58-b3f7-2ddba51e8b55",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2bcb8791-30dd-4275-8c8b-d055e1b8502d": {
      "main": [
        [
          {
            "node": "ab1eb7f4-2184-45e3-9189-016636720a2d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "8b803b96-c46c-4f25-9eaa-927e71014f1c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4b10d0b5-5e37-404b-876c-b9131b2070d5": {
      "main": [
        [
          {
            "node": "2bcb8791-30dd-4275-8c8b-d055e1b8502d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bb98df11-3730-4024-815d-08b6e26b87c7": {
      "main": [
        [
          {
            "node": "4b10d0b5-5e37-404b-876c-b9131b2070d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 客户关系管理

需要付费吗?

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

工作流信息
难度等级
中级
节点数量12
分类1
节点类型6
难度说明

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

作者
Rahul Joshi

Rahul Joshi

@rahul08

Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.

外部链接
在 n8n.io 查看

分享此工作流

分类

分类: 34