Send weekly Google Ads performance reports with GPT-5.1 and Gmail

Automatically analyzes your Google Ads performance every Monday and sends a comprehensive report to your inbox with AI-powered insights, week-over-week comparisons, and prioritized recommendations to optimize your campaigns. How it works Step 1: Schedule Weekly Analysis - Triggers automatically every Monday at midnight - Can be customized to your preferred schedule - Initiates the entire data collection and analysis process Step 2: Collect Performance Data - Fetches last 7 days of Google Ads data via API - Retrieves previous 7 days of data (days 8-14) for comparison - Extracts key metrics including impressions, clicks, cost, conversions, CTR, and CPA - Calculates and summarizes performance for each week - Identifies top performers, problem campaigns, and efficiency trends - Merges data to create comprehensive week-over-week comparison Step 3: AI-Powered Analysis - Aggregates all performance data into a single view - Sends data to AI Analyst powered by GPT-5.1 - AI analyzes trends, identifies insights, and spots anomalies - Diagnoses root causes of performance changes - Generates actionable, prioritized recommendations based on business impact - Calculates efficiency metrics and budget optimization opportunities Step 4: Deliver Insights Report - Formats analysis into a professional HTML report - Emails comprehensive insights directly to your inbox - Includes executive summary, week-over-week comparison tables, and color-coded metrics - Provides high/medium/low priority action items - Ready for immediate action and strategy adjustments What you'll get The workflow delivers a comprehensive weekly analysis with: - Performance Metrics: Impressions, clicks, CTR, conversions, cost, CPA, and efficiency trends - Week-over-Week Comparison: Side-by-side analysis with percentage changes and visual indicators - Top Performers Analysis: Detailed breakdown of your best-performing campaigns - Issues & Performance Risks: Identification of campaigns with high spend but zero conversions, declining CTR, or rising CPA - AI-Generated Insights: Intelligent pattern recognition and trend analysis with root cause diagnosis - Actionable Recommendations: Prioritized action items (high/medium/low) with expected impact and risk levels - Budget Efficiency Analysis: Spend allocation recommendations and wasted spend identification - Campaign Intelligence: Clear understanding of what's working and what needs attention - Data Confidence Assessment: Commentary on sample size adequacy and metric reliability - Automated Delivery: Weekly HTML report sent directly to your email without manual effort Why use this - Save time on reporting: Eliminate 2-3 hours of manual weekly analysis and report creation - Never miss insights: AI catches trends and patterns humans might overlook - Consistent monitoring: Automated weekly reviews ensure you stay on top of performance - Data-driven decisions: Make strategic adjustments based on comprehensive analysis with clear priorities - Early problem detection: Spot performance issues and wasted spend before they impact your budget - Optimize continuously: Regular insights enable ongoing campaign refinement - Focus on strategy: Spend less time analyzing data, more time implementing improvements - Scalable intelligence: Works whether you manage 1 campaign or 100 - Executive-ready reports: Professional HTML format suitable for sharing with stakeholders Setup instructions Before you start, you'll need: 1. Google Ads Account & API Access - Go to your Google Ads account at https://ads.google.com - Find your Customer ID (XXX-XXX-XXXX format in top-right corner) - Get a Developer Token from Google Ads API Center - Enable API access for your account 2. OpenAI API Key (for GPT-5.1 AI analysis) - Sign up at https://platform.openai.com - Navigate to API keys section and create a new key - Ensure you have access to GPT-5.1 model 3. Gmail Account (for receiving reports) - OAuth2 authentication will be used - No app password needed Configuration s