Weekly Hightouch sync health digest, posted to Notion and Slack

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.

Additional information

What does this prompt do?

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 do I need to use this?

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 can I 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.

Frequently asked questions

Does this replace the alerts I already get from Hightouch?

No, it complements them. Hightouch alerts tell you when a single run just failed. This digest looks across all of your syncs over the whole week, compares to the prior week, and points out which ones deserve attention right now, even if their last run was green.

What if I have hundreds of syncs?

The Slack summary stays short by design, just the top 5 with a one line reason each. The full table of every sync's weekly snapshot lives in the Notion page so you can scan, sort, or filter without flooding the channel.

Can I send the digest to more than one Slack channel?

Yes. When you set the workflow up you can pick any channel, or post to several channels at once, including private ones the bot has been added to.

Do I need a paid Notion plan?

No, this works on any Notion plan. You just need to create the connection in Notion and share the parent page with it so the weekly report can be created under it.

What time zone does the schedule run in?

The default is 9am US Eastern on Mondays, but you can change both the day and the time zone when you set it up, for example 8am London or end of day Friday.