Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Create solar ROI proposals from bill photos with WhatsApp, OpenAI and Drive
Triggered by a WhatsApp or web form lead, GPT-4o reads the electricity bill, sizes the system and subsidy, then drafts a savings proposal saved to Google Drive and tracked in Sheets.
What it does
## ☀️ SolarOS – Rooftop Solar Lead to Proposal For solar EPC companies in India whose sales team spends a day per lead reading the electricity bill, sizing the system, working out the PM Surya Ghar subsidy and building a proposal. By then the homeowner has already heard from three competitors. ### How it works A lead sends a photo of their electricity bill on WhatsApp or through a web form. GPT-4o reads the units, tariff and sanctioned load. The workflow sizes the system, applies the PM Surya Ghar subsidy, and works out 25-year savings, payback and EMI. The AI writes the proposal copy, and a branded PDF is sent back on WhatsApp within a minute, along with a site-survey booking link. Sales gets a lead-score alert. When the lead books, reschedules or cancels the survey on Cal.com, the CRM is updated, the lead gets a confirmation, and the site engineer is briefed with the address and system size. ### Setup steps 1. Connect WhatsApp Business Cloud (trigger and send), OpenAI, Google Sheets and Google Drive. 2. Run Gotenberg (docker run gotenberg/gotenberg:8) where n8n can reach it, and update its URL if needed. 3. Create a Leads sheet and a Drive folder for proposals, and replace the REPLACE_WITH_… IDs and phone numbers. 4. Edit CFG in Size System, Subsidy & ROI with your company details, prices per kW and Cal.com link. 5. Point a Cal.com webhook at On Cal.com Survey Booking, then send a test bill.
The steps
- On WhatsApp Message
- Solar Proposal Web Form
- Parse WhatsApp Message
- Normalize Form Lead
- Has Bill Photo?
- Get WhatsApp Media URL
- Ask Lead for Bill Photo
- Download Bill Image
- Prepare Lead & OCR Request
- AI Read Electricity Bill (OCR)
- Parse & Validate OCR
- Bill Readable?
- Ask for Clearer Bill Photo
- Size System, Subsidy & ROI
32 steps in total.
Similar automations
Lead Generation & EnrichmentQualify Solar Leads and Store Utility Bills in Google Drive11 stepsRAG & Knowledge BasesForecast Solar Output with Claude RAG and Supabase10 stepsLead Generation & EnrichmentReactivate Solar Leads with Weekly AI SMS and Email22 stepsEmail AutomationTrack solar project milestones with Google Sheets, Gmail and DeepSeek31 steps