Curated

(5/5)

AI Data Extraction with Dynamic Prompts and Airtable

1. Get Table Schema [Learn more about the Airtable node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.airtable/) For this operation, we'll use the handy Airtable node. I recommend getting familiar with this node for all your Airtable needs!

Integrations Used (5)

Workflow Structure (36 nodes)

100%

Manual Trigger

When clicking ‘Test workflow’

Set

Set Airtable Vars

Airtable

Get Table Schema1

Set

Get "Input" Field

Http Request

RecordsChanged Webhook

Http Request

FieldsChanged Webhook

No Op

Event Ref1

Airtable

Get Row

Filter

Filter Valid Rows

Split In Batches

Loop Over Items1

Webhook

Airtable Webhook

Airtable

Get Table Schema

Code

Get Prompt Fields

Http Request

Get Webhook Payload

Code

Parse Event

Switch

Event Type

No Op

Event Ref

Filter

Filter Valid Fields

Airtable

Fetch Records

Split In Batches

Loop Over Items

No Op

Row Reference

No Op

Row Ref

Http Request

Get File Data

Http Request

Get File Data1

Extract From File

Extract from File

Extract From File

Extract from File1

Langchain.chain Llm

Generate Field Value

Langchain.lm Chat Open Ai

OpenAI Chat Model1

Code

Fields to Update

Langchain.chain Llm

Generate Field Value1

Langchain.lm Chat Open Ai

OpenAI Chat Model

Set

Get Result

Set

Get Result1

Airtable

Update Row

Set

Add Row ID to Payload

Airtable

Update Record

Node Types:

logic

code

http

default

transform

action

trigger

Requires credentials

Prerequisites

Required Credentials (2)

Airtable Token

Used by: Get Webhook Payload, Get Table Schema +7 more

Docs

OpenAI

Used by: OpenAI Chat Model, OpenAI Chat Model1

Docs

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~45 min

Score: 85/100

Custom Code

Conditional Logic

Loops

7 Integrations

When to Use This Workflow

AI-Powered Content Creation

Automate content generation, summarization, or analysis using AI capabilities.

Save hours of manual work while maintaining quality and consistency.

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "nodes": [
    {
      "id": "36816ae7-414a-482e-8a50-021885237273",
      "name": "Event Type",
      "type": "n8n-nodes-base.switch",
      "position": [
        -220,
        -140
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "row.updated",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
...