AutomationFlowsAI & RAG › Triage Gmail and Draft Email Replies with Openai, Slack, and Google Sheets

Triage Gmail and Draft Email Replies with Openai, Slack, and Google Sheets

ByOperstead @operstead on n8n.io

This workflow polls your Gmail inbox every 15 minutes, uses OpenAI to classify unread emails as URGENT, STANDARD, or SPAM, drafts reply emails for non-spam messages, posts a review notification to Slack, and logs spam messages to Google Sheets. Runs every 15 minutes on a…

Cron / scheduled trigger★★★★☆ complexityAI-powered17 nodesGmailOpenAIGoogle SheetsSlack
AI & RAG Trigger: Cron / scheduled Nodes: 17 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #17263 — we link there as the canonical source.

This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "name": "AI Email Triage & Auto-Draft Responder \u2014 by Operstead",
  "tags": [],
  "nodes": [
    {
      "id": "d35ebd82-1e0d-477e-b3ed-bdd7d38f9b8e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c3bead6f-78ef-4390-a953-577cac462e5b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        192,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6d10a0d3-2fe9-4061-8818-f3336bb37bb2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cf38efd9-5349-455c-ab9c-e33b66676469",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1552,
        112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0e5c23ea-3a77-4ebf-adc7-07fa1672a3e7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b8ba9507-f706-4596-a537-9509e23ba180",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        448
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "node-schedule",
      "name": "When Every 15 Minutes",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        240,
        340
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "node-gmail-get",
      "name": "Fetch Unread Gmail Emails",
      "type": "n8n-nodes-base.gmail",
      "position": [
        460,
        340
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "node-gmail-read",
      "name": "Mark Emails as Read in Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        680,
        340
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "node-extract",
      "name": "Prepare Email Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        928,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "node-classify",
      "name": "AI Email Classifier",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1152,
        336
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "node-merge-class",
      "name": "Build AI Classification Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1376,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "node-route",
      "name": "Route by Email Category",
      "type": "n8n-nodes-base.switch",
      "position": [
        1600,
        336
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "node-spam-log",
      "name": "Append SPAM Log to Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1872,
        624
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "node-draft-ai",
      "name": "AI Draft Email Responder",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1872,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "node-gmail-draft",
      "name": "Store Reply in Gmail Drafts",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2080,
        240
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "node-slack",
      "name": "Post Draft Alert on Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        2304,
        240
      ],
      "parameters": {},
      "typeVersion": 2
    }
  ],
  "settings": {
    "executionOrder": "v1"
  },
  "updatedAt": "2026-07-20T09:00:00.000Z",
  "versionId": "1",
  "staticData": null,
  "connections": {
    "AI Email Classifier": {
      "main": [
        [
          {
            "node": "Build AI Classification Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Email Fields": {
      "main": [
        [
          {
            "node": "AI Email Classifier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When Every 15 Minutes": {
      "main": [
        [
          {
            "node": "Fetch Unread Gmail Emails",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by Email Category": {
      "main": [
        [
          {
            "node": "AI Draft Email Responder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "AI Draft Email Responder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Append SPAM Log to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Draft Email Responder": {
      "main": [
        [
          {
            "node": "Store Reply in Gmail Drafts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Unread Gmail Emails": {
      "main": [
        [
          {
            "node": "Mark Emails as Read in Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Reply in Gmail Drafts": {
      "main": [
        [
          {
            "node": "Post Draft Alert on Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build AI Classification Data": {
      "main": [
        [
          {
            "node": "Route by Email Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Emails as Read in Gmail": {
      "main": [
        [
          {
            "node": "Prepare Email Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "triggerCount": 0
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow polls your Gmail inbox every 15 minutes, uses OpenAI to classify unread emails as URGENT, STANDARD, or SPAM, drafts reply emails for non-spam messages, posts a review notification to Slack, and logs spam messages to Google Sheets. Runs every 15 minutes on a…

Source: https://n8n.io/workflows/17263/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Imagine a dedicated financial expert tirelessly working behind the scenes, sifting through every transaction, every investment move, and every accounting entry. That's exactly what this automated syst

HTTP Request, Google Sheets, OpenAI +3
AI & RAG

This workflow runs every weekday morning to find HubSpot deals with no recent activity, uses OpenAI to generate a personalized re-engagement email, sends it via Gmail, logs the outcome to Google Sheet

HubSpot, Google Sheets, OpenAI +2
AI & RAG

Property management companies, building managers, and inspection teams who want to automate recurring property inspections, improve issue tracking, and streamline reporting.

Google Sheets, OpenAI, Gmail +2
AI & RAG

This workflow runs weekly to test whether fairyfrills.in is cited in OpenAI answers to 15 shopping queries, logs citation details to Google Sheets, and emails a weekly HTML visibility report via Gmail

OpenAI, Google Sheets, Gmail +2
AI & RAG

Business owners and service providers who want to reduce no-show rates for appointments booked via Google Calendar.

Google Calendar, Google Sheets, OpenAI +2