ExampleTemplate
Publish agendas on the website after the clerk approves
Every morning, finds upcoming meetings with a published agenda in CivicCA and asks the city clerk to approve them. Approved agendas become pages on the Sentra CMS website; nothing is published without a yes.
This flow
6 steps
StartsOn a schedule
SystemsCivicCA, Sentra CMS
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
Weekdays at 8 am
- Cron
0 8 * * 1-5(workspace time zone)
Then: Get meetings
- Cron
- 02 · Read · Get records · CivicCA
Get meetings
- Reads Meetings from CivicCA
- Only records changed since the last good run
Then: Upcoming, agenda published
- 03 · Decide · Filter
Upcoming, agenda published
- Keeps only records where
meeting_dateis after{{ $today }}andagenda_statusispublished
Then: Clerk approves
- Keeps only records where
- 04 · Decide · Wait for approval
Clerk approves
- Pauses and emails
[email protected]: “Publish {{count}} agendas to the website” - Only record IDs are kept while it waits
- On approval, the records are read again from the source
- Expires after 48 hours without an answer
Then: Shape as a web page
- Pauses and emails
- 05 · Change · Map fields
Shape as a web page
- Shapes each record into 5 fields:
title,path,type,status,body
Then: Create website page
- Shapes each record into 5 fields:
- 06 · Write · Send records · Sentra CMS
Create website page
- Creates Pages in Sentra CMS
§ Systems
Connectors used
Swap any of them for another system with the same kind of data.
Run this flow on your systems.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.