Create records

TOOL

Slug

AIRTABLE_CREATE_RECORDS

Version

20261013_00

Toolkit

airtable

Tool to create multiple records (up to 10) in a specified Airtable table. Use when you need to add new rows to a table with field values. Rate limit: 5 requests per second per base.

baseIdrequired

STRING

The unique identifier of the Airtable base. Format: 'app' followed by alphanumeric characters (e.g., 'appHPvgqYXl3LNHXq').

recordsrequired

ARRAY<OBJECT>

Array of record objects to create. Each record object must contain a 'fields' property with the cell values. Maximum of 10 records can be created per request.

fieldsrequired

OBJECT

Object containing field names (or field IDs) mapped to their values. Field names are case-sensitive and must match the table schema exactly. Use AIRTABLE_GET_BASE_SCHEMA to discover field names, IDs, and types. Value types by field: - singleLineText/multilineText/richText/email/url/phoneNumber: string; - number/currency/percent/rating: number; - duration: number (total seconds, e.g., 278 for 4m38s); - checkbox: boolean; - date: string 'YYYY-MM-DD'; - dateTime: string ISO 8601 (e.g., '2024-01-15T14:30:00.000Z'); - singleSelect: string (exact option name from schema); - multipleSelects: array of strings (exact option names); - multipleRecordLinks: array of record IDs (e.g., ['recXXX', 'recYYY']); - multipleAttachments: array of objects with 'url' field; - singleCollaborator: object with 'id' or 'email'; - multipleCollaborators: array of collaborator objects; - barcode: object with 'text' and optional 'type'.

typecast

BOOLEAN

If true, Airtable will perform best-effort automatic data conversion from string values to the appropriate cell type. If false (default), field values must exactly match the expected type. Use with caution as it may produce unexpected results.

Default: false

tableIdOrNamerequired

STRING

The unique identifier or name of the table where records will be created. Table IDs are recommended over names for stability. Format: 'tbl' followed by alphanumeric characters (e.g., 'tblUkxCONS303zkN7').

returnFieldsByFieldId

BOOLEAN

If true, the returned field objects will use field IDs as keys instead of field names. Defaults to false.

Default: false