AutomationMart
Home/Browse/Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI
n8n

Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI

n8nn8n16 modulesv1.0
OpenAIGemini

Overview This n8n workflow template enables querying Excel data stored in an Oracle Database using natural language powered by Oracle Select AI. The solution consists of two workflows: - Workflow A uploads an Excel file, creates a table in Oracle Database, inserts the data, and registers the table with Oracle Select AI. - Workflow B provides a chat interface that allows users to query the uploaded data using natural language. User questions are translated into SQL by Oracle Select AI, executed d

At a glance

Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Gemini
Modules
16
Price
Free
Version
v1.0
Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI workflow diagram

About this workflow

Overview This n8n workflow template enables querying Excel data stored in an Oracle Database using natural language powered by Oracle Select AI. The solution consists of two workflows: - Workflow A uploads an Excel file, creates a table in Oracle Database, inserts the data, and registers the table with Oracle Select AI. - Workflow B provides a chat interface that allows users to query the uploaded data using natural language. User questions are translated into SQL by Oracle Select AI, executed directly in the database, and returned as query results. Features - Natural language queries – Ask questions in plain English - AI-powered SQL generation – Automatically converts questions to SQL using Oracle Select AI - Real-time responses – Queries run directly on Oracle Database - Secure by design – Data never leaves Oracle Database - Chat UI support – Built-in chat interface when the workflow is public - API-ready – Can be used as a REST API endpoint Prerequisites Oracle Database - Oracle Database 23ai or later (required for Select AI) - Database user with the following privileges: - CREATE TABLE - INSERT - EXECUTE on DBMSCLOUDAI Oracle Select AI supports the following AI providers: - OCI Generative AI - OpenAI - Azure OpenAI (used in this template) - Google Gemini Azure OpenAI - Active Azure OpenAI resource - Deployed GPT model (for example: gpt-4, gpt-4o-mini) - Azure resource name and deployment name Oracle Credential for Azure OpenAI Create an Oracle credential to securely store the Azure OpenAI API key: Select AI Configuration In Workflow A, update the Select AI configuration node with your environment details: Note: The table name is generated automatically during upload and should not be modified manually. Usage Upload Excel File (Workflow A) Upload an Excel file using the webhook endpoint: Expected Response The returned tableName is used internally by Workflow B to scope chat queries to the correct dataset. Query Your Data with Select AI (Workflow B) After the Excel file is uploaded and registered, you can query the data using natural language through Workflow B. Example Select AI Queries After uploading an Excel file, you can query the data using natural language. Examples: - Show me the top 10 records by salary from EXCELUPLOADCOMPANYTABLE - EXCELAI count records grouped by city EXCELUPLOADTRAVELTABLE - What is the average salary per department from EXCELUPLOADDEPTTABLE Workflow B must be used together with Workflow A and must be configured with the same: - Oracle Database - Select AI profile name - Azure OpenAI configuration References Oracle Select AI Documentation Azure OpenAI Documentation Oracle LiveLabs – Select AI Workshop

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Update Google Sheets rows with responses from ChatGPT based on new data inputs

This template updates Google Sheets rows with AI-generated responses and parsed JSON from every new row of data on your sheet.

Free

Find and add lookalike influencers to HubSpot with influencers.club and GPT-4o-mini

How it works: Find lookalikes to other creators and add to your CRM for influencer outreach and partnerships. Step by step workflow to discover similar creators to your best performers with multi social (Instagram, Tiktok, Youtube, Twitter, Onlyfans, Twitch and more) profiles, analytics and metrics using the influencers.club API, and add the contact records and data in Hubspot Set up: Hubspot (can be swapped for any CRM like Salesforce or Google Sheet) Influencers.club API key

Free

Auto-classify Gmail emails with AI and apply labels for inbox organization

Who is this for? Professionals and individuals who receive high volumes of emails, those who want to automatically organize their Gmail inbox using AI classification. What problem is this workflow solving? Manual email sorting is time-consuming and inconsistent. This workflow automatically categorizes incoming emails into 8 predefined labels (To respond, FYI, Comment, Notification, Meeting update, Awaiting reply, Actioned, Marketing) to help maintain inbox zero and pri

Free

Generate blog posts in WordPress using Perplexity and ChatGPT from Google Sheets rows

This automation generates engaging WordPress blog posts by analyzing every new Google Sheets row employing insights from Perplexity AI and ChatGPT, then publish them directly to your site then update the sheet.

Free

AI-powered short-form video generator with OpenAI, Flux, Kling, and ElevenLabs

Who is this for? Content creators, digital marketers, and social media managers who want to automate the creation of short-form videos for platforms like TikTok, YouTube Shorts, and Instagram Reels without extensive video editing skills. What problem does this workflow solve? Creating engaging short-form videos consistently is time-consuming and requires multiple tools and skills. This workflow automates the entire process from ideation to publishing, significantly reducing the manual effo

Free

Chat with Google Drive documents using GPT, Pinecone, and RAG

Short Overview Automatically sync files from Google Drive into a searchable AI knowledge base with Pinecone, and answer user queries using GPT-4o with conversational memory. ⸻ 🛠️ Workflow Usage Steps 1. Watch Google Drive for file changes Trigger the workflow when a new file is uploaded or an existing file is updated in a specific Google Drive folder. 2. Download and process the file Retrieve the file, split it into smaller text chunks with a Recursive Character Text Splitter

Free

Automate lead qualification & routing with GPT-4o-mini, Google Sheets & HighLevel CRM

Description Automatically qualify and route new leads from a Google Sheet into your CRM with AI-powered scoring and instant sales notifications. Turn raw form submissions into prioritized opportunities—effortlessly. ⚡ What This Template Does - Monitors a Google Sheet for new form submissions. 📄 - Uses Azure OpenAI (GPT-4o-mini) to analyze lead details (value, stage, company) and generate action items. 🤖 - Parses the AI response into clean JSON for structured processing. 🗂️ - Saves qualifi

Free

Generate personalized cold email icebreakers from sites with GPT-4 & G-Sheets

Icebreaker Generator powered with ChatGPT This n8n template crawls a company website, distills the content with AI, and produces a short, personalized icebreaker you can drop straight into your cold emails or CRM. Perfect for SDRs, founders, and agencies who want “real research” at scale. Good to know Works from a Google Sheet of leads (domain + LinkedIn, etc.). Handles common scrape failures gracefully and marks the lead’s Status as Error. Uses ChatGPT to summarize pages and craft one con

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free