Library / AI Agents & Assistants
AI Agents & Assistants
Plan solar revenue recovery outreach with Google Sheets, Gemini and WhatsApp
Each morning reads installation and payment data from Google Sheets, has Gemini draft a validated recovery plan, writes it back to the sheet, and sends approved WhatsApp follow-ups.
What it does
## Solar Installation Revenue Recovery Agent with automated Outbound ### How it works This workflow runs each morning to review solar installation operations and payment readiness data from Google Sheets. It builds a deterministic context, asks an AI agent to produce a revenue recovery action plan, validates the result, writes the plan back to Sheets, and sends approved WhatsApp outreach. Finally, it logs outbound messages so future runs can avoid duplicate or inappropriate follow-ups. ### Setup steps - Configure the Schedule Trigger for the desired daily run time and timezone. - Set the spreadsheet ID, company name, send mode, and WhatsApp phone number ID in the Config node. - Connect Google Sheets credentials with access to all required tabs, including sites, scheduled visits, utility approvals, technicians, payment milestones, parts, outbound history, and action plan/log tabs. - Configure the Google Gemini credential for the AI Agent chat model and ensure the structured output parser schema matches the expected action plan format. - Connect WhatsApp Business credentials and verify that message templates, phone number formatting, and dry-run/send-mode behavior are correct before enabling live outbound sends. ### Customization Adjust the readiness and validation logic in the Build Context, Validate Plan, Split Plan Rows, and Build Outbound Messages code nodes to match local business rules, sheet column names, WhatsApp templates, and escalation criteria. @youtube
The steps
- Send WhatsApp Messages
- When Daily at 7AM
- Set Configuration Parameters
- Read Sites from Sheets
- Read Scheduled Visits from Sheets
- Read Utility Approvals from Sheets
- Read Technicians from Sheets
- Read Payment Milestones
- Read Parts from Sheets
- Read Outbound History
- Build Contextual Data
- Revenue Recovery AI Agent
- Google Gemini Chat Integration
- Parse Structured Outputs
19 steps in total.
Similar automations
Finance, Invoices & AccountingDetect revenue leakage and send Gemini recovery emails via Gmail and Slack17 stepsRAG & Knowledge BasesForecast Solar Output with Claude RAG and Supabase10 stepsLead Generation & EnrichmentQualify Solar Leads and Store Utility Bills in Google Drive11 stepsLead Generation & EnrichmentCreate solar ROI proposals from bill photos with WhatsApp, OpenAI and Drive32 steps