Notion-Connected Agent Daily Brief

A Python script that runs at 07:00 UTC and posts a structured morning brief to a Slack channel, assembled from five live data sources: your Notion Action Items database (due today and overdue, priority-sorted), Gmail (filtered to a maximum of three signal emails), Google Calendar, a SQLite P&L query formatted as a two-column grid, and a 280-character daily perspective from each of your AI agents.

The brief is formatted as Slack Block Kit, structured and scannable.

Two Notion API issues documented that are not in the official docs: the collection ID is not the database ID (using the collection ID returns a 404), and a custom Select field named Status requires the filter type 'select', not 'status'. The wrong type returns 400 with no helpful error. Both took a full debugging session to find.

What is included: the full Python script, Notion database schema with property names, Gmail filter configuration, Slack Block Kit message templates, and cron setup instructions for Ubuntu.

Best for operators who check multiple tools every morning and want that context assembled automatically in one place.