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:

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

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

Gmail Account (for receiving reports) OAuth2 authentication will be used No app password needed

Configuration steps:

Replace Google Ads Customer ID: Open both "Get Last Week Data" and "Get Previous Week Data" HTTP Request nodes In the URL field, replace [Customer ID] with your actual Customer ID (format: XXX-XXX-XXXX)

Add Developer Token: In both HTTP Request nodes, add your Google Ads Developer Token to the header parameters

Connect Google Ads OAuth2: In both HTTP Request nodes, authenticate with your Google Ads credentials Select your ad account

Connect OpenAI credentials: In the "OpenAI Chat Model" node, add your OpenAI API key Verify GPT-5.1 model is selected

Configure email delivery: In the "Email Report to User" node, connect your Gmail OAuth2 credentials Update the recipient email address (default: lee@sonalabs.com) Customize subject line if desired

Set your schedule (optional): In the "Weekly Trigger" node, configure your preferred day and time Default is Monday at midnight

Test the workflow: Click "Execute Workflow" to run manually Verify data pulls correctly from Google Ads Check that AI analysis provides meaningful insights Confirm email report arrives formatted correctly

Customize analysis focus (optional): Open the "AI Analyst" node Adjust the prompt to prioritize specific metrics or goals for your business Modify thresholds for "problem campaigns" in the calculation nodes

Activate automation: Enable the workflow to run automatically every Monday Monitor the first few reports to ensure accuracy

Note: The workflow analyzes the last 7 days vs. the previous 7 days, giving you rolling two-week comparisons every Monday. Adjust the date ranges in the HTTP Request nodes if you need different time periods.