自动化（真实）用例#
¥Automating a (Real-world) Use Case
会议 Nathan 🙋Nathan 在 ABCorp 担任分析经理。他的工作是为 ABCorp 团队提供报告和分析支持。他可谓是多面手，还负责处理其他一些杂项工作。
¥Meet Nathan 🙋. Nathan works as an Analytics Manager at ABCorp. His job is to support the ABCorp team with reporting and analytics. Being a true jack of all trades, he also handles several miscellaneous initiatives.
Nathan 做的一些事情重复且令人厌烦。他希望自动化其中一些任务，以免过度劳累。作为自动化专家，你今天将与 Nathan 会面，帮助他了解如何将部分职责转移给 n8n。
¥Some things that Nathan does are repetitive and mind-numbing. He wants to automate some of these tasks so that he doesn't burn out. As an Automation Expert, you are meeting with Nathan today to help him understand how he can offload some of his responsibilities to n8n.
了解场景#
¥Understanding the scenario
你 👩🔧：很高兴认识你，Nathan。很高兴能做这件事！你最想优先处理哪些重复性且容易出错的任务？
¥You 👩🔧: Nice to meet you, Nathan. Glad to be doing this! What's a repetitive task that's error-prone and that you'd like to get off your plate first?
Nathan 🙋：感谢你的光临！最烦人的莫过于每周的销售报告了。
¥Nathan 🙋: Thanks for coming in! The most annoying one's gotta be the weekly sales reporting.
我需要从我们遗留的数据仓库中收集销售数据，该数据仓库管理着组织主要业务流程（例如销售或生产）的数据。现在，每个销售订单都可以有“处理中”或“已预订”状态。我需要计算所有已预订订单的总和，并在每周一在公司 Discord 上公布。然后我需要创建一个包含所有正在处理销售信息的电子表格，以便销售经理可以查看并检查是否需要跟进客户。
¥I have to collect sales data from our legacy data warehouse, which manages data from the main business processes of an organization, such as sales or production. Now, each sales order can have the status Processing or Booked. I have to calculate the sum of all the Booked orders and announce them in the company Discord every Monday. Then I have to create a spreadsheet of all the Processing sales so that the Sales Managers can review them and check if they need to follow up with customers.
这项手动工作很繁琐，需要高度注重细节，以确保所有数字都正确无误。不可避免地，我会走神，输错数字，或者没能按时完成。我的经理曾经批评我数据计算错误。
¥This manual work is tough and requires high attention to detail to make sure that all the numbers are right. Inevitably, I lose my focus and mistype a number or I don't get it done on time. I've been criticized once by my manager for miscalculating the data.
你 👩🔧：糟糕！数据仓库没有导出数据的方法吗？
¥You 👩🔧: Oh no! Doesn't the data warehouse have a way to export the data?
Nathan 🙋：数据仓库是公司内部很久以前编写的。它没有 CSV 导出功能，但他们最近添加了一些 API 端点来公开此数据，希望这能有所帮助。
¥Nathan 🙋: The data warehouse was written in-house ages ago. It doesn't have a CSV export but they recently added a couple of API endpoints that expose this data, if that helps.
你 👩🔧：完美！好的开始。如果你有一个通用 API，我们可以添加一些自定义代码和几个服务来创建自动化工作流程。这项任务处处体现了 n8n 的精髓。开始吧！
¥You 👩🔧: Perfect! That's a good start. If you have a generic API, we can add some custom code and a couple of services to make an automated workflow. This gig has n8n written all over it. Let's get started!