Generate AI-Powered Lease Renewal Offers with Ollama LLM, Supabase and Gmail

Description

📄 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
Trigger: Workflow starts on form submission with customer details.

Customer Lookup:

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

File Search & Duplication Check:

Looks for existing lease offer files in Google Drive.

If duplicate found, deletes old file before proceeding.

AI Lease Offer Creation:

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

File Conversion:

Converts AI-generated text into a downloadable file format.

Upload to Drive:

Saves the new lease offer in Google Drive.

Email Preparation:

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

Downloads the offer file from Drive and attaches it.

Email Sending:

Sends the renewal offer email via Gmail to the customer.

🛠 Setup Steps
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