Automation Actions

Replaces Google Apps Script — run manually or let Vercel cron handle it

Email Triage

Read unread inbox, classify BOUNCE / REPLY / NOISE, write replies to Morning Brief, archive noise. Runs daily at 07:00 UTC via Vercel cron.

cron: 0 7 * * *

Create Today's Drafts

Read outreach queue from Supabase, dedup against sent history, create Gmail drafts for today's batch (up to 10). Runs daily at 06:00 UTC via Vercel cron.

cron: 0 6 * * *

Loading stats...

MIGRATION STATUS

✓Email triage → /api/gmail/triage + Supabase pa_emails

✓Draft creation → /api/gmail/create-drafts + Supabase outreach_queue

✓Outreach dedup → outreach_log Supabase table (replaces Google Sheets)

✓Cron schedules → vercel.json (replaces GAS ScriptApp.newTrigger)

✓Outreach queue populated — 486 rows imported from EmailQueue_*.gs files to outreach_queue table

○Gmail OAuth credentials added to Vercel env vars

✓SUPABASE_SERVICE_ROLE_KEY added to Vercel env vars

Supabase: run supabase-outreach-schema.sql to create new tables

SELECT * FROM outreach_queue LIMIT 5;

SELECT * FROM outreach_log LIMIT 5;