n8nflow.net logo

Smart Email Triage with Gmail, GPT-4, Slack and Google Sheets

by Rahul Joshiโ€ขUpdated: Last update a day agoโ€ขSource: n8n.io
Loading workflow viewer...

Tags

Getting Started

Description

This workflow intelligently analyzes incoming Gmail emails, classifies intent using GPT-4, and sends real-time Slack notifications while logging structured data into Google Sheets. It provides a smart, AI-assisted communication workflow that saves time and ensures no important email is overlooked. ๐Ÿค–๐Ÿ’Œ๐Ÿ“Š

What This Template Does

  • Monitors Gmail for unread or new incoming emails. ๐Ÿ“ฅ
  • Extracts sender, subject, and body content for processing. โœ‰๏ธ
  • Uses GPT-4 to analyze email intent and determine priority. ๐Ÿง 
  • Formats key insights (sender, summary, intent, urgency). ๐Ÿงพ
  • Posts structured summaries and priority alerts in Slack. ๐Ÿ’ฌ
  • Logs all processed emails with classification results in Google Sheets. ๐Ÿ“Š
  • Sends error notifications in case of API or parsing failures. ๐Ÿšจ

Key Benefits

โœ… AI-driven email intent classification for smarter response handling.
โœ… Seamless Slack notifications for high-priority or urgent emails.
โœ… Maintains a centralized record of email insights in Google Sheets.
โœ… Reduces response time by surfacing critical messages instantly.
โœ… Minimizes manual email triage and improves team productivity.

Features

  • Real-time Gmail monitoring for unread emails.
  • AI-based classification using GPT-4.
  • Slack notifications with rich formatting and urgency tagging.
  • Google Sheets logging for tracking and analytics.
  • Built-in error handling with notification alerts.
  • Modular setup for easy credential reuse across projects.

Requirements

  • Gmail OAuth2 credentials with inbox read access.
  • Slack Bot token with chat:write and channels:history scopes.
  • Google Sheets OAuth2 credentials for data logging.
  • Azure OpenAI (or OpenAI GPT-4) API credentials.
  • n8n instance (cloud or self-hosted).

Target Audience

  • Customer support teams managing shared inboxes.
  • Operations teams tracking email-based requests.
  • Sales or marketing teams prioritizing inbound leads.
  • AI automation enthusiasts optimizing email workflows.
  • Remote teams using Slack for real-time updates.

Step-by-Step Setup Instructions

  • Connect your Gmail, Slack, Google Sheets, and GPT-4 credentials in n8n. ๐Ÿ”‘
  • Specify the Gmail search filter (e.g., is:unread) for tracking new emails. ๐Ÿ“ฌ
  • Add your Slack channel ID in the notification node. ๐Ÿ’ฌ
  • Set your Google Sheet ID and tab name for logging results. ๐Ÿ“Š
  • Run once manually to verify connection and output structure. โœ…
  • Enable the workflow for continuous, real-time execution. ๐Ÿš€