{"product_id":"n8n-gmail-ai-reply-drafts-with-claude-sonnet-sheets-log","title":"n8n Gmail AI Reply Drafts with Claude Sonnet + Sheets Log","description":"\u003ch3\u003eDraft smart Gmail replies automatically—then log every AI decision to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e watches your \u003cstrong\u003eGmail Inbox\u003c\/strong\u003e for new unread messages, uses \u003cstrong\u003eAnthropic Claude (Claude Sonnet)\u003c\/strong\u003e to determine whether a reply is needed, drafts the response in the original thread, and records the full AI decision (category, urgency, escalation) in a \u003cstrong\u003eGoogle Sheets “Email Log”\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors unread emails\u003c\/strong\u003e every minute in your Gmail Inbox, excluding \u003cstrong\u003ePromotions\u003c\/strong\u003e and \u003cstrong\u003eSocial\u003c\/strong\u003e categories.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes message data\u003c\/strong\u003e into consistent fields (sender name\/address, subject, body, message ID, thread ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Anthropic Claude\u003c\/strong\u003e with your business profile (tone, facts, signature, and example replies) to classify the email and generate a \u003cstrong\u003eJSON reply draft\u003c\/strong\u003e when appropriate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and sanitizes Claude output\u003c\/strong\u003e, defaulting to a \u003cstrong\u003e“no reply”\u003c\/strong\u003e response with an \u003cstrong\u003eescalation flag\u003c\/strong\u003e if the JSON cannot be parsed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Gmail draft reply\u003c\/strong\u003e in the original thread when Claude indicates a reply is needed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a row to Google Sheets\u003c\/strong\u003e with timestamp, sender, subject, category, urgency, escalation flag, reason, and whether a draft was created.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams triaging inbound customer emails and generating consistent, on-brand drafts.\u003c\/li\u003e\n  \u003cli\u003eOperations workflows where you want AI-assisted replies plus an auditable \u003cstrong\u003eEmail Log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003en8n automation engineers who want a practical example of Gmail + Claude + Sheets with JSON parsing and safe fallbacks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Gmail (trigger + draft creation), Anthropic (Claude Sonnet), Google Sheets (log append).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, plus a \u003cem\u003esticky note\u003c\/em\u003e for guidance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e Gmail connected in both Gmail trigger and Gmail draft actions; add \u003cstrong\u003eAnthropic credentials\u003c\/strong\u003e; configure Google Sheets with a worksheet named \u003cstrong\u003e“Email Log”\u003c\/strong\u003e including the required columns (timestamp, from, subject, category, urge—plus the remaining fields used by the log).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862252413107,"sku":"N8N-18102","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MD82FqTtWgq_ENCV6tPZa_uZKv5emC.png?v=1786958079","url":"https:\/\/buyflowscripts.com\/products\/n8n-gmail-ai-reply-drafts-with-claude-sonnet-sheets-log","provider":"N8N Commerce","version":"1.0","type":"link"}