Skip to main content
Connect VATextract to Airtable to automatically push extracted invoice data to your bases.

​
Connecting to Airtable

1

Navigate to Integrations

Go to Settings → Integrations in your dashboard.
2

Click Connect Airtable

Click the Connect button next to the Airtable integration.
3

Authorize Access

You’ll be redirected to Airtable to authorize VATextract. Click Add a base and select the base you want to use.
4

Configure Mapping

Select your base, table, and map VATextract fields to your Airtable columns.
VATextract uses Airtable’s OAuth 2.0 for secure authentication. We only access the bases you explicitly authorize.

​
Field Mapping

Map VATextract fields to your Airtable columns:
VATextractFieldRecommended Airtable Type
Supplier NameSingle line text
Invoice NumberSingle line text
Invoice DateDate
Due DateDate
Total AmountCurrency
VAT AmountCurrency
CurrencySingle select
StatusSingle select

​
Custom Fields

You can map any extracted field to any Airtable column. The integration supports:
  • Text fields → Single/Long text
  • Numbers → Number/Currency
  • Dates → Date
  • Arrays (line items) → Linked records

​
Syncing Invoices

​
Manual Sync

  1. Select invoices in your dashboard
  2. Click Bulk Actions → Push to Airtable
  3. Invoices are synced to your connected base

​
Automatic Sync

Enable auto-sync in Settings → Integrations → Airtable:
  • On upload: Sync immediately when an invoice is processed
  • On approval: Sync only when review status is “Approved”

​
Handling Line Items

Line items can be synced in two ways:
Store all line items as a JSON string in a Long text field.
[
  {"description": "Widget A", "quantity": 10, "amount": 100},
  {"description": "Widget B", "quantity": 5, "amount": 75}
]

​
Troubleshooting

Airtable tokens expire after 60 days. Reconnect in Settings → Integrations to refresh.
VATextract caches your table structure. Click Refresh Schema to fetch the latest columns.