{"product_id":"solar-revenue-recovery-plan-n8n-google-sheets-gemini-whatsapp","title":"Solar Revenue Recovery Plan: n8n + Google Sheets + Gemini + WhatsApp","description":"\u003ch3\u003eTurn Solar Revenue Stalls into a Daily Recovery Dispatch\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eSolar Revenue Recovery Plan\u003c\/strong\u003e workflow automatically generates a morning dispatch plan for overdue solar projects—using \u003cstrong\u003en8n\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and \u003cstrong\u003eWhatsApp\u003c\/strong\u003e. Every day, it pulls project and payment context from Sheets, asks Gemini to propose revenue-unblocking next steps, applies guardrails to validate the plan, saves it back to Google Sheets, and sends approved customer\/technician\/office WhatsApp template messages.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes at \u003cstrong\u003e7:00 AM Monday through Saturday\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads operational data from Google Sheets:\u003c\/strong\u003e loads Sites, Scheduled_Visits, Utility_Approvals, Technicians, Payment_Milestones, Parts_Required, and Outbound_Log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a single context for decisioning:\u003c\/strong\u003e joins data to calculate readiness blockers (utility approval status, parts ETA, customer availability), technician proximity, and blocked\/overdue payment totals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a structured plan with Gemini:\u003c\/strong\u003e sends the computed context to Google Gemini to produce a plan covering technician visits, office actions, and deferred\/cancelled visits—plus outbound message recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates with deterministic guardrails:\u003c\/strong\u003e removes invalid visits and suppresses outbound messages that violate constraints (utility\/parts rules, availability, capacity limits, cooldowns, and payment reminder caps).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets:\u003c\/strong\u003e flattens the validated plan into rows and appends a daily record to the \u003cstrong\u003eAction_Plan\u003c\/strong\u003e sheet (summary, visit plan, actions, messages, and guardrail notes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends approved WhatsApp messages:\u003c\/strong\u003e dispatches only messages that pass the guardrail checks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate daily recovery for \u003cstrong\u003esolar projects\u003c\/strong\u003e with utility approval or parts ETA delays.\u003c\/li\u003e\n  \u003cli\u003eCoordinate technician scheduling and \u003cstrong\u003edefer\/cancel\u003c\/strong\u003e logic when readiness blockers are detected.\u003c\/li\u003e\n  \u003cli\u003eSend controlled \u003cstrong\u003eWhatsApp\u003c\/strong\u003e payment and visit updates while enforcing reminder caps.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow components:\u003c\/strong\u003e set, code, WhatsApp, sticky note, Google Sheets, and the \u003cstrong\u003en8nn8n-nodes-langchainagent\u003c\/strong\u003e node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI step:\u003c\/strong\u003e Google Gemini generates the structured dispatch plan from the merged Sheet context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidation step:\u003c\/strong\u003e deterministic guardrails ensure only compliant actions and messages are appended\/sent.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217912516787,"sku":"N8N-20841","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VXU-1T8G93SxKMhx5CL1Q_DTZcS6MR.png?v=1791882741","url":"https:\/\/buyflowscripts.com\/products\/solar-revenue-recovery-plan-n8n-google-sheets-gemini-whatsapp","provider":"N8N Commerce","version":"1.0","type":"link"}