Draft and send AI customer support email replies with Gmail and Google Sheets
Go to Workflow
George Dan
Description
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