Daily CompanyCam jobsite photo recap in Slack

Every weekday at 5pm local time, roll up today's CompanyCam jobsite activity into a single narrative recap and post it to a Slack channel so office staff can see what happened on site without opening the app.

Start by calling CompanyCam List Projects with a modified_since filter set to the start of today in the org's local timezone (ISO8601). That returns every project that had any activity today, most recent first. Paginate until the response comes back short or empty.

For each project, call CompanyCam List Project Photos and keep only photos captured today (using the photo's captured_at). Skip any project that ends up with zero new photos — do not include it in the digest at all.

For photos that look meaningful (a caption present, a comment count above zero, or a notable tag such as before, after, damage, punchlist, or completion), call CompanyCam List Photo Comments to pull the crew comments. Use those captions and comments as context when drafting the narrative — a note like "roof deck ready for shingles" should shape what the recap says.

For each qualifying project, write a short narrative recap (roughly 2-4 sentences): what got done today, any notable tags, and which crew member captured the most photos (by counting photos per creator_id / creator_name). Keep the tone factual and specific — refer to real captions or comments where they add color.

Combine everything into a single Slack message. Each project gets its own section with the project name as a bold header, the narrative, and a direct link back to the project in CompanyCam (https://app.companycam.com/projects/<project_id>). Cap the whole digest at a reasonable length — target under about 3000 characters. If there are too many projects to fit, keep the ones with the most photos or the most notable tags and mention the count of any that were trimmed.

Post the finished digest as one message using Slack Send a Message to the configured channel. Do not post anything if every project was skipped for zero new photos — send a single line saying "No jobsite activity logged today" instead, so office staff know the workflow ran and it was a quiet day, not a broken automation.