Templates / Utm link creator & QR code generator with scheduled Google Analytics reports

Utm link creator & QR code generator with scheduled Google Analytics reports

Needs changes

by Ottoflow.Ai ✓ · 1,735 views · created 2025-02-17 · Market Research

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 11 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Google Analytics, Airtable and Gmail.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. Set UTM Parameters For Link (Edit Fields (Set)): sets 6 fields: website_url, campaign_id, campaign_source…
  2. Google Analytics Data Analysis Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Google Analytics); memory: Window Buffer Memory
  3. Create UTM Link With Parameters (Code): runs custom JavaScript code
  4. Send Summary Report To Marketing Manager (Gmail): uses Gmail
  5. Create QR Code With Submitted QR Link (HTTP Request): calls an HTTP API
  6. Submit UTM Link To Database (Airtable): create or update

Services it uses

OpenAI Chat ModelGoogle AnalyticsAirtableGmail

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in Google Analytics Data Analysis Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
Google Analytics Data Analysis Agent (v1.7)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (11)

From the author

UTM Link Creator & QR Code Generator with Scheduled Google Analytics Reports This workflow enables marketers to generate UTM-tagged links, convert them into QR codes, and automate performance tracking in Google Analytics with scheduled reports every 7 days.…

Excerpt from Ottoflow.Ai's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.