Most Common Tasks
TASK 01

REVIEW SPEAKING INQUIRY

New inquiry comes in → you get an email → go here to accept or decline.

  • Open Admin → Speaking Inquiries
  • Review the submission details
  • Click Accept or Decline
  • Accept: triggers rider email to Catherine
  • Decline: logs decision, no email sent
Go → Speaking Admin
TASK 02

ADD CONTENT TO THE HUB

Sermon clip, YouTube video, article — add it to Notion and it syncs automatically.

  • Open Notion → LDW Brand Site → Content Hub DB
  • Add a new row with title, type, URL, date
  • Sync fires every 15 min (or trigger manually)
  • Appears on site_content_hub table in Supabase
Go → Notion Guide
TASK 03

TRIGGER CONTENT SYNC

Force an immediate sync of photos and content from Notion to the site.

  • Click the URL below or bookmark it
  • Expected response: success: true, version: 20
  • Syncs: photos, content hub, YouTube
sync-notion-content
TASK 04

UPDATE NEWSLETTER SUBSCRIBERS

Review who signed up, check for lead magnet downloads, and see AC sync status.

  • Open Admin → Newsletter
  • Filter by source: newsletter vs. consulting_lead_magnet
  • All subs auto-sync to AC List 3
  • AC dashboard shows open rates and delivery
Go → Newsletter Admin
Key URLs — Bookmark These

These URLs are for internal use only. Do not share publicly — they trigger live syncs and admin operations.

https://riqdcirsmckubkdfbtoj.supabase.co/functions/v1/sync-notion-content?token=ldw-sync-2026-secure
↑ Manual content sync — photos, YouTube, content hub
https://ldw988.activehosted.com
↑ ActiveCampaign dashboard — email sequences, list management
https://cal.com/lonnell-ldw.build/discovery
↑ Discovery call booking link — use in speaking email responses
Quick Reference — What Lives Where
Speaking inquiriesSupabase speaking_inquiries → Admin portal → AC sequence fires automatically
Consulting inquiriesSupabase consulting_inquiries → Admin portal → AC sync live
Newsletter subsSupabase newsletter_subscribers → AC List 3 → Welcome sequence
Site photosNotion Photo Gallery DB → sync every 15 min → Supabase site_photos
Articles / SubstackPublish on Substack → RSS proxy edge function auto-fetches → articles.html updates live
YouTubePublish on YouTube → sync every 15 min → Supabase site_youtube
InstagramPost on Instagram → Zapier fires → Supabase site_instagram
Automation Status
Speaking inquiry sequence LIVE   3 emails · fires within 5 min · trigger: tag speaking-inquiry
Welcome sequence BUILD IN AC   5 emails · trigger: added to List 3 · copy ready
Consulting inquiry sync LIVE   Syncs to AC + Resend notification on form submit
Infrastructure Audit sequence NOT BUILT   5 emails · trigger: tag infrastructure-audit-download
Content sync (Notion → site) LIVE   Cron every 15 min via sync-notion-content v20