Weekly Hightouch sync health digest in Notion and Slack

By General Input

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

Agentic Task

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.

Related prompts

Explore more prompts
A brand asset library your marketing team actually searchesTurn Mailjet email clicks into ranked HubSpot follow-upsClean out the Looker dashboards and Looks nobody opensLiveKit live operations console for room moderationWake up dormant Keap leads with a researched reasonLiveChat coverage board for planning next week's shiftsPhone routing control panel for LiveKit voice agentsLinkedIn Ads budget pacing dashboard for every client accountGive your team Looker numbers without buying more seatsPause marketing emails to escalated customers, then restore them