AITable Integration

Need to power your agents with spreadsheet-style automation? AITable provides an open-source, AI-ready database platform to create and manipulate records via API.

TL;DR

Get your AITable API Token from your profile, store it in Vault, and use AITable components to create datasheets, add records, and manage fields programmatically.

List of AITable Components

Component	What it Does	Inputs	Key Outputs	Use Case
Get Records	Retrieves rows from a datasheet	datasheetId	records	Display or use table content in flows
Create Datasheet	Creates a new datasheet	spaceId, name	datasheetId	Add new storage dynamically
Create Record	Adds a record to a datasheet	datasheetId	recordId	Insert rows from user input or upstream data
Update Multiple Records	Batch update up to 10 rows	datasheetId	records	Modify rows in bulk
Delete Field	Removes a field from a datasheet	spaceId, datasheetId, fieldId	message	Clean up unneeded columns

Required Setup

AITable API Token

To access any AITable component, you’ll need to create an API token:

1. Go to your profile → My Settings → Developer Configuration
2. Click + to generate a new API token
3. Copy it and store it in Vault

Use Vault

Store your API token in Vault so it’s reusable across flows and components.

Get Records

Fetches all rows from a specified datasheet.

Inputs

Field	Required	Description
datasheetId	required	The ID of the datasheet you want to read

Outputs

Field	Description
records	Array of row data
response	Full API JSON response
headers	Response metadata

Create Datasheet

Creates a new datasheet (optionally with a first field).

Inputs

Field	Required	Description
spaceId	required	Workspace where the datasheet will reside
name	required	Name of the datasheet
description	Optional	Description text
field_type	Optional	Type of initial field (Text, Number, etc)
field_name	Optional	Name of the first field (Title, etc)

Outputs

Field	Description
datasheetId	ID of the created datasheet
response	Full JSON response
headers	Response headers

Create Record

Add a new row (record) to a datasheet.

Inputs

Field	Required	Description
datasheetId	required	The datasheet to insert into

Additional fields go in the component’s Body section, using the field keys as JSON.

Outputs

Field	Description
recordId	ID of the new record
response	API response with record details
headers	Response headers

Update Multiple Records

Updates up to 10 records in a single API call.

Inputs

Field	Required	Description
datasheetId	required	Datasheet to update

Update data is included in the Body tab in JSON format.

Outputs

Field	Description
records	Array of updated record summaries
response	JSON API response
headers	HTTP headers from the call

Delete Field

Remove a field (column) from a datasheet.

Inputs

Field	Required	Description
spaceId	required	Space ID the datasheet belongs to
datasheetId	required	Target datasheet
fieldId	required	ID of the field to remove

Outputs

Field	Description
message	Status message from the API
response	JSON response object
headers	Metadata headers

Best Practices

• Store your API token in Vault once—reuse across components
• Use field names that match your datasheet schema exactly
• Test requests using the AITable developer playground before building in SmythOS
• Use "Create Datasheet" + "Create Field" to build custom table structures dynamically
• Batch-create or update records where possible to reduce API calls

Troubleshooting

Error	Cause	Fix
401 Unauthorized	API token missing or invalid	Recheck token in Vault
404 Not Found	Datasheet or field ID typo	Double-check IDs from dashboard
400 Bad Request	Malformed payload	Review body structure and required fields

What's Next?

You’ve successfully connected AITable to SmythOS!

Now try building an agent that:

• Collects form input and logs each submission as a new AITable record
• Generates a custom datasheet for every new client or project
• Uses batch updates to enrich multiple rows from an external API

Want even more automation? Combine this with:

• Google Sheets Integration for spreadsheet-to-datasheet syncing
• Google Drive Integration for working with uploaded sheets or templates