Automated Brand Mentions Tracker with Google Sheets and Email

This n8n workflow automates the process of tracking brand mentions, potentially from various sources, and then records them in a Google Sheet while also sending out email notifications. It provides a foundational structure for monitoring your brand's presence online.

What it does

This workflow is designed to be a starting point for a brand mention tracker. Here's a breakdown of its core components:

1. Scheduled Trigger: The workflow is initiated on a schedule, allowing for regular checks for brand mentions.
2. HTTP Request: It includes a generic HTTP Request node, which would typically be configured to fetch data from an API (e.g., a social media monitoring tool, news aggregator, or a custom search API) to find brand mentions.
3. Code Node: A Code node is present, indicating that custom JavaScript logic can be applied to process, filter, or transform the data received from the HTTP request. This is where you might integrate AI models like GPT-4o for sentiment analysis or summarization, as hinted by the directory name.
4. Google Sheets Integration: Processed brand mention data is then written to a Google Sheet, providing a centralized and organized record.
5. Email Notification: An email notification is sent, likely to alert relevant stakeholders about new brand mentions or a summary of recent findings.
6. Sticky Note: A sticky note is included, serving as a placeholder for additional notes or instructions within the workflow.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Account: For Google Sheets integration. You'll need to configure Google Sheets credentials in n8n.
• Email Service: Access to an SMTP server or an email service supported by n8n for sending emails. You'll need to configure email credentials.
• API Access (Optional but likely): Depending on where you plan to track brand mentions, you might need API keys or access tokens for services like social media platforms, news APIs, or AI services (e.g., OpenAI for GPT-4o).

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button (usually a cloud icon with an arrow pointing down) and paste the JSON code.
2. Configure Credentials:
   • Google Sheets: Locate the "Google Sheets" node and configure your Google Sheets credentials. You'll need to grant n8n access to your Google account.
   • Send Email: Locate the "Send Email" node and configure your email credentials (e.g., SMTP server details, username, password).
3. Customize the HTTP Request:
   • Locate the "HTTP Request" node.
   • Configure the URL, headers, and any authentication required to fetch brand mention data from your chosen source.
4. Customize the Code Node:
   • Open the "Code" node.
   • Add your custom JavaScript logic to process the data from the HTTP Request. This is where you would integrate an AI model like GPT-4o to analyze the mentions, extract key information, or perform sentiment analysis.
5. Configure Google Sheets Output:
   • In the "Google Sheets" node, specify the Spreadsheet ID and Sheet Name where you want to record the brand mentions.
   • Map the data from the previous nodes to the columns in your Google Sheet.
6. Configure Email Notifications:
   • In the "Send Email" node, specify the recipient's email address, subject, and the body of the email. You can use expressions to dynamically include details about the brand mentions.
7. Set Schedule:
   • Locate the "Schedule Trigger" node.
   • Configure the desired interval for the workflow to run (e.g., every hour, daily).
8. Activate the Workflow:
   • Once configured, activate the workflow to start tracking brand mentions automatically.