Automated Lease Renewal Offer Generation and Communication

This n8n workflow automates the process of generating and sending lease renewal offers to tenants. It begins with a form submission where the landlord or property manager inputs customer details and renewal specifics. The workflow then searches for existing customer data in a database (Supabase) to ensure records are up-to-date. It prepares a personalized lease renewal offer letter using language models from Ollama, combining tenant details and renewal terms into a professional document. This offer letter is stored in Google Drive, with duplicate checks to prevent overwriting. The system then creates a formal email and cover letter, automating the communication process by sending the renewal offer via Gmail. The process is designed to streamline lease renewals, reduce manual effort, and maintain clear, consistent communication with tenants, especially useful in property management scenarios.