This automation generates AI-powered sales collateral for booked leads. It pulls lead data directly from Google Sheets on demand. Invalid or incomplete leads are safely logged without stopping execution. Only leads marked as BOOKED are processed. An AI agent generates a sales summary, one-pager, and proposal draft. All AI output is returned in strict structured JSON. Responses are cleaned and validated before further use. Sales collateral is converted into readable text files. Generated files are uploaded to Google Drive automatically. Proposal links are mapped back to lead records in Sheets. An HTML sales summary email is generated. The report is sent automatically via Gmail.