UTM Link Creator & QR Code Generator with Scheduled Google Analytics Reports n8n Workflow Template

n8n workflow template · 11 nodes · OpenAI

UTM Link Creator & QR Code Generator with Scheduled Google Analytics Reports is a free n8n workflow template that runs on a schedule and works with OpenAI, Google Analytics, Airtable and Gmail. It has 11 nodes, 3 of them AI nodes (OpenAI Chat Model, Window Buffer Memory and AI Agent). The notes inside the workflow say: “Schedule a Google Analytics Reports with Medium/Source to track UTM link performance. Update the reporting fields to fit your business needs. You can track traffic, conversions and other engagement metrics.” To run it, you add your own credentials for Airtable API, Gmail OAuth2, Google Analytics OAuth2 and OpenAI API.

Download JSON How to import into n8n

At a glance

Trigger
Schedule Trigger (Schedule Google Analytics Report To Marketing Manager)
Nodes
11
Apps
OpenAI, Google Analytics, Airtable and Gmail
AI nodes
3
Credentials
4 types
Category
Content, SEO and social media

Apps and integrations

  • OpenAI
  • Google Analytics
  • Airtable
  • Gmail

Node types used

  • OpenAI Chat Model
  • Window Buffer Memory
  • Google Analytics Tool
  • Manual Trigger
  • Edit Fields (Set)
  • Code
  • Airtable
  • HTTP Request
  • Schedule Trigger
  • AI Agent
  • Gmail

How it works

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Schedule a Google Analytics Reports with Medium/Source to track UTM link performance. Update the reporting fields to fit your business needs. You can track traffic, conversions and other engagement metrics.

Sample Google Report Metrics: Sessions. Update metrics as needed.

Setup notes

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Create a marketing link with UTM parameters. Easily store in database and have QR code created and ready as well.

Type in requirements: website URL campaign id campaign source campaign medium campaign name campaign term

Code node creates the URL with UTM parameters.

It then sends to your Airtable database to store for records. It also creates a QR code with the embedded link to be used for materials.

Sample Airtable Setup: -Website Link UTM column

Nodes in this workflow

The 11 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:

  1. OpenAI Chat Model1 (OpenAI Chat Model)
  2. Window Buffer Memory (Window Buffer Memory)
  3. Google Analytics (Google Analytics Tool)
  4. Create UTM Link & Send To Database (Manual Trigger)
  5. Set UTM Parameters For Link (Edit Fields (Set))
  6. Create UTM Link With Parameters (Code)
  7. Submit UTM Link To Database (Airtable)
  8. Create QR Code With Submitted QR Link (HTTP Request)
  9. Schedule Google Analytics Report To Marketing Manager (Schedule Trigger)
  10. Google Analytics Data Analysis Agent (AI Agent)
  11. Send Summary Report To Marketing Manager (Gmail)

Credentials you need

  • Airtable API – used by Submit UTM Link To Database
  • Gmail OAuth2 – used by Send Summary Report To Marketing Manager
  • Google Analytics OAuth2 – used by Google Analytics
  • OpenAI API – used by OpenAI Chat Model1

Configure your own credentials after importing. Create each credential in n8n, then select it in the node.

How to import into n8n

  1. Download the JSON file with the button above.
  2. In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
  3. Open each node that shows a warning and select or create its credential.
  4. Read the notes on the canvas, test the workflow with sample data, then activate it.

Do you need somewhere to run it? Read our guide to self-hosted n8n.

Need this customised?

We can adapt this workflow to your apps, data and process, then deploy and support it.

Contact Us