Weekly Circle community pulse digest in Slack

Every Monday at 8am in my local timezone, post a weekly pulse digest of my Circle community to a designated Slack channel so my community team can plan the week without manually opening Circle.

Trigger: cron, weekly on Monday at 8:00am.

Steps for the agent to run each Monday:

1. Use Circle's List Posts to pull every post created in the last 7 days (paginate until done). Capture title, author, space, created_at, comments count, likes/reactions count, and the post permalink.

2. Use Circle's List Community Members to find members whose created_at is within the last 7 days. Count them, and group them by the spaces they are most active in (cross-reference with the posts and comments pulled this week).

3. From the same posts list, identify posts older than 48 hours that still have zero comments. For borderline posts, use Circle's List Post Comments to confirm the comment count is truly zero. Treat these as the "still unanswered" bucket.

4. Use Circle's List Events to pull all events with a start time in the next 7 days. For each upcoming event, use Circle's List Event Attendees to get the current RSVP count.

5. Have the agent summarize all of the above into one scannable Monday morning brief with these sections:

• Top 3 posts of the week, ranked by a simple score of comments + likes, each with title, author, space, and the Circle permalink.

• New members this week: total count, plus the 2-3 spaces they engaged with most.

• Still unanswered after 48 hours: a short list with title, space, age, and permalink so a community manager can jump in.

• Upcoming events: title, date/time, space, and current RSVP count for each event in the next 7 days.

6. Use Slack Bot's Send a Message to post the brief to the designated Slack channel. Format it with Slack mrkdwn (bold section headers using *asterisks*, bulleted lists, and <url|text> links for every Circle permalink so titles are clickable). Keep the whole message under roughly 40 lines so it stays scannable in the channel.

If a week has zero new posts, zero new members, and zero upcoming events, still post a short message saying the community was quiet this week so the team knows the workflow ran.

Inputs I should be able to configure: the Slack channel ID or name, the lookback window in days (default 7), the unanswered threshold in hours (default 48), the number of top posts to feature (default 3), and an optional list of Circle space IDs to limit the digest to.