Generate UTM-Tagged Bitly Links from Slack with GPT-4o Mini and Google Sheets Logging

This n8n workflow automates the creation of UTM-tagged Bitly links directly from Slack messages, leveraging the power of GPT-4o Mini for intelligent parameter generation and Google Sheets for logging. It streamlines the process of generating trackable links for marketing campaigns, making it easy to create and manage them without leaving Slack.

What it does

1. Listens for Specific Slack Messages: The workflow is triggered when a Slack message containing the phrase "generate utm" is posted in a configured channel.
2. Extracts Information with AI: It uses an AI Agent (powered by GPT-4o Mini) to extract key information from the Slack message, such as the base URL, campaign source, medium, and content.
3. Constructs UTM Parameters: Based on the extracted information, it intelligently constructs the full UTM parameters.
4. Generates Bitly Short Link: It then takes the base URL and the generated UTM parameters to create a shortened Bitly link.
5. Logs to Google Sheets: The original URL, UTM parameters, and the generated Bitly link are logged into a specified Google Sheet for record-keeping and analysis.
6. Posts Result to Slack: Finally, the workflow posts the newly generated Bitly link back to the Slack channel where the request originated, confirming the action and providing the usable link.
7. Handles Errors: If the AI fails to extract the necessary information or any other error occurs, it posts an error message back to Slack.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Slack Account: A Slack workspace and an app with the necessary permissions to listen to messages and post messages.
• OpenAI API Key: An OpenAI API key to utilize the GPT-4o Mini model for AI Agent functionality.
• Google Account: A Google account with access to Google Sheets.
• Bitly Account: A Bitly account and API key for generating short links. (Note: Bitly node is not explicitly in the JSON but is implied by the workflow title and typical UTM link generation. You might need to add a Bitly node or a custom HTTP request for Bitly API.)

Setup/Usage

1. Import the workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • Slack Trigger: Set up a Slack API credential for the "Slack Trigger" node. Configure it to listen for messages in your desired channel.
   • OpenAI Chat Model: Set up an OpenAI API key credential for the "OpenAI Chat Model" node.
   • Google Sheets: Set up a Google Sheets API credential for the "Google Sheets" node.
   • Slack (Post Message): Set up a Slack API credential for the "Slack" node to allow it to post messages.
3. Configure Nodes:
   • Slack Trigger: Ensure the "Events to Listen For" include message.channels and message.groups.
   • AI Agent (Information Extractor): Review and adjust the prompt for the "Information Extractor" node to accurately parse your desired input format from Slack messages.
   • Google Sheets: Specify the Google Sheet ID and sheet name where you want to log the data. Ensure the column headers match the data being sent (e.g., Original URL, UTM Source, UTM Medium, UTM Campaign, UTM Content, Bitly Link).
   • Slack (Post Message): Configure the channel where the generated link should be posted.
4. Activate the Workflow: Once all credentials and configurations are set, activate the workflow.

Now, whenever you post a message in the configured Slack channel containing "generate utm" and the necessary URL and campaign details, the workflow will automatically process it and return a UTM-tagged Bitly link.

Example Slack Message:

generate utm for https://example.com/product with source=slack, medium=social, campaign=summer_sale, content=button_ad