UTM Marketing Attribution Reports with Google Sheets, GPT-4o, and Gmail

This n8n workflow automates the generation and distribution of UTM marketing attribution reports, leveraging Google Sheets for data, an AI model (GPT-4o via Azure OpenAI) for analysis, and Gmail for report delivery. It simplifies the process of understanding marketing campaign performance by providing regular, AI-powered insights directly to your inbox.

What it does

This workflow performs the following key steps:

1. Triggers on a Schedule: The workflow is initiated on a predefined schedule (e.g., daily, weekly, monthly) to ensure regular report generation.
2. Reads Data from Google Sheets: It connects to a specified Google Sheet to retrieve raw marketing data, likely containing UTM parameters and associated metrics.
3. Processes Data with Custom Code: A Code node is used to prepare and format the data from Google Sheets, making it suitable for AI analysis. This might involve cleaning, aggregating, or structuring the data.
4. Generates AI-Powered Attribution Insights: A Basic LLM Chain node, powered by an Azure OpenAI Chat Model (likely GPT-4o), analyzes the prepared marketing data. It generates insights, summaries, or attribution reports based on the data and a predefined prompt.
5. Sends Report via Gmail: The generated AI insights are then compiled into an email and sent to a specified recipient (or list of recipients) using Gmail.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: Access to a Google Sheets document containing your marketing attribution data.
• Azure OpenAI Account: An Azure OpenAI subscription with access to a chat model (e.g., GPT-4o).
• Gmail Account: A Gmail account configured for sending emails.
• n8n Credentials:
  • Google Sheets credentials (OAuth2 recommended).
  • Azure OpenAI credentials.
  • Gmail credentials (OAuth2 recommended).

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • For the "Google Sheets" node, select or create your Google Sheets OAuth2 credential.
   • For the "Azure OpenAI Chat Model" node, select or create your Azure OpenAI credential.
   • For the "Gmail" node, select or create your Gmail OAuth2 credential.
3. Customize Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where your marketing data is located.
   • Ensure the "Operation" is set to "Read" and "Read All" if you need all data for analysis.
4. Customize Code Node:
   • Review and adjust the JavaScript code within the "Code" node to match the structure of your Google Sheet data and the specific processing required before sending it to the LLM.
5. Configure Basic LLM Chain Node:
   • Prompt: Define the prompt that will guide the AI in generating the attribution report. This prompt should instruct the AI on what kind of analysis to perform and what information to extract from the input data.
   • Input Data: Ensure the input for the LLM chain is correctly mapped from the output of the "Code" node.
6. Configure Gmail Node:
   • Set the To email address(es) for where the reports should be sent.
   • Customize the Subject and Body of the email to include the AI-generated report content (e.g., using an expression like {{ $node["Basic LLM Chain"].json["text"] }}).
7. Set Schedule Trigger:
   • Configure the "Schedule Trigger" node to your desired frequency (e.g., every day, once a week) for report generation.
8. Activate the Workflow: Save and activate the workflow. It will now run automatically based on your defined schedule, generating and sending marketing attribution reports.