Weekly Hightouch sync health digest in Notion and Slack
Every Monday at 9am ET, see which Hightouch syncs need attention this week, with a full Notion writeup and a quick Slack summary.
Integrations
Hightouch
Notion
Slack Bot
Type
Categories
- Operations
Build me an agent workflow that runs every Monday at 9am US Eastern and produces a Hightouch sync health digest for the past week. The point is to tell me which syncs deserve attention this week, not just whether the last run was green.
First, call Hightouch's List Syncs to get every sync in my workspace. Then for each sync call List Sync Runs filtered to the trailing 7 days. For each sync, aggregate: success rate, total rejected rows, average run duration, last failure timestamp, and a simple trend versus the prior 7 days (improving, stable, or degrading).
Then reason across all syncs and pick the top 5 that warrant action this week. Good signals: high rejection rate, repeated failures, runaway duration growth, sudden degradation versus last week. Write a one to two sentence justification for each pick that points at the specific stat driving the call.
Output 1: use Notion's Create a Page to create a page in our data team's workspace titled 'Hightouch sync health: week of {date}'. The page should contain the prioritized top 5 with their stats and the agent's justification, followed by a full table of every sync's weekly snapshot (sync name, destination, success rate, rejected rows, average duration, last failure, trend).
Output 2: use Slack's Send a Message to post a 4 to 6 line summary in #data-ops. It should name the top 5 problem syncs, give a one line headline for each, and link to the Notion page. Keep the Slack message scannable. Full detail lives in Notion.
Use the Slack bot integration to post (not a personal Slack account) so the digest keeps working even if a specific person leaves the team. The Hightouch API key only needs read access to syncs and sync runs. The Notion connection needs to be shared with the parent page where the weekly report is created.
What it does
- Reviews the past week of every Hightouch sync, including success rate, rejected rows, average run duration, and the last failure.
- Compares this week to the previous week and flags whether each sync is improving, stable, or degrading.
- Picks the top 5 syncs that deserve attention this week and writes a short reason for each.
- Publishes a full report to Notion and posts a scannable summary in your data ops Slack channel with a link to the page.
What you’ll need
- A Hightouch workspace with admin access so you can create a read-only API key.
- A Notion workspace and a parent page where the weekly report can live.
- A Slack workspace with a channel for the summary, for example #data-ops.
How to customize it
- Change the schedule, for example Friday afternoon instead of Monday morning, or move the time zone off Eastern.
- Pick a different Slack channel, post to several channels, or send the summary to a DM instead.
- Adjust how many syncs make the priority list (top 3, top 10) or change what counts as 'needs attention', like a stricter rejection rate threshold.
Use cases
- Daily Digests
- AI Reports