n8n Email Management: Auto-Delete Marketing Emails & Generate AI Replies with Gemini

This n8n workflow automates the process of managing incoming emails, specifically targeting marketing emails for deletion and generating AI-powered replies for other emails using Google Gemini. It helps you maintain a cleaner inbox and respond efficiently.

What it does

1. Triggers on New Emails: Listens for new emails arriving in a configured IMAP inbox.
2. Extracts Email Content: Retrieves the subject and body of the incoming email.
3. Categorizes Emails: Uses a "Switch" node to categorize emails based on specific keywords in their subject or body.
   • Path 1 (Marketing Emails): If the email is identified as a marketing email (e.g., contains "unsubscribe", "promotion", "newsletter"), it proceeds to be deleted.
   • Path 2 (Other Emails): If the email is not a marketing email, it proceeds to generate an AI reply.
4. Deletes Marketing Emails: For emails categorized as marketing, it uses the Gmail node to delete them, keeping your inbox clutter-free.
5. Generates AI Replies: For other emails, it sends the email content to Google Gemini to generate a suitable reply.
6. Saves AI Replies to Google Sheets: The generated AI reply, along with the original email details, is appended to a Google Sheet for record-keeping and review.
7. Sends AI Reply (Optional/Manual): The workflow is designed to generate the AI reply and save it. Sending the reply back to the sender would require an additional Gmail "Send Email" node, which is not explicitly configured in this JSON but can be easily added.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• IMAP Account: Access to an IMAP-enabled email account (e.g., Gmail, Outlook, custom server) to trigger the workflow. You'll need to configure IMAP credentials in n8n.
• Gmail Account: A Gmail account with appropriate permissions configured as an OAuth2 credential in n8n for deleting emails.
• Google Gemini API Key: An API key for Google Gemini (or a compatible LangChain provider) configured as a credential in n8n for generating AI replies.
• Google Sheets Account: A Google Sheets account with a designated spreadsheet to store email details and AI-generated replies. You'll need to configure Google Sheets credentials in n8n.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Email Trigger (IMAP): Set up your IMAP credentials (host, port, username, password) for the email account you want to monitor.
   • Gmail: Configure your Google OAuth2 credentials for Gmail. Ensure it has permissions to delete emails.
   • Google Gemini: Set up your Google Gemini API key credential.
   • Google Sheets: Configure your Google OAuth2 credentials for Google Sheets. Ensure it has permissions to write to your specified sheet.
3. Configure Nodes:
   • Email Trigger (IMAP): Specify the mailbox to monitor (e.g., "INBOX").
   • Switch: Review and adjust the conditions in the "Switch" node to accurately identify marketing emails based on your criteria (e.g., keywords in subject/body).
   • Gmail (Delete): Ensure this node is configured to delete the correct email identified as marketing.
   • Google Gemini: Configure the prompt for Gemini to generate appropriate email replies. You might want to include details from the incoming email (subject, sender, body) in the prompt.
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where you want to log the email details and AI replies. Define the columns for mapping the data.
4. Activate the Workflow: Once all credentials and nodes are configured, activate the workflow. It will start listening for new emails.

Note: The "Sticky Note" and "Edit Fields" nodes are present for workflow documentation and data manipulation respectively. The "Manual Trigger" is for testing purposes.