Skip to content
FlowHubFluxonLab
Airtable
AI Automationfree

AI Data Extraction with Dynamic Prompts and Airtable

by Jimleukadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAirtableAirtableBBasic LLM ChainCCodeHTTP RequestHTTP RequestOpenAI Chat ModelOpenAI Chat Model
Share Post Share
SwEvent TypeCoGet Prompt FieldsGet Prompt Fiel…HRGet File DataEFExtract from FileExtract from Fi…SeGet ResultSILoop Over ItemsNORow ReferenceCLGenerate Field ValueGenerate Field …CoFields to UpdateSILoop Over Items1NORow RefHRGet File Data1EFExtract from File1Extract from Fi…SeGet Result1CLGenerate Field Value1Generate Field …FiFilter Valid RowsFilter Valid Ro…FiFilter Valid FieldsFilter Valid Fi…NOEvent RefNOEvent Ref1OpenAI Chat ModelOpenAI Chat Mod…OpenAI Chat Model1OpenAI Chat Mod…HRGet Webhook PayloadGet Webhook Pay…CoParse EventGet Table SchemaFetch RecordsUpdate RowGet RowSeAdd Row ID to PayloadAdd Row ID to P…Update RecordWeAirtable WebhookMaWhen clicking ‘Test workflow’When clicking ‘…SeSet Airtable VarsSet Airtable Va…Get Table Schema1Get Table Schem…SeGet "Input" FieldGet "Input" Fie…HRRecordsChanged WebhookRecordsChanged …HRFieldsChanged WebhookFieldsChanged W…1234567891011121314151617181920212223242526272829303132
1/5
FLOWS
STEPS · 32
Starts on an incoming request

This n8n template introduces the Dynamic Prompts Ai workflow pattern which are incredible for certain types of data extraction tasks where attributes are unknown or need to remain flexible. The general idea behind this pattern is that the prompts for requested attributes to be extracted live outside the template and so can be changed at any time - without needing to edit the template. This seriously cuts down on maintainance requirements and is reusable for any number of tables at little cost. Check out the video demo I did for n8n Studio here: https://www.youtube.com/watch?v=_fNAD1u8BZw Check out the example Airtable here: https://airtable.com/appAyH3GCBJ56cfXl/shrXzR1Tj99kuQbyL Looking for the Baserow Version? https://n8n.io/workflows/2780-ai-data-extraction-with-dynamic-prompts-and-baserow/ How it works Given we have an "input" field for context and a number of fields for the data we want to extract, this template will run in the background to react to any changes to either the "input" or fields and automatically update the rows accordingly. The key is that Airtable fields have a special property called the "field description".

Tags

n8nreference-onlyairtablechain-llmlm-chat-open-ai
Connects
airtableAirtableBBasic LLM ChainCCodeWHTTP RequestopenaichatmodelOpenAI Chat Model
CategoryAI Automation
Triggermanual
Complexityadvanced
Nodes36
AddedJan 21, 2025

Related workflows

See all AI Automation
BWopenaichatmodelstructuredoutputparser
free

Generate CCTV-style animal TikTok videos with OpenAI, Seedance and Blotato

Quick Overview This workflow runs every four hours to generate a CCTV-style animal video concept with OpenAI, renders an 8-second vertical clip using AtlasCloud Seedance, then publishes it to TikTok via Blotato and sends a preview to Telegram. How it works Runs every 4 hours on a schedule. Uses OpenAI to create a hyper-realistic CCTV-style image and video prompt based on a random (or overridden) animal, location, action, and a current timestamp overlay. Starts a Seedance text-to-video render on AtlasCloud with the generated prompt, duration, aspect ratio, and optional audio. Polls AtlasCloud at a fixed interval until the render status is completed or succeeded and retrieves the output video URL. Uses OpenAI to generate a TikTok-ready title and exactly five hashtags from the video concept. Publishes the generated video to TikTok via Blotato with the title/hashtags and the selected privacy level, flagged as AI-generated. Sends the rendered video and title as a preview to a specified Telegram chat. Setup Add OpenAI API credentials and set the prompt and caption models in the Configuration values if you want to change them. Add an AtlasCloud API key (HTTP Header Auth) and ensure it is

by Dr. Firas
airtableCfacebookgraphapi
free

Post TikTok, YouTube Shorts and Instagram Reels with Airtable, OpenAI and Google

Quick Overview This workflow runs on a schedule, pulls the next publish-ready video from Airtable, uses OpenAI, Google Gemini, and CloudConvert to generate a transcript, title, description, tags, and hashtags, then uploads to YouTube Shorts, posts an Instagram Reel via Meta Graph API, and queues TikTok publishing via Google Sheets. How it works Runs on a schedule (or manually) and waits a random number of minutes to stagger posting. Searches Airtable for content marked Publish = true and Status = “In Publish Queue”, then selects a single record to process. Downloads the video, converts it to MP3 with CloudConvert, and transcribes the audio with OpenAI. Uses OpenAI and Google Gemini to extract a main keyword, generate a YouTube-optimized title, and create YouTube tags, hashtags, and a full YouTube description, then derives a shorter content-only caption for Instagram/TikTok. Uploads the video to tmpfiles.org to generate a direct file URL and updates the Airtable record with the generated metadata and set Status = “Published”. Uploads the video to YouTube with the generated title, description, and tags. Creates and publishes an Instagram Reel via the Meta (Facebook) Graph API after a

by Iliyan Ivanov
autofixingoutputparserBopenaichatmodelstructuredoutputparser
free

Force AI to use a specific output format

This workflow is for anyone looking to automatically fetch, validate, and parse complex language-based queries into a structured format. Its unique capability lies in not only processing language but also fixing invalid outputs before structuring them. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team