Automate UTM Code Generation and Campaign Performance Tracking in Google Sheets

• Automatically generate UTM codes for email marketing campaigns.
• Log campaign performance metrics into Google Sheets for easy analysis.
• Shorten URLs for better tracking and sharing.
• Fetch and analyze Google Analytics 4 data for campaign insights.
• Receive Slack notifications on campaign performance updates.

Triggers on a webhook to capture campaign details. Generates UTM URLs based on input parameters. Shortens the generated URLs using Bitly. Logs UTM codes and performance metrics into Google Sheets. Fetches campaign performance data from Google Analytics 4. Normalizes the fetched data for easier analysis. Appends performance data to Google Sheets and sends notifications via Slack.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure the webhook settings to receive campaign data.
3. 3
   Set up Bitly credentials for URL shortening.
4. 4
   Connect Google Sheets and specify the sheet IDs.
5. 5
   Configure Google Analytics 4 credentials for performance tracking.
6. 6
   Set up Slack integration for notifications.