{"product_id":"triage-ops-requests-automation-gemini-sheets-gmail-slack","title":"Triage Ops Requests Automation: Gemini, Sheets, Gmail \u0026 Slack","description":"\u003ch3\u003eTriage Ops Requests in Seconds: Gemini + Sheets + Gmail + Slack Automation\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically receives ops requests through a webhook, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to classify and summarize them, prevents duplicates with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then sends confirmation via \u003cstrong\u003eGmail\u003c\/strong\u003e and notifies your ops team in \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives requests via webhook:\u003c\/strong\u003e Accepts a POST payload containing requester name, email, department, subject, and message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates inputs:\u003c\/strong\u003e Normalizes and checks required fields, returning an error response if key data is missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies with Gemini:\u003c\/strong\u003e Combines department, subject, and message into one text block and sends it to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate structured JSON (request type, summary, urgency, owner suggestion, and checklist).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates task details:\u003c\/strong\u003e Parses Gemini output, calculates a priority score\/level, and creates a task ID and task metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates with Sheets:\u003c\/strong\u003e Checks \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for an existing record using the requester email and a derived channel ID; if found, it returns a duplicate error.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegisters, acknowledges, and escalates:\u003c\/strong\u003e Appends the new task to the Google Sheets “Task Register,” sends an acknowledgement email via \u003cstrong\u003eGmail\u003c\/strong\u003e, posts an internal alert in \u003cstrong\u003eSlack\u003c\/strong\u003e, and returns structured task details to the webhook caller.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn internal ops request form submissions into prioritized tasks with owner suggestions.\u003c\/li\u003e\n  \u003cli\u003eEnsure no duplicate tickets are created for the same requester\/channel using Google Sheets checks.\u003c\/li\u003e\n  \u003cli\u003eProvide instant requester confirmation while keeping your ops team synced in Slack.\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 webhook, if, set, code, gmail, slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Gemini (PaLM\/Google AI), Google Sheets (Task Register), Gmail, and Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Configure the source app\/form to POST JSON to the webhook and add credentials for Gemini, Sheets, Gmail, and Slack in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938307858611,"sku":"N8N-18926","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OzDM-6imn5DJgd9hfy3oV_eWHdaY7g.png?v=1788341760","url":"https:\/\/buyflowscripts.com\/products\/triage-ops-requests-automation-gemini-sheets-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}