Draft and send AI customer support email replies with Gmail and Google Sheets Workflow Solution

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows. Supports knowledge capture and document intelligence use cases.

How it works Gmail is monitored every minute for new incoming emails Automated and irrelevant emails are filtered out (newsletters, noreply senders, out-of-office replies, bounce notifications) AI reads the email and drafts a reply based on your company documentation - embedded directly in the system prompt, no vector database needed The original email and the draft reply are logged to a Google Sheet for human review Type "send" in the Send column to approve a reply - the workflow detects it and sends it via Gmail The row is updated to "Replied" to prevent duplicate sends Set up steps Connect your Gmail, OpenRouter, and Google Sheets credentials (~5 min) Create a Google Sheet with columns: Message ID, From, Subject, Body, Reply, Send In the Draft AI Reply node, replace the sample company documentation in the system prompt with your own In the Filter Unwanted Emails node, update the first condition with your own email address Activate the workflow

Best fit

Need another direction?