Get Started
Back to Templates

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

Created by

Created by: Sona Labs || sona

Sona Labs

Last update

Last update a day ago

Categories

Share

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)

  3. Gmail Account (for receiving reports)

    • OAuth2 authentication will be used
    • No app password needed

Configuration steps:

  1. 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)

  2. Add Developer Token:

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

  3. Connect Google Ads OAuth2:

    • In both HTTP Request nodes, authenticate with your Google Ads credentials
    • Select your ad account

  4. Connect OpenAI credentials:

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

  5. Configure email delivery:

    • In the "Email Report to User" node, connect your Gmail OAuth2 credentials
    • Update the recipient email address (default: [email protected])
    • Customize subject line if desired

  6. Set your schedule (optional):

    • In the "Weekly Trigger" node, configure your preferred day and time
    • Default is Monday at midnight

  7. 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

  8. 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

  9. 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.