AI Agents

Intelligent Query Processing and Airtable Data Storage

11 nodes 225 125 Automatic trigger
Download

Workflow Description

Smart automation that receives chat inquiries, processes them through Google Gemini AI, parses and structures the results, then automatically stores them in Airtable for team access and centralized record-keeping.

How it works

  1. 1.Receive incoming inquiries through the chat trigger interface
  2. 2.Process queries using Google Gemini conversational model
  3. 3.Parse and structure the AI response with output formatting
  4. 4.Store formatted data directly into Airtable tables

Use cases

  • Classify and organize customer inquiries automatically in Airtable
  • Capture and log sales leads instantly for sales team follow-up

Requirements

  • Active Airtable account with pre-configured base and table
  • Valid Google Gemini API key with appropriate permissions
  • Defined data schema for structured query results

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Chat Trigger Gemini Output Parser LLM Chain Airtable

Details

Trigger Automatic trigger
Nodes 11
Apps 5
Views 225
Downloads 125

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (11)

/

When chat message received

Chat Trigger

#1

Google Gemini Chat Model

Gemini Model

#2

Auto-fixing Output Parser

Output Parser Autofixing

#3

Structured Output Parser

Output Parser Structured

#4

Edit Fields

Set

#5

Google Gemini Chat Model1

Gemini Model

#6

Return results

Set

#7

Categorize and name Prompt

LLM Chain

#8

set prompt fields

Set

#9

add to airtable

Airtable

#10

Generate a new prompt

LLM Chain

#11