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

πŸ“„ 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

0
Downloads
0
Views
8.74
Quality Score
intermediate
Complexity
Author:Lakindu Siriwardana(View Original β†’)
Created:8/13/2025
Updated:8/25/2025

πŸ”’ Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments