📄 Automated Lease Renewal Offer by Email

✅ Features

• Automated Lease Offer Generation using AI (Ollama model).
• Duplicate File Check to avoid reprocessing the same customer.
• Personalized Offer Letter creation based on customer details from Supabase.
• PDF/Text File Conversion for formatted output.
• Automatic Google Drive Management for storing and retrieving files.
• Email Sending with generated offer letter attached.
• Seamless Integration with Supabase, Google Drive, Gmail, and AI LLM.

⚙️ How It Works

1. Trigger: Workflow starts on form submission with customer details.

2. Customer Lookup:

• Searches Supabase for customer data.
• Updates customer information if needed.

3. File Search & Duplication Check:

• Looks for existing lease offer files in Google Drive.

• If duplicate found, deletes old file before proceeding.

4. AI Lease Offer Creation:

• Uses the LLM Chain (offerLetter) to generate a customized lease renewal letter.

5. File Conversion:

• Converts AI-generated text into a downloadable file format.

6. Upload to Drive:

• Saves the new lease offer in Google Drive.

7. Email Preparation:

• Uses Basic LLM Chain-email to draft the email body.

• Downloads the offer file from Drive and attaches it.

8. Email Sending:

• Sends the renewal offer email via Gmail to the customer.

🛠 Setup Steps

1. Supabase Connection:

• Add Supabase credentials in n8n.

• Ensure a customers table exists with relevant columns.

🔜Future Steps

• Add specific letter template (organization template).
• PDF offer letter