ExampleTemplate
Weekly 311 summary for department heads
Every Monday at 7 am, counts last week's closed 311 requests by type and emails the summary.
This flow
5 steps
StartsOn a schedule
SystemsSentra 311
Branches0
Stored recordsNone: pass-through
§ The flow
The whole flow, as it appears on the canvas.
Scroll sideways on small screens. Colors show the kind of step: start, read, change, decide, write.
§ Step by step
What each step does.
- 01 · Start · On a schedule
Mondays at 7 am
- Mondays at 7:00 am (workspace time zone)
Then: Get 311 requests
- 02 · Read · Get records · Sentra 311
Get 311 requests
- Reads Service requests from Sentra 311
- At most 1,000 records per run
Then: Closed in the last 7 days
- 03 · Decide · Filter
Closed in the last 7 days
- Keeps only records where
statusisclosedandclosed_atis within the last N days7
Then: Count by request type
- Keeps only records where
- 04 · Change · Summarize
Count by request type
- Counts records by
category
Then: Email department heads
- Counts records by
- 05 · Act · Send email
Email department heads
- Emails
[email protected]: “311: {{count}} request types closed last week” - One summary email
- Emails
§ Systems
Connectors used
Swap any of them for another system with the same kind of data.
Sentra 311Run this flow on your systems.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.