{"product_id":"n8n-solar-production-loss-diagnosis-solaredge-gemini-slack","title":"n8n Solar Production Loss Diagnosis: SolarEdge + Gemini + Slack","description":"\u003ch3\u003eDiagnose Solar production losses automatically—using SolarEdge, weather data, Gemini, and Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow compares \u003cstrong\u003eSolarEdge energy production\u003c\/strong\u003e against \u003cstrong\u003eweather-adjusted expectations\u003c\/strong\u003e, identifies anomalous performance, and then uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to attribute likely causes—creating a \u003cstrong\u003eJira\u003c\/strong\u003e work order and sending alerts to \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\u003eRuns monthly\u003c\/strong\u003e (scheduled) or on demand, then loads site settings like the date range, expected kWh, and threshold rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects performance data\u003c\/strong\u003e by pulling daily production from the \u003cstrong\u003eSolarEdge Monitoring API\u003c\/strong\u003e for the configured period.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds weather context\u003c\/strong\u003e by fetching hourly radiation and cloud cover data from \u003cstrong\u003eOpen-Meteo\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds diagnostic history\u003c\/strong\u003e by querying \u003cstrong\u003ePostgres\u003c\/strong\u003e for the site’s last 30 days of performance and the most recent incidents.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates metrics\u003c\/strong\u003e including actual vs expected production, weather-adjusted losses, performance ratios, anomaly flags, and historical baselines—then \u003cstrong\u003eupserts results into a Postgres solar performance table\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI root-cause attribution (when anomalous)\u003c\/strong\u003e: sends metrics and historical context to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate structured diagnosis details such as root cause, confidence, priority, and recommended actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperationalizes the diagnosis\u003c\/strong\u003e: stores the AI output as an open incident in \u003cstrong\u003ePostgres\u003c\/strong\u003e, creates a \u003cstrong\u003eJira\u003c\/strong\u003e task, links the Jira key back to the incident, and posts an alert to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNo anomaly\u003c\/strong\u003e: posts a daily\/period summary message to Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSpotting monthly underperformance and reducing time-to-root-cause for SolarEdge sites.\u003c\/li\u003e\n  \u003cli\u003eTurning abnormal production dips into Jira work orders with AI-generated recommended actions.\u003c\/li\u003e\n  \u003cli\u003eProviding consistent, weather-aware production diagnostics across multiple solar assets.\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\/logic\u003c\/strong\u003e: if, set, code, jira, slack, postgres\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: SolarEdge Monitoring API (OAuth2), Open-Meteo, Google Gemini, Postgres, Jira, Slack\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eVideo demo:\u003c\/strong\u003e \u003ca href=\"https:\/\/youtu.be\/7lmQu9wd46w\" target=\"_blank\" rel=\"noopener\"\u003ehttps:\/\/youtu.be\/7lmQu9wd46w\u003c\/a\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289127473331,"sku":"N8N-21642","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QCebWqGQvbcNoKunlKClD_33BPtPOT.png?v=1793006298","url":"https:\/\/buyflowscripts.com\/products\/n8n-solar-production-loss-diagnosis-solaredge-gemini-slack","provider":"N8N Commerce","version":"1.0","type":"link"}