English
Data Connections
Airtable

Airtable

Import table data from Airtable into PuppyOne.


Supported content

TypeSupportedNotes
TablesFull fields and records
ViewsYou can select a specific view
Attachments⚠️Kept as links
Formula fieldsImports computed results

Setup steps

Step 1: Start the import

  1. Open your Project
  2. Click ImportAirtable

Step 2: Authorize Airtable

  1. Click Connect Airtable
  2. Sign in and authorize on the Airtable page
  3. Select the base you want to share

Step 3: Choose the tables to import

  1. Select a base
  2. Select one or more tables to import
  3. Optionally choose a specific view
  4. Click Import

Data structure example

Airtable tables are converted into JSON arrays:

{
  "table_name": "Product Catalog",
  "records": [
    {
      "Name": "Widget Pro",
      "Price": 99.99,
      "Category": "Electronics",
      "Stock": 150,
      "Launch Date": "2024-01-15"
    },
    {
      "Name": "Gadget X",
      "Price": 149.99,
      "Category": "Accessories",
      "Stock": 80,
      "Launch Date": "2024-02-01"
    }
  ]
}

Field type mapping

Airtable TypePuppyOne JSON Type
Single line textstring
Long textstring
Numbernumber
Currencynumber
Checkboxboolean
Single selectstring
Multiple selectarray
Datestring (ISO 8601)
Attachmentarray (URLs)
Link to another recordarray (record IDs)

Use cases

Use case: Product catalog

Import your Airtable product table so a support agent can answer questions like:

  • "Which products cost less than 100?"
  • "How much inventory do we have in the electronics category?"

FAQ

Can I import only some fields?

All fields are imported for now. You can edit the data in PuppyOne afterward and remove fields you do not need.

How are relation fields handled?

Relation fields are imported as arrays of Record IDs. If you need the full linked data, import the related table too.


Next steps