Office tasks
Email a daily sales report every morning with Duaer
In Duaer, read yesterday's orders from Google Sheets at 9am, total amount and count per salesperson, and send one report email.
Build the daily report in Duaer
- Add Schedule Trigger: Trigger Interval Days, Trigger at Hour 9am.
- Add Google Sheets with Get Row(s) on your orders sheet. It needs Date, Rep, Amount, and Order columns, with dates like 2026-10-01.
- Add Filter: {{ $json.Date }} is equal to {{ $now.minus({ days: 1 }).toFormat("yyyy-MM-dd") }} to keep yesterday only.
- Add Summarize: under Fields to Summarize, Amount with Sum and Order with Count; Fields to Split By Rep. You get one item per rep with sum_Amount and count_Order.
- Add Aggregate with All Item Data (Into a Single List) to put every rep into one item under data.
- Add Send Email: To Email your list, Subject Sales report {{ $now.minus({ days: 1 }).toFormat("yyyy-MM-dd") }}, Text {{ $json.data.map(r => r.Rep + ": " + r.sum_Amount + ", " + r.count_Order + " orders").join("\n") }}.
- Publish the digital organization.
Common issues
- 9am became 9pm: the time zone is wrong. Refer to Fix a Duaer Schedule Trigger that runs at the wrong time.
- No orders yesterday means no Summarize output and no email. To send a no-orders note, add If after Filter.
- Data lives in Excel: swap Google Sheets for Extract from File on an uploaded or cloud file.
Questions
Can Duaer post the report to a WeCom group?
Yes. Replace Send Email at the end of the Duaer flow with the WeCom node message-push resource and the same expression.
What are the Duaer Summarize output fields called?
Duaer Summarize names them aggregation_field, such as sum_Amount and count_Order.
In this section
Run a Duaer digital organization on a schedule
In Duaer, Schedule Trigger starts a digital organization on the interval you set. It keeps that clock only after you publish. Execute on the canvas runs once now and does not wait for the clock.
NodesSummarize fields in Duaer
In Duaer, Summarize sets Aggregation (default Count) and Field under Fields to Summarize. Use Fields to Split By to group.
NodesSend mail with Send Email in Duaer
In Duaer, the node is named Send Email. Operation defaults to Send. Set From Email, To Email, and Subject. On the current version Email Format defaults to HTML.
ErrorsFix a Duaer Schedule Trigger that runs at the wrong time
When a Duaer Schedule Trigger set for 9am runs at 9pm or 12 to 13 hours off, the time zone is wrong.