AI Agents

Intelligent CSV Processing and Airtable Upload via AI Agent

12 nodes 298 171 Webhook
Download

Workflow Description

Automate CSV file reception through webhook, process data using an AI agent powered by advanced language models and vector storage, then load organized records into Airtable with Slack notifications for real-time updates.

How it works

  1. 1.Receive CSV file via webhook and parse its contents
  2. 2.Split text and generate embeddings using Cohere for semantic understanding
  3. 3.Store vectors in Pinecone for intelligent retrieval and contextual processing
  4. 4.Process data with AI agent backed by Claude language model
  5. 5.Load organized records into Airtable tables automatically
  6. 6.Send execution updates to designated Slack channels

Use cases

  • Import customer lists from CSV files and organize them in a centralized Airtable database with data validation
  • Process incoming reports in CSV format and transform them into categorized records with intelligent classification

Requirements

  • Active Airtable account with API access and table permissions
  • Pinecone vector database and API keys for Cohere and Anthropic services
  • Slack workspace with bot permissions to post messages to channels

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Text Splitter Embeddings Vector Store Memory Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 298
Downloads 171

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 (12)

/

Sticky Note

Sticky Note

#1

Webhook Trigger

Webhook

#2

Text Splitter

Text Splitter Character Text Splitter

#3

Embeddings

Embeddings Cohere

#4

Pinecone Insert

Vector Store Pinecone

#5

Pinecone Query

Vector Store Pinecone

#6

Vector Tool

Tool Vector Store

#7

Window Memory

Memory Buffer Window

#8

Chat Model

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12