{"product_id":"gmail-triage-to-airtable-openrouter-auto-draft-replies-n8n","title":"Gmail Triage to Airtable + OpenRouter Auto Draft Replies (n8n)","description":"\u003ch3\u003eTurn Gmail support emails into Airtable records and AI-written drafts—automatically (with human review when needed)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your \u003cstrong\u003eGmail inbox\u003c\/strong\u003e, logs new support messages into \u003cstrong\u003eAirtable\u003c\/strong\u003e, and uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e (with an \u003cstrong\u003eOpenAI\u003c\/strong\u003e fallback) to categorize, summarize, and generate \u003cstrong\u003eGmail draft replies\u003c\/strong\u003e—without sending them. If the AI confidence is low or review is required, it alerts your team for approval.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns continuously:\u003c\/strong\u003e triggers every minute to fetch inbox messages, and also runs every 15 minutes to check for \u003cem\u003estuck Airtable records\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePre-processes messages:\u003c\/strong\u003e normalizes email bodies (converts HTML to text when needed) and skips newsletters, auto-replies, bulk mail, and messages from configured sender patterns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoids duplicates:\u003c\/strong\u003e processes emails one at a time and searches Airtable by \u003cstrong\u003eGmail Message ID\u003c\/strong\u003e to skip messages already logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an Airtable intake:\u003c\/strong\u003e inserts\/updates a record with status \u003cstrong\u003eProcessing\u003c\/strong\u003e, then sends email content to an \u003cstrong\u003eOpenRouter chat model\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates structured output:\u003c\/strong\u003e expects JSON containing \u003cstrong\u003ecategory\u003c\/strong\u003e, \u003cstrong\u003econfidence\u003c\/strong\u003e, \u003cstrong\u003esummary\u003c\/strong\u003e, and a \u003cstrong\u003edraft reply\u003c\/strong\u003e. Falls back to \u003cstrong\u003eOpenAI\u003c\/strong\u003e if needed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts in Gmail:\u003c\/strong\u003e validates the AI output, updates Airtable with results, and creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e in the original thread (no auto-sending).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates for review:\u003c\/strong\u003e sends a Gmail review alert when confidence is below a threshold, the category requires review, or the AI requests human review, then marks the record as \u003cstrong\u003ealerted\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles failures:\u003c\/strong\u003e upserts\/updates Airtable with \u003cstrong\u003eError\u003c\/strong\u003e and emails troubleshooting details on processing failures.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSupport teams who want \u003cstrong\u003eAI-assisted replies\u003c\/strong\u003e while keeping a \u003cstrong\u003ehuman approval workflow\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking incoming requests in \u003cstrong\u003eAirtable\u003c\/strong\u003e and standardizing response categories.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable \u003cstrong\u003eGmail + Airtable + LLM\u003c\/strong\u003e triage pipelines in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Gmail, Airtable, if, set, code, no op\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM integration:\u003c\/strong\u003e OpenRouter chat model with OpenAI fallback\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e HTML-to-text normalization, duplicate prevention via Gmail Message ID, Airtable status tracking, Gmail draft creation, alerting, and error upserts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094187528371,"sku":"N8N-19935","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OwBAIu8ajRYGxtH115CwF_RsPDE2Oa.png?v=1790413877","url":"https:\/\/buyflowscripts.com\/products\/gmail-triage-to-airtable-openrouter-auto-draft-replies-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}