{"product_id":"n8n-solar-interconnection-triage-sheets-openai-gmail-alerts","title":"n8n Solar Interconnection Triage: Sheets + OpenAI + Gmail Alerts","description":"\u003ch3\u003en8n Solar Interconnection Triage that monitors milestones, detects stalls, and alerts the right people\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your solar utility interconnection milestones in Google Sheets every 6 hours, compares them to a stored state snapshot, and triggers escalation paths using OpenAI-generated email drafts, Gmail outreach, and Telegram alerts—while logging every run back to Google Sheets and an n8n Data Table.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule (every 6 hours)\u003c\/b\u003e to stay ahead of interconnection delays.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads latest milestone and SLA data\u003c\/b\u003e from a Google Sheets \u003ci\u003eCurrent Status\u003c\/i\u003e sheet (e.g., Project ID, Utility, Current Milestone, Last Updated, SLA Days).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads the previous snapshot\u003c\/b\u003e for each project from an n8n Data Table (state stored in \u003ccode\u003esolar_interconnection_state\u003c\/code\u003e or your configured table name).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates change and risk signals\u003c\/b\u003e, including days since last change, stall status, SLA breach, and a resulting \u003cb\u003eseverity\u003c\/b\u003e level.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRoutes outcomes by severity\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eHealthy\/no action projects are routed to a healthy outcome.\u003c\/li\u003e\n      \u003cli\u003eChanged or stalled projects are escalated as \u003cb\u003einfo\u003c\/b\u003e, \u003cb\u003ePM follow-up\u003c\/b\u003e, or \u003cb\u003ecritical\u003c\/b\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFor PM follow-up and critical items\u003c\/b\u003e, uses \u003cb\u003eOpenAI\u003c\/b\u003e to draft a utility follow-up email, sends it via \u003cb\u003eGmail\u003c\/b\u003e, and posts an \u003cb\u003eescalation alert to Telegram\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs everything\u003c\/b\u003e by aggregating outcomes into a run record, upserting the latest state back into the n8n Data Table, and appending a run summary row to Google Sheets under \u003ci\u003eWatchdog Runs\u003c\/i\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack solar interconnection delays across multiple utilities and automatically escalate stalled projects.\u003c\/li\u003e\n  \u003cli\u003eStandardize PM follow-up emails for “changed or stalled” cases using OpenAI drafts.\u003c\/li\u003e\n  \u003cli\u003eProvide SaaS operators and automation engineers an auditable monitoring trail (Google Sheets + Data Table run history).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n schedule\u003c\/b\u003e (runs every 6 hours)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e integration for \u003ci\u003eCurrent Status\u003c\/i\u003e and \u003ci\u003eWatchdog Runs\u003c\/i\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n Data Table\u003c\/b\u003e for state snapshot storage (\u003ccode\u003esolar_interconnection_state\u003c\/code\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e email drafting for follow-ups\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e outreach for PM follow-up and critical items\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTelegram\u003c\/b\u003e alerts for escalation notifications\u003c\/li\u003e\n  \u003cli\u003eCore logic nodes include: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, and \u003cb\u003eswitch\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001862770867,"sku":"N8N-19461","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/F_c9TMPOVrqqrEXkZe3V6_OAXUGf94.png?v=1789117864","url":"https:\/\/buyflowscripts.com\/products\/n8n-solar-interconnection-triage-sheets-openai-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}