Ai data extraction with dynamic prompts and Baserow
This n8n template introduces the Dynamic Prompts AI workflow pattern which are incredible for certain types of data extraction tasks where attributes are unk...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
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 n8n Studio Episode here**: [https://www.youtube.com/watch?v=_fNAD1u8BZw](https://www.youtube.com/watch?v=_fNAD1u8BZw)
**Community post here**: [https://community.n8n.io/t/dynamic-prompts-with-n8n-baserow-and-airtable/72052](https://community.n8n.io/t/dynamic-prompts-with-n8n-baserow-and-airtable/72052)
**Looking for the Airtable Version?** [https://n8n.io/workflows/2771-ai-data-extraction-with-dynamic-prompts-and-airtable/](https://n8n.io/workflows/2771-ai-data-extraction-with-dynamic-prompts-and-airtable/)
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 Baserow fields have a special property called the "field description". In this pattern, we use this property to allow the user to store a simple prompt describing the data that should exist in the column. * Our n8n template reads these column descriptions aka "prompts" to use as instructions to perform tasks on the "input". * In this template, the "input" is a PDF of a resume/CV and the columns are attributes a HR person would want to extract from it - such as full name, address, last position, years of experience etc.
How to use * First publish this template and ensure it's accessible via webhook URL. * You then have to complete the "create Baserow webhooks" steps to configure your baserow to send change events to the n8n template. Baserow webhooks are created in the Baserow web interface.
Check the template for more instructions.
Requirements * Baserow for Tables/Database * OpenAI for LLM and extraction. Feel free to choose another LLM if preferred.
Customising this workflow * If you're not using files, you can replace the "input" field with anything you like. For example, the "input" could be single line text.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Ai data extraction with dynamic prompts and Baserow.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Docs, PDF & OCR Workflows
View All in Docs, PDF & OCR →Add articles to a Notion list by accessing a Discord slash comma
This workflow allows you to add articles to a Notion reading list by accessing a Discord slash command. Prerequisites - A Notion account and [credentials](),...
Adobe PDF Services API Automation
Production-ready n8n automation template for Adobe PDF Services API Automation built by AhiXLight. Seamlessly connects HTTP Request, Execute Workflow Trigger, Dropbox with 20 configured nodes.
Adobe PDF Services API Workflow
Production-ready n8n automation template for Adobe PDF Services API Workflow built by AhiXLight. Seamlessly connects HTTP Request, Execute Workflow Trigger, Dropbox with 20 configured nodes.
AI Brand Voice Content Generator
Production-ready n8n automation template for AI Brand Voice Content Generator built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Information Extractor, HTTP Request with 27 configured nodes.