n8n Solar Interconnection Triage: Sheets + OpenAI + Gmail Alerts

n8n Solar Interconnection Triage that monitors milestones, detects stalls, and alerts the right people

This 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.

What this workflow does

• Runs on a schedule (every 6 hours) to stay ahead of interconnection delays.
• Reads latest milestone and SLA data from a Google Sheets Current Status sheet (e.g., Project ID, Utility, Current Milestone, Last Updated, SLA Days).
• Loads the previous snapshot for each project from an n8n Data Table (state stored in solar_interconnection_state or your configured table name).
• Calculates change and risk signals, including days since last change, stall status, SLA breach, and a resulting severity level.
• Routes outcomes by severity:
  • Healthy/no action projects are routed to a healthy outcome.
  • Changed or stalled projects are escalated as info, PM follow-up, or critical.
• For PM follow-up and critical items, uses OpenAI to draft a utility follow-up email, sends it via Gmail, and posts an escalation alert to Telegram.
• Logs everything 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 Watchdog Runs.

Use cases

• Track solar interconnection delays across multiple utilities and automatically escalate stalled projects.
• Standardize PM follow-up emails for “changed or stalled” cases using OpenAI drafts.
• Provide SaaS operators and automation engineers an auditable monitoring trail (Google Sheets + Data Table run history).

Technical details

• n8n schedule (runs every 6 hours)
• Google Sheets integration for Current Status and Watchdog Runs
• n8n Data Table for state snapshot storage (solar_interconnection_state)
• OpenAI email drafting for follow-ups
• Gmail outreach for PM follow-up and critical items
• Telegram alerts for escalation notifications
• Core logic nodes include: if, set, code, merge, and switch