🎫 Send AI-generated Gmail auto replies with GPT-4o-mini and Google Sheets
⚡ 147 views · 🎫 Ticket Management & Triage
Description
Overview
This workflow automatically replies to important incoming Gmail messages using AI, while preventing duplicate or unnecessary replies.
It applies multiple safety checks (filters, Google Sheets history, and Gmail sent history) to ensure replies are sent only when appropriate.
This template is designed for creators, freelancers, and teams who want a reliable and maintainable AI-powered email auto-reply system.
How it works
- New Gmail messages are received and normalized into a consistent structure.
- Unwanted emails (newsletters, promotions, no-reply senders) are filtered out.
- The sender’s email is checked against a Google Sheets reply history.
- Gmail is searched to confirm no recent reply was already sent.
- If no duplicate is found, an AI-generated English reply is created and sent.
Setup steps
- Connect your Gmail account.
- Connect a Google Sheet for reply history tracking.
- Review the ignore rules and thresholds in the config node.
- Customize the AI prompt if needed.
- Activate the workflow.
Estimated setup time: 5–10 minutes.
Notes
- Sticky notes inside the workflow explain each processing step in detail.
- No hardcoded API keys are used.
- The workflow is intentionally linear for clarity and easy maintenance.
🔗 Nodes Used
Google Sheets, Gmail, Gmail Trigger, OpenAI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File