This n8n workflow automates the process of creating trackable UTM links, generating corresponding QR codes, storing them in a database, and scheduling Google Analytics reports for performance analysis. It is designed for marketing teams aiming to streamline campaign tracking and reporting.

The workflow begins with a manual trigger that sets marketing campaign parameters such as website URL, campaign ID, source, medium, name, and term. These parameters are used to generate a UTM link dynamically via a code node. The created UTM URL is then stored in an Airtable database for record-keeping.

Next, a QR code is generated from the UTM link using a quick chart API, allowing easy sharing of campaign URLs printed on physical materials or digital platforms. Additionally, a schedule trigger automatically runs at preset intervals to pull Google Analytics data for the specified property, focusing on key metrics like sessions and source/medium data.

The analytics data is analyzed by an AI agent that produces an executive summary highlighting campaign performance, trends, and actionable insights. This report is then emailed to the marketing manager, providing a comprehensive overview of campaign effectiveness.

This workflow is particularly useful for marketing teams managing multiple campaigns across various channels, aiming to enhance tracking, reporting efficiency, and campaign insights without manual effort.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.memoryBufferWindow, airtable, code, gmail, googleAnalyticsTool, httpRequest, manualTrigger, scheduleTrigger, set, stickyNote