Skip to main content

Generate AI-powered lease renewal offers with Ollama LLM, Supabase and Gmail

Workflow preview

Generate AI-powered lease renewal offers with Ollama LLM, Supabase and Gmail preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

πŸ“„ 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.
  1. File Search & Duplication Check:
  • Looks for existing lease offer files in Google Drive.

  • If duplicate found, deletes old file before proceeding.

  1. AI Lease Offer Creation:
  • Uses the LLM Chain (offerLetter) to generate a customized lease renewal letter.
  1. File Conversion:
  • Converts AI-generated text into a downloadable file format.
  1. Upload to Drive:
  • Saves the new lease offer in Google Drive.
  1. Email Preparation:
  • Uses Basic LLM Chain-email to draft the email body.

  • Downloads the offer file from Drive and attaches it.

  1. 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