BAX AI PPC Agent: Scheduled Google Ads Campaign Analytics with AI Reporting via Email & Slack

Problem:

A PPC team managing Google Ads campaigns had no automated reporting system, pulling campaign performance data, calculating key metrics, and distributing reports to stakeholders required manual platform logins and copy-pasting data into emails or Slack messages on a recurring basis.

Solution:

Built a dual-trigger n8n workflow (webhook + schedule) that sets campaign variables, pulls all Google Ads campaign data via API, processes it through a custom code block for metric calculation, and passes the structured data to the BAX AI PPC AGENT, powered by OpenAI, which analyzes performance, generates insights, and distributes reports using three tools: Send Email (Gmail) for stakeholder reporting, Calculator for precise metric computation, and Slack for instant team notifications.

Result:

Delivered a fully automated PPC reporting system that pulls live Google Ads data, generates AI-written performance analysis, and distributes reports across email and Slack on schedule, eliminating all manual reporting work and keeping the entire team informed without logging into a single platform.