8
n8n 中文网amn8n.com

将Hotmart事件保存到Google Sheets

中级

这是一个Other领域的自动化工作流,包含 11 个节点。主要使用 Set, Switch, Webhook, DateTime, GoogleSheets 等节点。 将Hotmart事件保存到Google Sheets

前置要求
  • HTTP Webhook 端点(n8n 会自动生成)
  • Google Sheets API 凭证

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "nodes": [
    {
      "id": "f3d411bd-3451-4150-ac3d-917680a7b520",
      "name": "转换时间戳",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        1760,
        560
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2
    },
    {
      "id": "7d43d464-521f-472a-baf5-68398c02a1b8",
      "name": "分支",
      "type": "n8n-nodes-base.switch",
      "notes": "- PURCHASE_PROTEST é a primeira notificação sobre pedido de reembolso;\n- SUBSCRIPTION_CANCELLATION acontece junto com o purchase_protest, quando o cliente pede reembolso dentro do período da garantia;\n- PURCHASE_REFUNDED só acontece quando ocorre o reembolso de fato;\n\n- PURCHASE_COMPLETE significa que acabou o período de garantia e o dinheiro já pertence ao vendedor;\n",
      "position": [
        1300,
        480
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "9a5d6fa2-a3b2-4b31-b571-e89eb4adcfa9",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        -100
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0556e91b-1d39-4a8b-a01a-e0a197769d64",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        280
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e6e4eceb-f0b8-4249-8a67-fd3778592b93",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1660,
        180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "561163ec-bb92-4ba9-8535-79616707e321",
      "name": "保存执行数据",
      "type": "n8n-nodes-base.executionData",
      "position": [
        1300,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9e46c093-b97d-459f-bcd0-fa88f89be573",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        -100
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9453b331-89c5-40e3-a635-0ddd26589d72",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        1100,
        560
      ],
      "webhookId": "439a86fe-819c-4516-9ebf-54e779b560c3",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "75fbebfc-a5d5-4d23-a2b4-f00ceb20f360",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2300,
        560
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "a6cd632c-783e-4808-9e6c-2235bfa1d3b8",
      "name": "设置一些数据",
      "type": "n8n-nodes-base.set",
      "position": [
        2040,
        560
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "364118a0-03ee-41ba-8f33-901ef25dea6a",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2240,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Switch": {
      "main": [
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert timestamp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          },
          {
            "node": "Save execution data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set some data": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert timestamp": {
      "main": [
        [
          {
            "node": "Set some data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 其他

需要付费吗?

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

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

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

作者
Solomon

Solomon

@solomon

Freelance consultant from Brazil, specializing in automations and data analysis. I work with select clients, addressing their toughest projects. For business inquiries, email me at automations.solomon@gmail.com or message me on Telegram for a faster response.

外部链接
在 n8n.io 查看

分享此工作流