{"product_id":"gmail-ai-triage-with-google-gemini-label-log-to-sheets","title":"Gmail AI Triage with Google Gemini: Label \u0026 Log to Sheets","description":"\u003ch3\u003eAutomatically triage unread Gmail emails with Google Gemini—then label, log, and draft replies\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail inbox for new unread messages, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to classify and score each email, applies the right \u003cstrong\u003eGmail label\u003c\/strong\u003e, logs the results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and can optionally draft a response in the original thread.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers every 5 minutes\u003c\/strong\u003e when a new unread email arrives in your Gmail inbox.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your existing triage log\u003c\/strong\u003e from Google Sheets and proceeds only when the incoming message includes a \u003cstrong\u003emessage ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends the \u003cstrong\u003esender\u003c\/strong\u003e, \u003cstrong\u003esubject\u003c\/strong\u003e, and \u003cstrong\u003ebody text\u003c\/strong\u003e to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for classification and structured output (e.g., categories such as \u003cem\u003eURGENT\u003c\/em\u003e, \u003cem\u003eCAN_WAIT\u003c\/em\u003e, \u003cem\u003eNEWSLETTER\u003c\/em\u003e, \u003cem\u003eSPAM\u003c\/em\u003e, plus sentiment, priority score, and reply guidance).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMaps the AI classification to a Gmail label ID\u003c\/strong\u003e and prepares a normalized triage record containing email metadata and the AI analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies the selected label\u003c\/strong\u003e to the Gmail message and \u003cstrong\u003eappends the triage record\u003c\/strong\u003e to the configured Google Sheets sheet.\u003c\/li\u003e\n  \u003cli\u003eIf Gemini indicates a reply is needed, it \u003cstrong\u003edrafts a reply\u003c\/strong\u003e using Google Gemini and creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e in the same thread.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePrevent important emails from getting buried by auto-labeling \u003cem\u003eURGENT\u003c\/em\u003e vs. \u003cem\u003eCAN_WAIT\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eTrack newsletter volume and sentiment trends by logging every \u003cem\u003eNEWSLETTER\u003c\/em\u003e message to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eReduce manual inbox work by drafting replies for messages flagged with “reply needed” guidance.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility for SaaS teams—maintain a lightweight AI triage history in Sheets.\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\/integrations:\u003c\/strong\u003e Gmail trigger, Gmail actions, Google Sheets (service account auth), Google Gemini (Google PaLM) with \u003cstrong\u003eGemini 3.1 Flash Lite\u003c\/strong\u003e, plus \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, and supporting nodes (e.g., sticky note for workflow documentation).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthentication:\u003c\/strong\u003e Gmail OAuth2 with permissions to read messages, apply labels, and create drafts; Google service account for Sheets access.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements:\u003c\/strong\u003e Ensure your Google Sheet has columns matching the appended triage record fields.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812016185523,"sku":"N8N-17949","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KIPYkQXzpGcImCxOAT9h-_5hNqAtb1.png?v=1786353342","url":"https:\/\/buyflowscripts.com\/products\/gmail-ai-triage-with-google-gemini-label-log-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}