Skip to main content

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​

ComponentWhat it DoesInputsKey OutputsUse Case
Get RecordsRetrieves rows from a datasheetdatasheetIdrecordsDisplay or use table content in flows
Create DatasheetCreates a new datasheetspaceId, namedatasheetIdAdd new storage dynamically
Create RecordAdds a record to a datasheetdatasheetIdrecordIdInsert rows from user input or upstream data
Update Multiple RecordsBatch update up to 10 rowsdatasheetIdrecordsModify rows in bulk
Delete FieldRemoves a field from a datasheetspaceId, datasheetId, fieldIdmessageClean 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.

AITable Token Configuration

Get Records​

Fetches all rows from a specified datasheet.

Inputs​

FieldRequiredDescription
datasheetIdrequiredThe ID of the datasheet you want to read

Outputs​

FieldDescription
recordsArray of row data
responseFull API JSON response
headersResponse metadata

Create Datasheet​

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

Inputs​

FieldRequiredDescription
spaceIdrequiredWorkspace where the datasheet will reside
namerequiredName of the datasheet
descriptionOptionalDescription text
field_typeOptionalType of initial field (Text, Number, etc)
field_nameOptionalName of the first field (Title, etc)

Outputs​

FieldDescription
datasheetIdID of the created datasheet
responseFull JSON response
headersResponse headers

Create Record​

Add a new row (record) to a datasheet.

Inputs​

FieldRequiredDescription
datasheetIdrequiredThe datasheet to insert into

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

Outputs​

FieldDescription
recordIdID of the new record
responseAPI response with record details
headersResponse headers

Update Multiple Records​

Updates up to 10 records in a single API call.

Inputs​

FieldRequiredDescription
datasheetIdrequiredDatasheet to update

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

Outputs​

FieldDescription
recordsArray of updated record summaries
responseJSON API response
headersHTTP headers from the call

Delete Field​

Remove a field (column) from a datasheet.

Inputs​

FieldRequiredDescription
spaceIdrequiredSpace ID the datasheet belongs to
datasheetIdrequiredTarget datasheet
fieldIdrequiredID of the field to remove

Outputs​

FieldDescription
messageStatus message from the API
responseJSON response object
headersMetadata 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​

ErrorCauseFix
401 UnauthorizedAPI token missing or invalidRecheck token in Vault
404 Not FoundDatasheet or field ID typoDouble-check IDs from dashboard
400 Bad RequestMalformed payloadReview 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:

AITable Integration Overview