{"product_id":"gmail-ai-email-classifier-openai-airtable-sheets-in-n8n","title":"Gmail AI Email Classifier: OpenAI + Airtable + Sheets in n8n","description":"\u003ch3\u003eAutomatically classify incoming Gmail emails with OpenAI—and respond using your FAQ\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail AI Email Classifier\u003c\/strong\u003e workflow in \u003cstrong\u003en8n\u003c\/strong\u003e monitors unread Gmail messages, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to categorize them, logs results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eAirtable\u003c\/strong\u003e, and generates an FAQ-grounded reply before responding in the original email thread—while notifying your \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks Gmail every minute\u003c\/strong\u003e for new unread messages and triggers when an unread email arrives.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts sender details\u003c\/strong\u003e (sender name and email address) and formats the email snippet\/subject.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the email with OpenAI\u003c\/strong\u003e into a predefined category, then routes the message based on that classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every email outcome\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (“Email Logs”) and \u003cstrong\u003eAirtable\u003c\/strong\u003e (email details + category).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends unclear results to Manual Review\u003c\/strong\u003e by writing unmatched\/fallback classifications to a separate Google Sheets tab (“Manual Review”) with a \u003cstrong\u003eNeeds Review\u003c\/strong\u003e status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a reply from your FAQ\u003c\/strong\u003e by retrieving a relevant FAQ entry from a \u003cstrong\u003eSupabase vector store\u003c\/strong\u003e and having OpenAI draft a response using \u003cem\u003eonly\u003c\/em\u003e that FAQ content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReplies to the Gmail thread\u003c\/strong\u003e after a short wait, then \u003cstrong\u003eposts a notification to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRoute support inquiries by category and track them in Google Sheets\/Airtable.\u003c\/li\u003e\n  \u003cli\u003eAuto-reply with consistent, FAQ-based responses for common questions.\u003c\/li\u003e\n  \u003cli\u003eFlag low-confidence or unmatched emails for human follow-up via “Manual Review”.\u003c\/li\u003e\n  \u003cli\u003eKeep your team informed in Slack whenever a new classified email is handled.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger:\u003c\/strong\u003e Gmail unread email polling (every minute)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI:\u003c\/strong\u003e classification + reply generation (with embeddings for retrieval)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase:\u003c\/strong\u003e vector search against \u003ccode\u003ecompany_docs\u003c\/code\u003e \/ \u003ccode\u003ematch_company_docs\u003c\/code\u003e for FAQ retrieval\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogging:\u003c\/strong\u003e Google Sheets (“Email Logs”, “Manual Review”) + Airtable table writes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCommunication:\u003c\/strong\u003e Gmail reply + Slack notification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes mentioned:\u003c\/strong\u003e set, no op, wait, gmail, merge, slack\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eDesigned for n8n users, automation engineers, and SaaS operators\u003c\/strong\u003e who want a reliable Gmail AI email classifier that’s auditable (Sheets\/Airtable) and grounded in documented FAQ content (Supabase + OpenAI).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950306844851,"sku":"N8N-19114","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NtRdSRFUJmGgSKpGesDvd_TdI5mRb3.png?v=1788514500","url":"https:\/\/buyflowscripts.com\/products\/gmail-ai-email-classifier-openai-airtable-sheets-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}