Set up the content approval workflow with notifications
ComingThe client reviews AI-generated ideas, filming-ready scripts, tasks and content suggestions on the dashboard, approves or requests changes, and Supabase DB webhooks send a Resend email or Slack ping to the right person.
Kit
dashboard-shell
You need
| Account | Why | Free or paid | Plan |
|---|---|---|---|
| Supabase | Postgres database, auth (dashboard logins), row level security, Realtime pulse, Edge Functions and pg_cron for every dashboard, the attribution tables, booking alerts and the Brain state. | Free tier available | Pro (25 USD/mo) for anything a client logs into. The free tier pauses a project after 7 days without traffic and caps an org at 2 active projects; a paused free project took three client dashboards offline at once (a project log). |
| Vercel | Hosts every site, funnel, dashboard and serverless API (subscribe, book, attribution, AC proxy). Runs the cron jobs declared in vercel.json. | Free tier available | Pro (20 USD/mo per seat). The Hobby plan forbids commercial use, so any client site or paid product must be on Pro. Hobby is fine for a personal portfolio. |
| Resend (transactional email) | Sends the 'a script is waiting for your approval' emails from the dashboard's Supabase edge function. | Free tier available | Free (3,000 emails a month, 100 a day) covers notifications. |
| Slack (incoming webhooks) | Client review pings from the dashboard (script approved, email needs changes) and social-post notifications. | Free | Free workspace is enough for webhooks. |
What you bring
- A client notification email or channel, when you build for clients
The steps
- Create the notify accounts and collect the ids
- Confirm the content hub schema is applied and locked
- Deploy the email function and its secrets
- Register the database webhooks
- Push a real idea and watch the ping land
- Have the client act and confirm the return ping
- Add content suggestion tiles (optional)
Get the full playbook
Part of: Get your database sorted