n8n Workflow: Monthly AI Multi-Channel Ad PDF Reports (GA4, Ads, Meta)

Turn monthly marketing data into a polished AI executive PDF report—automatically

This n8n workflow pulls performance KPIs from Google Analytics 4, Google Ads, and Meta Ads, generates an OpenAI executive summary, converts a branded HTML report to PDF, uploads it to Google Drive, and emails the link via GoHighLevel—all on a monthly schedule.

What this workflow does

• Runs monthly at 9:00 AM on the 1st and loads a JSON client roster (client IDs and email addresses).
• Calculates current vs previous reporting windows for period-over-period reporting.
• Fetches GA4 website and channel KPIs using the Google Analytics Data API for both periods.
• Pulls paid media performance: Google Ads data from the Google Ads API and campaign insights from the Meta Graph API for the date range.
• Aggregates KPIs into a single model with deltas and blended paid-media metrics.
• Generates an AI executive summary by sending the KPI model to OpenAI (gpt-4o-mini) to produce a JSON summary and recommendations.
• Builds and distributes the report: renders a branded HTML report, converts it to PDF using PDFShift, uploads it to Google Drive, creates a shareable link, and emails it through GoHighLevel (LeadConnector) (including PDF link and PDF URL as an attachment).

Use cases

• Agencies delivering monthly client performance reports across GA4, Google Ads, and Meta.
• SaaS operators who need automated multi-channel reporting with consistent branding and executive insights.
• Automation engineers building a repeatable AI reporting pipeline for a client roster.

Technical details

• Schedule Trigger for monthly execution (1st at 9:00 AM).
• Uses nodes including set, code, sticky note, google drive, http request.
• Integrations: Google Analytics OAuth2 (GA4), Google Ads OAuth2 (with developer token and login customer ID), Meta Graph API, OpenAI (gpt-4o-mini), PDFShift, and GoHighLevel (LeadConnector).
• Google Drive OAuth2 is used for upload/sharing.