Turn raw data into elite consultancy advice instantly. This script integrates your Google Sheets directly with OpenAI's GPT-4o-mini to analyze your campaign performance over the last 7 days.
With a single click from the custom "🚀 AI Analysis" menu, the script detects the latest data across multiple tabs—including Campaign Performance, Search Terms, and Demographics.
Pulls campaign and audience performance data, sends it to GPT-4o for analysis, and outputs actionable recommendations with visualizations to a client-facing sheet.