AI-Powered Lease Renewal Offers with Ollama, Supabase & Gmail

This n8n workflow streamlines lease renewal processes by triggering on form submissions with customer details. It first looks up and updates customer information in Supabase, then searches Google Drive for existing offer files, deleting duplicates to prevent reprocessing. Using Ollama LLM, it generates customized lease renewal letters based on customer data.

The workflow converts the AI-generated text into a formatted PDF or text file, uploads it to Google Drive, and prepares an email body with another LLM chain. It downloads the file, attaches it, and sends the personalized offer via Gmail. This ensures professional, error-free communications without manual intervention.

Benefits include significant time savings for property managers, reduced errors from templates, and scalable automation for high-volume renewals. Use cases span real estate agencies, property management firms, and rental businesses handling tenant renewals, enhancing tenant retention with tailored offers.