Link generator and QR code generator with scheduled Google Analytics reports
Workflow Description
Intelligent application that automatically generates shortened links and QR codes while collecting scheduled Google Analytics reports and sending them via email. Uses an AI agent to handle user requests and stores records in a database for tracking and analysis.
How it works
- 1.User requests link shortening or QR code generation through the AI agent
- 2.Agent processes the request and generates the requested link or code
- 3.Data is saved to Airtable along with operation logs
- 4.Scheduled reports retrieve Google Analytics data automatically
- 5.Completed reports are sent via Gmail to designated recipients
Use cases
- Managing marketing campaigns with trackable links for performance monitoring
- Generating QR codes for products and stores without manual intervention
- Sending periodic analytics reports to team members on a regular schedule
Requirements
- OpenAI API key to run the intelligent agent
- Airtable account for storing links and QR codes
- Google Analytics credentials and Gmail account access
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