Categorize Emails, Get Telegram Alerts, and Log to Google Sheets with Azure OpenAI

This n8n workflow automates the process of reading incoming emails, categorizing them using Azure OpenAI, and then taking action based on the categorization. Important emails trigger a Telegram alert, while all emails are logged to a Google Sheet.

What it does

This workflow streamlines your email management by:

1. Monitoring Emails: Continuously checks an IMAP inbox for new emails.
2. AI-Powered Categorization: Uses an Azure OpenAI Chat Model and a Text Classifier to analyze the email content and determine its category (e.g., "Important", "Spam", "General").
3. Conditional Alerting: If an email is classified as "Important", it sends an immediate alert to a specified Telegram chat.
4. Logging to Google Sheets: Appends details of every processed email (including its categorization) to a Google Sheet for record-keeping and analysis.
5. Interactive Telegram Trigger: Includes a Telegram Trigger for potential future extensions or manual interaction (though not directly connected in this specific flow).

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• IMAP Email Account: Access to an email account via IMAP for the "Email Trigger (IMAP)" node.
• Azure OpenAI Account: An Azure OpenAI service with a deployed chat model for the "Azure OpenAI Chat Model" node and "Text Classifier" node. You'll need API keys and endpoint details.
• Telegram Bot: A Telegram bot token and a chat ID for sending alerts via the "Telegram" node.
• Google Account: A Google account with access to Google Sheets for the "Google Sheets" node.
• Google Sheet: A pre-existing Google Sheet where email data will be logged.

Setup/Usage

1. Import the Workflow:

   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the JSON code and click "Import".

2. Configure Credentials:

   • Email Trigger (IMAP): Configure your IMAP credentials (host, port, username, password).
   • Azure OpenAI Chat Model: Set up your Azure OpenAI credentials, including your API key, resource name, and deployment ID.
   • Text Classifier: This node will likely use the same Azure OpenAI credentials as the Chat Model.
   • Telegram: Configure your Telegram Bot Token and the Chat ID where alerts should be sent.
   • Google Sheets: Set up your Google Sheets credentials (OAuth2 is recommended).

3. Configure Nodes:

   • Email Trigger (IMAP): Specify the folder to watch (e.g., "INBOX") and the polling interval.
   • Azure OpenAI Chat Model: Ensure the model is correctly configured to process email content for categorization.
   • Text Classifier: Define the categories you want to classify emails into (e.g., "Important", "Spam", "General") and provide examples or instructions for the AI to follow.
   • If: Configure the "If" node to check the output of the "Text Classifier" node. For example, if the classified category is "Important", route the workflow to the Telegram node.
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where the email data should be appended. Map the relevant email fields (sender, subject, body, categorized label) to columns in your sheet.
   • Telegram: Customize the message content for important email alerts.

4. Activate the Workflow:

   • Once all credentials and node settings are configured, save the workflow.
   • Toggle the workflow to "Active" to start processing emails automatically.

This workflow provides a robust solution for intelligent email management, combining real-time alerts with comprehensive logging.