Gmail + Google Sheets: smarter inbox triage
Your inbox is not “busy.” It’s messy. Important threads get buried under promos, invoices sit too long, and you end up rereading the same email three times just to decide what to do next.
Marketing managers feel it when partner emails disappear. Business owners feel it when finance messages slip past. And client-facing teams get stuck writing the same “Thanks for reaching out…” replies. This Gmail triage automation sorts, labels, and responds so you can keep moving.
This workflow uses AI to classify incoming Gmail and then takes the right action automatically. You’ll see what it handles, what you still control, and how it turns inbox chaos into a simple system.
How This Automation Works
See how this solves the problem:
n8n Workflow Template: Gmail + Google Sheets: smarter inbox triage
flowchart LR
subgraph sg0["Gmail Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Gmail Trigger", pos: "b", h: 48 }
n1@{ icon: "mdi:robot", form: "rounded", label: "Text Classifier", pos: "b", h: 48 }
n2@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
n3@{ icon: "mdi:message-outline", form: "rounded", label: "Save Priority Mail", pos: "b", h: 48 }
n4@{ icon: "mdi:message-outline", form: "rounded", label: "Save Advertisement Mail", pos: "b", h: 48 }
n5@{ icon: "mdi:message-outline", form: "rounded", label: "Save Inquiry Mail", pos: "b", h: 48 }
n6@{ icon: "mdi:message-outline", form: "rounded", label: "Save Finance Mail", pos: "b", h: 48 }
n7@{ icon: "mdi:robot", form: "rounded", label: "Generate Priority Draft", pos: "b", h: 48 }
n8@{ icon: "mdi:robot", form: "rounded", label: "Generate Ad Summary", pos: "b", h: 48 }
n9@{ icon: "mdi:robot", form: "rounded", label: "Generate Finance Summary", pos: "b", h: 48 }
n10@{ icon: "mdi:robot", form: "rounded", label: "Generate Inquiry Reply", pos: "b", h: 48 }
n11@{ icon: "mdi:message-outline", form: "rounded", label: "Create Draft", pos: "b", h: 48 }
n12@{ icon: "mdi:database", form: "rounded", label: "Append Row to Sheet", pos: "b", h: 48 }
n13@{ icon: "mdi:message-outline", form: "rounded", label: "Send Finance Mail", pos: "b", h: 48 }
n14@{ icon: "mdi:message-outline", form: "rounded", label: "Reply to Inquiry", pos: "b", h: 48 }
n0 --> n1
n1 --> n3
n1 --> n4
n1 --> n5
n1 --> n6
n2 -.-> n1
n6 --> n10
n5 --> n9
n3 --> n7
n8 --> n12
n10 --> n14
n7 --> n11
n4 --> n8
n9 --> n13
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n1,n7,n8,n9,n10 ai
class n2 aiModel
class n12 database
The Challenge: Email triage that steals your best hours
Most inbox overload isn’t caused by writing emails. It’s caused by deciding what each email means, then remembering the “right” next step, then doing it consistently while you’re already interrupted. You scan a subject line, open it, glance at the sender, scroll, and think, “Is this urgent, marketing, a customer question, or finance?” That mental context switching is exhausting. And honestly, it’s where mistakes happen: delayed replies, missed invoice threads, and customer inquiries that go cold while you’re busy sorting newsletters.
It adds up fast. Here’s where it usually breaks down.
- Urgent emails get read but not acted on, because you planned to “reply later” and then forgot.
- Promos clog search and labels, so finding the one real partnership email takes several minutes of digging.
- Customer inquiries receive inconsistent responses, which means more back-and-forth and more reputation risk.
- Billing messages sit in the main inbox instead of reaching accounting, so follow-ups and payment timing get messy.
The Fix: AI sorts every email and takes the next action
This workflow watches your Gmail for new messages, then uses an AI classifier to decide what category the email belongs to: High Priority, Advertisement, Inquiry, or Finance/Billing. Once it knows the intent, it doesn’t just label it and move on. Each category triggers a different action that matches how a real team works. High Priority messages get a professional draft reply created and saved in Gmail so you can review and send quickly. Advertisements are summarized and logged into Google Sheets, giving you a lightweight “promo ledger” without cluttering your inbox. Inquiries get a customer-friendly response and can be sent automatically. Finance/Billing emails get summarized and forwarded to your accounting email so the right person sees it immediately.
The workflow starts with a Gmail trigger and runs the email through an AI text classifier. From there, it applies the correct Gmail label and generates the right text with OpenAI. Finally, the output goes to the right place: a Gmail draft, an auto-sent reply, a Google Sheets row, or a finance forward.
What Changes: Before vs. After
| What This Eliminates | Impact You’ll See |
|---|---|
|
|
Real-World Impact
Say your inbox gets 40 real emails a day. If manual triage takes about 2 minutes per email (open, skim, decide, label, maybe forward), that’s roughly 80 minutes daily. Add another 10 minutes writing quick inquiry replies and you’re near 90 minutes. With this workflow, the trigger and classification happen automatically, promos are summarized into Google Sheets, and urgent threads get drafts created for you. You might spend 10 minutes reviewing drafts instead of an hour-plus sorting and context switching.
Requirements
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Gmail to trigger on new emails and send drafts.
- Google Sheets to log promo summaries for tracking.
- OpenAI API key (get it from your OpenAI dashboard).
Skill level: Intermediate. You’ll connect accounts, set labels, and tune AI prompts for your tone.
Need help implementing this? Talk to an automation expert (free 15-minute consultation).
The Workflow Flow
New Gmail message arrives. The automation starts the moment an email hits your inbox, using a Gmail trigger so nothing depends on someone remembering to run it.
AI decides what it is. A text classifier reads the content and sorts it into one of four buckets: High Priority, Advertisement, Inquiry, or Finance/Billing. This is the “triage brain,” and it’s what stops everything from becoming a vague “deal with later” pile.
The correct action fires. High Priority gets labeled and an OpenAI-written draft reply is created in Gmail. Inquiry emails get a friendly response generated and sent. Finance/Billing gets labeled, summarized, and forwarded to your accounting email. Promotional emails are labeled, summarized, and prepared for logging.
Results land where you already work. Drafts live in Gmail, promos become rows in Google Sheets, and finance summaries reach the right inbox. No new tool for your team to learn.
You can easily modify the four categories to match your business (for example, add “Job Leads” or “Support”) based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Gmail Trigger
Set up the workflow to watch your Gmail inbox and pass new email content to the classifier.
- Add the Gmail Intake Trigger node as the workflow trigger.
- Set Poll Times to
everyMinute. - Credential Required: Connect your gmailOAuth2 credentials in Gmail Intake Trigger.
Step 2: Connect Gmail for Labeling and Replies
These nodes label emails and send replies/drafts; they all require Gmail access.
- In Tag High Priority, Tag Promotional, Tag Inquiry, and Tag Finance, set Operation to
addLabelsand Message ID to{{ $json.id }}. - In each tag node, set Label IDs to
[YOUR_ID]for the Gmail label you want to apply. - In Save Draft Message, set Resource to
draft, Message to{{ $json.message.content['message'] }}, and Subject to{{ $json.message.content['send'] }}. - In Send Inquiry Reply, set Operation to
reply, Resource tothread, Thread ID to{{ $('Tag Inquiry').item.json.threadId }}, Message ID to{{ $('Tag Inquiry').item.json.id }}, and Message to{{ $json.message.content['message'] }}. - In Send Finance Update, set Send To to
[YOUR_EMAIL], Message to{{ $json.message.content['message'] }}, and Subject to{{ $json.message.content['send'] }}. - Credential Required: Connect your gmailOAuth2 credentials in all Gmail action nodes: Tag High Priority, Tag Promotional, Tag Inquiry, Tag Finance, Save Draft Message, Send Inquiry Reply, and Send Finance Update.
[YOUR_ID] and [YOUR_EMAIL] with real label IDs and your target email before testing, or the workflow will fail to label or send.Step 3: Set Up Email Classification
Classify the incoming email into one of four categories and route it accordingly.
- Add Email Category Sorter and set Input Text to
{{ $json.text }}. - Confirm the category list includes High Priority, Advertisement, Inquiry, and Finance/Billing as provided.
- Connect OpenAI Dialogue Model as the language model for Email Category Sorter.
- Credential Required: Connect your openAiApi credentials in OpenAI Dialogue Model (credentials are added to the parent model node, not the classifier).
- Ensure routing is correct: Email Category Sorter outputs to Tag High Priority, Tag Promotional, Tag Inquiry, and Tag Finance in parallel.
Step 4: Configure AI Reply and Summary Generation
Use OpenAI to draft replies or summaries based on the email category.
- In Draft Urgent Reply, keep Model set to
gpt-4oand JSON Output enabled. The prompt already uses{{ $('Gmail Intake Trigger').item.json.text }}. - In Create Promo Summary, keep Model set to
gpt-4oand JSON Output enabled. The prompt already uses{{ $('Gmail Intake Trigger').item.json.text }}. - In Draft Inquiry Reply, keep Model set to
gpt-4oand JSON Output enabled. The prompt already uses{{ $('Gmail Intake Trigger').item.json.text }}. - In Compose Billing Summary, keep Model set to
gpt-4oand JSON Output enabled. The prompt already uses{{ $('Gmail Intake Trigger').item.json.text }}. - Credential Required: Connect your openAiApi credentials in Draft Urgent Reply, Create Promo Summary, Draft Inquiry Reply, and Compose Billing Summary.
Step 5: Configure Google Sheets Logging
Store promotional summaries in Google Sheets for reporting and review.
- In Append Sheet Record, set Operation to
append. - Set Document ID to
[YOUR_ID]and Sheet Name togid=0(cached name:01_Advertisement Mail Summary). - Map columns to: Sender →
{{ $json.message.content['Sender'] }}, Subject →{{ $json.message.content['Subject'] }}, Summary →{{ $json.message.content['Summary'] }}, Recommendation →{{ $json.message.content['Recommendation'] }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Sheet Record.
Sender, Subject, Summary, and Recommendation, or the append will fail.Step 6: Test and Activate Your Workflow
Validate the end-to-end flow before enabling it in production.
- Click Execute Workflow and send test emails that match each category (High Priority, Advertisement, Inquiry, Finance/Billing).
- Confirm that labels are applied, drafts or replies are created, and promotional summaries append to the sheet.
- Verify Gmail actions: Save Draft Message creates a draft, Send Inquiry Reply replies in-thread, and Send Finance Update sends to
[YOUR_EMAIL]. - Once verified, toggle the workflow to Active to enable continuous processing.
Watch Out For
- Gmail credentials can expire or need specific permissions. If things break, check the Gmail node credentials in n8n and confirm the connected Google account still has access.
- Google Sheets logging fails more often than people expect because the sheet tab name changes. If the “Append Sheet Record” step errors, verify the spreadsheet ID and sheet name first.
- OpenAI outputs will feel bland if you don’t define your tone. Update the draft prompts for “Draft Urgent Reply” and “Draft Inquiry Reply” so they reflect your brand voice and your real policies.
Common Questions
About 30 minutes if your Gmail, Sheets, and OpenAI accounts are ready.
Yes, but you’ll want someone comfortable with connecting accounts and testing a few sample emails. No coding is required, though prompt tuning takes a little care.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few dollars a month at typical inbox volumes).
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
You can change the four categories in the “Email Category Sorter” so they match your real inbox (for example, add “Support” or split “Finance” into “Invoices” and “Receipts”). Then update the prompts in “Draft Urgent Reply,” “Draft Inquiry Reply,” and “Compose Billing Summary” so the tone and format are exactly what you want. Common tweaks include adding your signature, referencing your SLA for support, and forcing shorter summaries for finance.
Usually it’s expired or revoked Google permissions. Reconnect the Gmail credential in n8n, then confirm the trigger is watching the right mailbox and label scope. If it still fails, check for Google account security blocks and make sure the workflow isn’t trying to act on messages it can’t access (like shared mailboxes without permission).
For most small teams, it can handle daily inbox volume without any special tuning.
Often, yes, once you need branching logic and multiple outcomes from one trigger. This workflow routes emails into four different paths, generates different AI outputs for each, and then writes to Gmail or Google Sheets accordingly, which is the kind of flow that gets awkward (and pricey) in simpler builders. n8n also gives you the option to self-host, which is helpful if you run this constantly. Zapier or Make can be great if you only want “label an email and send a notification,” but full triage tends to outgrow that quickly. Talk to an automation expert if you want help choosing.
Once this is running, your inbox stops being a daily triage session and starts behaving like a system. The workflow handles the repetitive sorting and first drafts, so you can focus on the emails that actually need you.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
