---
updatedAt: 2026-09-08T19:09:07.000Z
agentTools:
  projectIndex: https://docs.sensible.so/llms.txt
---

# Integrate with Airtable using Zapier

Learn how to send Sensible document extraction data into an Airtable database using Zapier, with step-by-step setup for triggers, actions, and field mapping.

This topic describes sending extracted data from example documents into an Airtable database using Sensible's Zapier integration.

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_0.png)

This Zap:

1. triggers every time that Sensible extracts from a document of the specified document type and
2. creates a new record in a database from the extracted data.

## Create an example Sensible extraction

To configure Zapier, you'll use a recent example of a document extraction:

1. Follow the steps in [Getting started with out-of-the-box extractions](https://docs.sensible.so/docs/library-quickstart) to create support for the `1040s` document type.

2. Download an [example](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/pdfs/1040_2021_sample.pdf) 1040 tax form.

3. In the Sensible app, click the **Extract** tab. Upload the example document, select the `1040s` document type, and run an extraction.

## Create an empty destination database

Before you can integrate Sensible with Airtable, you need to set up a destination in Airtable to hold the extracted data Sensible creates. Take the following steps:

1. Sign in or create an Airtable account.
2. Create a destination Airtable base using the following image as a guide, with **extraction id**, **adjusted gross income**, and **taxpayer name**:

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_7.png)

The base contains a field (displayed as a column), for each piece of document data to extract.  Zapier adds a record (displayed as a row), for each new document you extract from.

3. (Optional) examine the [example extraction](https://app.sensible.so/quick-extraction/) you created in the previous section. To add more data from the extraction, create corresponding Airtable fields. For example, create a `Total taxes owed` field.

## Configure Zapier

Take the following steps to connect Sensible to Airtable using Zapier:

1. Sign in or create a [Zapier account](https://zapier.com/).

2. Create a new Zap. For your trigger, search for and select **Sensible**.

3. Take the following steps to connect your Sensible account to Zapier:
   1. Click to expand the **Trigger** section.
   2. Click to expand the **Choose account** section, then follow the prompts to connect your Sensible account.

4. In the **Set up trigger** section:

   1. Select the **1040s** document type you created in the previous steps.

   2. Select the **Production** environment.

   3. Select the **Complete** status.

   4. Leave the default for the **Create Excel output** option.

      **Note:** that if you select true for this option, you can access the extracted document data [converted](https://docs.sensible.so/docs/excel-reference) to an Excel file in succeeding Zapier actions. For an example of using this option, see [Advanced Zapier tutorial](https://docs.sensible.so/docs/zapier-tutorial-2).

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_1.png)

5. Continue to the **Test trigger** section and follow the prompts to test. Verify that the recent document extraction you created in previous steps is selected:

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_2.png)

6. Continue to the **Action** section, search for and select **Airtable**:
   1. For the **Event**, choose **Create records (With Line Item Support)**
   2. Follow the prompts to connect your Airtable account to Zapier.

7. In the **Set up action** section, map Sensible extracted field ids to the corresponding Airtable field names. Zapier displays the data from the recent document extraction as examples. Use the following screenshot to complete the configuration:

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_3.png)

8. (Optional) If you created extra fields in the database, map each one. Note that Zapier only maps non-null values, so be sure your example extraction contains non-null values for all the fields you intend to map.

9. Follow the prompts to test the action. You should see the extracted data from the [1040 example document](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/pdfs/1040_2021_sample.pdf) as a row in Airtable:

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_4.png)

9. Follow the prompts to publish your Zap.

## (Optional) Test your integration

Congratulations, your integration is now published and running! Take the following steps to continue building a database from example documents:

1. Download [another example 1040 document](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/pdfs/1040_2022_sample.pdf) to test your integration.

2. Use the Sensible app's **Extract** tab to run extractions for the example documents.

3. Zapier can take up to 15 minutes to pull data from Sensible. To avoid waiting, navigate to the **Zaps** tab in Zapier, right-click the Zap's ellipsis (...) icon and click **Run**.

4. Verify the extractions show up in Airtable:

![Click to enlarge](https://raw.githubusercontent.com/sensible-hq/sensible-docs/v0/assets/images/final/zapier_5.png)

## (Optional) Scale up

You can extract from more documents automatically by building a more complex Zap so that you can trigger Sensible extractions with file actions in Google drive, Salesforce, or other supported Zapier apps.\
Then send the extraction to the destination of your choice with a Sensible action.  For more information, see [Advanced Zapier tutorial](https://docs.sensible.so/docs/zapier-tutorial-2).

**Note:**  Sensible offers native support for automatically extract from email attachments. Instead of using Zapier for emails, see [Getting started with email extractions](https://docs.sensible.so/docs/getting-started-email).

# Notes

**Limitations**

* You can configure single-value field output with the Sensible-Zapier integration. To handle fields that output data objects, such as tables and sections in Zapier, you can convert the Sensible extraction to Excel by checking the **Excel output** option on the Sensible trigger. Then you can access extracted tables, sections, or other complex fields as rows in the sheet using Zapier's spreadsheet integrations, for example, their Google Sheets integrations. For more information about Sensible's Excel exports, see [SenseML to Excel reference](https://docs.sensible.so/docs/excel-reference).
* You can extract from single-document files with Zapier. If you want to extract from portfolio files (files that contain multiple documents, for example, insurance application bundles), use the Sensible API or SDKs.