Link generator and QR code generator with scheduled Google Analytics reports
Workflow Description
Intelligent automation generates shortened links and QR codes, schedules customized Google Analytics reports, and stores results in Airtable for email distribution via Gmail. An AI agent powered by OpenAI handles dynamic request processing.
How it works
- 1.Receive request via manual trigger or scheduled interval
- 2.Process request through OpenAI-powered intelligent agent
- 3.Query Google Analytics data and generate links and QR codes
- 4.Store results in Airtable database
- 5.Send compiled report via Gmail to designated recipients
Use cases
- Automate creation and scheduled distribution of digital marketing reports to team members
- Generate trackable shortened links and QR codes for campaigns with integrated analytics data
Requirements
- OpenAI API key and configured Google Analytics access for automation
- Airtable and Gmail accounts with full API permissions
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (14)
OpenAI Chat Model1
OpenAI
Window Buffer Memory
Memory Buffer Window
Google Analytics
Google Analytics Tool
Create UTM Link & Send To Database
Manual Trigger
Set UTM Parameters For Link
Set
Create UTM Link With Parameters
Code
Submit UTM Link To Database
Airtable
Create QR Code With Submitted QR Link
HTTP Request
Schedule Google Analytics Report To Marketing Manager
Schedule Trigger
Google Analytics Data Analysis Agent
Agent
Send Summary Report To Marketing Manager
Gmail
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note