🔬 Generate AI-powered lease renewal offers with Ollama LLM, Supabase and Gmail
⚡ 414 views · 🔬 Document Extraction & Analysis
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
🔗 Nodes Used
Google Drive, Gmail, Supabase, Basic LLM Chain, Ollama Chat Model, n8n Form Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File