{"product_id":"gmail-ai-email-classifier-auto-reply-with-sheets-logging","title":"Gmail AI Email Classifier \u0026 Auto-Reply with Sheets Logging","description":"\u003ch3\u003eInstant Gmail triage + AI replies, with Google Sheets logging\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your Gmail for new emails every minute, uses OpenAI to classify priority and draft a response, and then automatically replies—or routes urgent messages for human approval—while logging everything to Google Sheets for easy tracking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail Trigger (runs every minute)\u003c\/b\u003e: Detects newly arrived emails in your Gmail inbox.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI-powered classification \u0026amp; drafting\u003c\/b\u003e: Sends the email subject to an OpenAI chat model to:\n    \u003cul\u003e\n      \u003cli\u003ecategorize the message\u003c\/li\u003e\n      \u003cli\u003eset priority\u003c\/li\u003e\n      \u003cli\u003edecide whether a reply is needed\u003c\/li\u003e\n      \u003cli\u003edraft a response in a structured format\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRouting rules for auto-reply vs approval\u003c\/b\u003e: Uses rules to ignore newsletters\/spam (or emails that don’t need a reply). For high\/urgent messages, it requests human approval; otherwise, it proceeds with auto-reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHuman-in-the-loop for urgent emails\u003c\/b\u003e: Sends an approval request email via Gmail and waits for the reviewer’s response before continuing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSend the reply in Gmail\u003c\/b\u003e: Replies to the original message using the AI-generated response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLog to Google Sheets\u003c\/b\u003e: Appends a row to Google Sheets containing the processed email and its AI-generated metadata.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who want consistent, fast responses to incoming support-related emails—without manually triaging every message.\u003c\/li\u003e\n  \u003cli\u003eTeams that handle urgent requests with a reviewer approval step while auto-replying everything else.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need a clear audit trail of AI email classification and drafted replies in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cb\u003en8n Cloud or self-hosted n8n\u003c\/b\u003e\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e: Gmail Trigger + Gmail send\/reply steps (OAuth2 credentials required)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e: OpenAI Chat Model node for classification, priority decision, and drafted reply content\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSwitch logic\u003c\/b\u003e: Routes messages based on priority\/reply-needed decisions\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e: Appends processed email data and AI metadata to the selected spreadsheet\/sheet\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtras\u003c\/b\u003e: Includes code and sticky note nodes to support workflow logic and configuration\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetup reminder:\u003c\/b\u003e configure Gmail OAuth2, add OpenAI API credentials, connect Google Sheets, and set the approval request recipient\/message to match your human review workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837441138867,"sku":"N8N-18274","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/r6cnnSoCdQKqknnqrniZm_va0Ipk07.png?v=1786794240","url":"https:\/\/buyflowscripts.com\/products\/gmail-ai-email-classifier-auto-reply-with-sheets-logging","provider":"N8N Commerce","version":"1.0","type":"link"}