Process and Import File Data into Airtable

## Try It Out!
### This n8n template powers a "dynamic" or "user-defined" prompts with PDF workflow pattern for a [Airtable]({{ $env.WEBHOOK_URL }} table. Simply put, it allows users to populate a spreadsheet using prompts without touching the underlying template.

**Check out the video demo I did for n8n Studio**: {{ $env.WEBHOOK_URL }}

**Check out the example Airtable here:** {{ $env.WEBHOOK_URL }}

This template is intended to be used as a webhook source for Airtable. **Looking for a Baserow version? [Click here]({{ $env.WEBHOOK_URL }}

## How it works
* Each Airtable.io tables offers integration feature whereby changes to the table can be sent as events to any accessible webhook. This allows for a reactive trigger pattern which makes this type of workflow possible. For our usecase, we capture the vents of `row_updated`, `field_created` and `field_updated`.
* Next, we'll need an "input" column in our Airtable.io table. This column will be where our context lives for evaluating the prompts against. In this example, our "input" column name is "file" and it's where we'll upload our PDFs. Note, this "input" field is human-controlled and never updated from this template.
* Now for the columns (aka "fields" in Airtable). Each field allows us to define a name, type and description and together form the schema. The first 2 are self-explaintory but the "description" will be for users to provide their prompts ie. what data should the field to contain.
* In this template, a webhook trigger waits for when a row or column is updated. The incoming event comes with lots of details such as the table, row and/or column Ids that were impacted.
* We use this information to fetch the table's schema in order to get the column's descriptions (aka dynamic prompts).
* For each triggered event, we download our input ie. the PDF and ready it for our AI/LLM. By iterating through the available columns and feeding the dynamic prompts, our LLM can run those prompts against the PDF and thus generating a value response for each cell.
* These values are then collected and used to update the Airtable Record.

## How to use
* You'll need to publish this workflow and make it accessible to our Airtable instance.
* you must run the "Create Airtable Webhooks" mini-flow to link it to your Airtable.
* This template is reusable for other Airtables but the webhooks need to be created each time for each table.

### Need Help?
Join the [Discord]({{ $env.WEBHOOK_URL }} or ask in the [Forum]({{ $env.WEBHOOK_URL }}

Happy Flowgramming!