{"product_id":"n8n-workflow-monthly-ai-multi-channel-ad-pdf-reports-ga4-ads-meta","title":"n8n Workflow: Monthly AI Multi-Channel Ad PDF Reports (GA4, Ads, Meta)","description":"\u003ch3\u003eTurn monthly marketing data into a polished AI executive PDF report—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls performance KPIs from \u003cstrong\u003eGoogle Analytics 4\u003c\/strong\u003e, \u003cstrong\u003eGoogle Ads\u003c\/strong\u003e, and \u003cstrong\u003eMeta Ads\u003c\/strong\u003e, generates an \u003cstrong\u003eOpenAI executive summary\u003c\/strong\u003e, converts a branded \u003cstrong\u003eHTML report to PDF\u003c\/strong\u003e, uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and emails the link via \u003cstrong\u003eGoHighLevel\u003c\/strong\u003e—all on a monthly schedule.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns monthly\u003c\/strong\u003e at \u003cstrong\u003e9:00 AM on the 1st\u003c\/strong\u003e and loads a JSON client roster (client IDs and email addresses).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates current vs previous reporting windows\u003c\/strong\u003e for period-over-period reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches GA4 website and channel KPIs\u003c\/strong\u003e using the Google Analytics Data API for both periods.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls paid media performance\u003c\/strong\u003e: Google Ads data from the Google Ads API and campaign insights from the Meta Graph API for the date range.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates KPIs\u003c\/strong\u003e into a single model with deltas and blended paid-media metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an AI executive summary\u003c\/strong\u003e by sending the KPI model to \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to produce a JSON summary and recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds and distributes the report\u003c\/strong\u003e: renders a branded HTML report, converts it to PDF using \u003cstrong\u003ePDFShift\u003c\/strong\u003e, uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, creates a shareable link, and emails it through \u003cstrong\u003eGoHighLevel (LeadConnector)\u003c\/strong\u003e (including PDF link and PDF URL as an attachment).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAgencies delivering \u003cstrong\u003emonthly client performance reports\u003c\/strong\u003e across GA4, Google Ads, and Meta.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need \u003cstrong\u003eautomated multi-channel reporting\u003c\/strong\u003e with consistent branding and executive insights.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable \u003cstrong\u003eAI reporting pipeline\u003c\/strong\u003e for a client roster.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e for monthly execution (1st at 9:00 AM).\u003c\/li\u003e\n  \u003cli\u003eUses nodes including \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003egoogle drive\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Analytics OAuth2 (GA4)\u003c\/strong\u003e, \u003cstrong\u003eGoogle Ads OAuth2\u003c\/strong\u003e (with developer token and login customer ID), \u003cstrong\u003eMeta Graph API\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003ePDFShift\u003c\/strong\u003e, and \u003cstrong\u003eGoHighLevel (LeadConnector)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eGoogle Drive OAuth2 is used for upload\/sharing.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146241036467,"sku":"N8N-20271","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/05hk7DBt1Zgr3khFlK4Zh_evMKV6GT.png?v=1790845423","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-monthly-ai-multi-channel-ad-pdf-reports-ga4-ads-meta","provider":"N8N Commerce","version":"1.0","type":"link"}