{"product_id":"dispatch-field-service-jobs-with-openai-sheets-gmail-telegram","title":"Dispatch Field Service Jobs with OpenAI, Sheets \u0026 Gmail\/Telegram","description":"\u003ch3\u003eDispatch field service jobs automatically from Google Sheets—powered by OpenAI + Gmail\/Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically turns new \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e job requests into dispatched field service assignments. It uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to pick the best technician from your \u003cstrong\u003eTechnicianRoster\u003c\/strong\u003e, logs every dispatch in \u003cstrong\u003eJobLog\u003c\/strong\u003e, and sends job notifications via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e—plus a daily 7:00 AM digest to your owner.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eListens for new requests:\u003c\/strong\u003e Triggers when a new row is added to the \u003cstrong\u003eJobRequests\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates:\u003c\/strong\u003e Normalizes job fields, generates a unique request ID and timestamp, and \u003cstrong\u003erejects incomplete requests\u003c\/strong\u003e by sending a Telegram message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the technician with OpenAI:\u003c\/strong\u003e An OpenAI agent reads the \u003cstrong\u003eTechnicianRoster\u003c\/strong\u003e tab, then returns a JSON dispatch decision for the best technician.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an audit trail:\u003c\/strong\u003e Appends dispatch details to the \u003cstrong\u003eJobLog\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies the right people:\u003c\/strong\u003e Emails the assigned technician a job brief via \u003cstrong\u003eGmail\u003c\/strong\u003e and alerts the dispatch team in \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a daily owner digest:\u003c\/strong\u003e Runs every day at \u003cstrong\u003e7:00 AM\u003c\/strong\u003e, reads \u003cstrong\u003eJobLog\u003c\/strong\u003e, summarizes dispatched jobs, uses OpenAI to generate a short owner-facing digest, and sends it via Gmail and posts it to Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDispatching home services (plumbing, HVAC, repairs) when a dispatcher adds job requests to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomating technician assignment based on your roster data without manual triage.\u003c\/li\u003e\n  \u003cli\u003eProviding owners and teams with a consistent daily snapshot of what was dispatched.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers:\u003c\/strong\u003e New row added in Google Sheets (JobRequests tab) via OAuth (including Trigger OAuth2).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI assignment:\u003c\/strong\u003e OpenAI agent using model \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e to produce a JSON dispatch decision.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifications:\u003c\/strong\u003e \u003cstrong\u003eGmail\u003c\/strong\u003e for technician briefs and daily digest; \u003cstrong\u003eTelegram\u003c\/strong\u003e for incomplete-request alerts and team\/owner posts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003esummarize\u003c\/em\u003e, and supporting nodes (including sticky note for clarity).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837473022131,"sku":"N8N-18195","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9Bwr_movsij0-Ms_IrPPp_m7iLexKt.png?v=1786794887","url":"https:\/\/buyflowscripts.com\/products\/dispatch-field-service-jobs-with-openai-sheets-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}