Stand up an Airtable base fed by GA4, ad spend, email and CRM, a Claude prompt that answers natural-language questions about it, and a Slack slash command so any teammate can ask 'what's our blended CAC by channel this month' and get a chart back. Full hour-by-hour build, with the prompt, the schema, and the four gotchas that will eat your weekend if you skip them.
The actual Make.com scenario I have run every Monday for 11 months across 6 competitor accounts — pulls Meta Ad Library, sends creatives to Gemini 2.5 Flash, classifies hook style / format / offer type, writes structured rows into Airtable. Module-by-module, the exact Gemini prompt, the $0.012-per-run cost, and the three things that broke in month one.
