Weekly Google Ads GPT Optimization Report via Gmail (n8n Workflow)

Get a weekly Google Ads optimization report emailed to you—automatically

This n8n workflow pulls campaign-level performance data from Google Ads every week, analyzes it with OpenAI (GPT-5 Mini), and sends a polished HTML optimization report via Gmail—including clear recommendations and notes when data is insufficient.

What this workflow does

• Runs weekly: Scheduled to run every Monday at 9:00 AM.
• Loads your configuration: Uses Google Ads manager/client customer IDs, a report date range, a campaign status filter, and the recipient email address.
• Fetches Google Ads metrics: Retrieves campaign-level metrics from the Google Ads API for the selected date range and status filter.
• Aggregates account totals: Converts micros to USD and calculates account-level totals such as spend, impressions, clicks, and overall CTR.
• Generates a structured report with GPT-5 Mini: Sends summarized metrics plus campaign JSON to OpenAI to produce an HTML optimization report that avoids inventing missing data.
• Sends the report by Gmail: Wraps the AI output into a branded HTML email including an account overview table and a disclaimer.

Use cases

• Agency ops teams who want consistent weekly insights across multiple Google Ads accounts.
• SaaS operators monitoring paid acquisition performance and needing clear, repeatable reporting.
• Automation engineers building Google Ads reporting that is transparent when metrics are incomplete.

Technical details

• Scheduling: n8n schedule (Mondays at 9:00 AM).
• Google Ads integration: OAuth2 credential with read access + manager/client customer IDs.
• AI analysis: OpenAI via n8n’s built-in OpenAI credits (GPT-5 Mini) to generate recommendations.
• Email delivery: Gmail OAuth2 credential to send the HTML report.
• Workflow nodes: set, code, gmail, google ads, sticky note, and n8n-nodes-langchainagent.