{"product_id":"approve-shift-swaps-with-openai-google-sheets-telegram-webhook","title":"Approve Shift Swaps with OpenAI, Google Sheets \u0026 Telegram Webhook","description":"\u003ch3\u003eApprove Shift Swaps Automatically — with OpenAI, Google Sheets, and Telegram Webhook\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives employee shift swap requests via a webhook, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to determine whether each request needs manager review, logs every request to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and notifies people via \u003cstrong\u003eTelegram\u003c\/strong\u003e—either for approval or confirmation.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives swap requests\u003c\/strong\u003e through an n8n \u003cstrong\u003ewebhook\u003c\/strong\u003e (POST), including employee details, shift date, current shift, requested shift, reason, and an optional Telegram chat ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and prepares the request\u003c\/strong\u003e by generating a request ID and timestamp and building the request text for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI decisioning\u003c\/strong\u003e to evaluate the swap against your defined rules and returns a \u003cstrong\u003eJSON decision\u003c\/strong\u003e, including whether the request requires \u003cstrong\u003emanager review\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs requests to Google Sheets\u003c\/strong\u003e in a sheet named \u003cstrong\u003e“ShiftSwaps”\u003c\/strong\u003e, appending each entry with a status of either \u003cstrong\u003ePENDING_REVIEW\u003c\/strong\u003e or \u003cstrong\u003eLOGGED\u003c\/strong\u003e, plus the AI’s short reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Telegram notifications\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf marked \u003cstrong\u003ePENDING_REVIEW\u003c\/strong\u003e, alerts the \u003cstrong\u003emanager\u003c\/strong\u003e to review.\u003c\/li\u003e\n      \u003cli\u003eOtherwise, sends an \u003cstrong\u003eemployee confirmation\u003c\/strong\u003e message.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating shift swap approval workflows for call centers, retail teams, or distributed schedules.\u003c\/li\u003e\n  \u003cli\u003eReducing manual triage by having OpenAI flag only the shift swap requests that need manager attention.\u003c\/li\u003e\n  \u003cli\u003eMaintaining an auditable shift swap history in Google Sheets while notifying managers and employees in real time via Telegram.\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 used:\u003c\/strong\u003e \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e (default model: \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e), \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets setup:\u003c\/strong\u003e configure the target document ID and sheet name; it expects a sheet named \u003cstrong\u003e“ShiftSwaps”\u003c\/strong\u003e with matching columns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook setup:\u003c\/strong\u003e create and activate the webhook endpoint in n8n; connect your shift swap form or internal tool to POST requests to the workflow URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824205684915,"sku":"N8N-18155","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wbJNFY7oNJBdw4UKFbwEA_eFMOldsf.png?v=1786612597","url":"https:\/\/buyflowscripts.com\/products\/approve-shift-swaps-with-openai-google-sheets-telegram-webhook","provider":"N8N Commerce","version":"1.0","type":"link"}