设计工作流#
¥Designing the Workflow
既然我们知道了 Nathan 想要自动化什么，接下来让我们看看他需要采取哪些步骤来实现目标：
¥Now that we know what Nathan wants to automate, let's consider the steps he needs to take to achieve his goals:
- 从数据仓库获取相关数据（订单 ID、订单状态、订单金额、员工名称）
¥Get the relevant data (order id, order status, order value, employee name) from the data warehouse 2. 按状态（处理中或已预订）筛选订单。
¥Filter the orders by their status (Processing or Booked) 3. 计算所有已预订订单的总价值。
¥Calculate the total value of all the Booked orders 4. 在公司 Discord 通道中通知团队成员已预订订单。
¥Notify the team members about the Booked orders in the company's Discord channel 5. 在 Airtable 中插入有关处理订单的详细信息，以便后续跟进
¥Insert the details about the Processing orders in Airtable for follow-up 6. 安排此工作流每周一早上运行
¥Schedule this workflow to run every Monday morning
Nathan 的工作流涉及将数据从公司的数据仓库发送到两个外部服务：
¥Nathan's workflow involves sending data from the company's data warehouse to two external services:
-
Discord
-
Airtable
在此之前，必须使用通用函数（条件过滤、计算、调度）处理数据。
¥Before that, the data has to be wrangled with general functions (conditional filtering, calculation, scheduling).
n8n 为所有这些步骤都提供了集成，因此 Nathan 在 n8n 中的工作流程如下所示：
¥n8n provides integrations for all these steps, so Nathan's workflow in n8n would look like this:
Workflow preview placeholder.
你将分八个步骤构建此工作流：
¥You will build this workflow in eight steps:
¥Getting data from the data warehouse 2. 正在将数据插入 Airtable
¥Inserting data into Airtable 3. 筛选顺序
¥Setting values for processing orders 5. 计算已预订订单
¥Calculating booked orders 6. 通知团队
¥Scheduling the workflow 8. 激活和检查工作流程
¥Activating and examining the workflow
要构建此工作流，你需要注册此课程时从 n8n 收到的电子邮件中的凭据。如果你尚未注册，请执行 此处。如果你在注册后没有收到确认电子邮件，请检查 联系我们。
¥To build this workflow, you will need the credentials found in the email you received from n8n when you signed up for this course. If you haven't signed up already, you can do it here. If you haven't received a confirmation email after signing up, contact us.
开始构建！ .md-button }