Airtable
Import table data from Airtable into PuppyOne.
Supported content
| Type | Supported | Notes |
|---|---|---|
| Tables | ✅ | Full fields and records |
| Views | ✅ | You can select a specific view |
| Attachments | ⚠️ | Kept as links |
| Formula fields | ✅ | Imports computed results |
Setup steps
Step 1: Start the import
- Open your Project
- Click Import → Airtable
Step 2: Authorize Airtable
- Click Connect Airtable
- Sign in and authorize on the Airtable page
- Select the base you want to share
Step 3: Choose the tables to import
- Select a base
- Select one or more tables to import
- Optionally choose a specific view
- 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 Type | PuppyOne JSON Type |
|---|---|
| Single line text | string |
| Long text | string |
| Number | number |
| Currency | number |
| Checkbox | boolean |
| Single select | string |
| Multiple select | array |
| Date | string (ISO 8601) |
| Attachment | array (URLs) |
| Link to another record | array (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.