🚀 More Vendrato tools: FunnelDupe • GHL Utils
📊

Create Table in Airtable

n8n-nodes-base.httpRequest

Create a new table in an existing Airtable base. Define table name, description, and field structure.

airtable database table create schema api
App Airtable
Category api integration
Version 1.0.0
Author Community
Credentials HTTP Header Auth

💡 Use Cases

📚 API Documentation

Reference documentation for this API endpoint:

🔗 https://airtable.com/developers/web/api/create-table ↗

📋 Node Configuration

{
  "nodes": [
    {
      "parameters": {
        "content": "## 📊 Create Table in Airtable\n\n**Usage:**\nCreate a new table in an existing Airtable base.\n\n**Required Input:**\n- `baseId`: Your Airtable base ID (starts with 'app')\n- `name`: Table name\n- `fields`: Array of field definitions (at least one required)\n\n**Request Body Format:**\n```json\n{\n  \"name\": \"Projects\",\n  \"description\": \"Project tracking\",\n  \"fields\": [\n    { \"name\": \"Name\", \"type\": \"singleLineText\" },\n    { \"name\": \"Status\", \"type\": \"singleSelect\" }\n  ]\n}\n```\n\n**Note:** First field becomes primary field.\n\n**Setup:**\n1. Create HTTP Header Auth credential\n2. Set Name: `Authorization`\n3. Set Value: `Bearer YOUR_PERSONAL_ACCESS_TOKEN`\n4. Ensure token has `schema.bases:write` scope\n\n**Output:**\nReturns created table schema with IDs",
        "height": 238,
        "width": 389,
        "color": 4
      },
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        332
      ],
      "typeVersion": 1,
      "id": "sticky-airtable-create-table",
      "name": "Sticky Note"
    },
    {
      "parameters": {
        "method": "POST",
        "url": "=https://api.airtable.com/v0/meta/bases/{{ $json.baseId }}/tables",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"name\": \"{{ $json.tableName }}\",\n  \"description\": \"{{ $json.tableDescription }}\",\n  \"fields\": [\n    {\n      \"name\": \"Name\",\n      \"type\": \"singleLineText\",\n      \"description\": \"Primary field\"\n    },\n    {\n      \"name\": \"Notes\",\n      \"type\": \"multilineText\"\n    },\n    {\n      \"name\": \"Status\",\n      \"type\": \"singleSelect\",\n      \"options\": {\n        \"choices\": [\n          { \"name\": \"Todo\", \"color\": \"redLight2\" },\n          { \"name\": \"In Progress\", \"color\": \"yellowLight2\" },\n          { \"name\": \"Done\", \"color\": \"greenLight2\" }\n        ]\n      }\n    }\n  ]\n}",
        "options": {}
      },
      "id": "airtable-create-table-node",
      "name": "Create Airtable Table",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.1,
      "position": [
        368,
        400
      ],
      "credentials": {
        "httpHeaderAuth": {
          "id": "airtable-header-auth",
          "name": "Airtable Header Auth"
        }
      }
    }
  ],
  "connections": {},
  "pinData": {},
  "meta": {
    "templateCredsSetupCompleted": true,
    "instanceId": "airtable-flowkit-instance"
  }
}
[
  {
    "id": "081cd4f4-3c68-4afc-9d0a-328073b00264",
    "meta": {
      "name": "API Call Node",
      "id": "api-call",
      "icon": {
        "svg": "",
        "type": "SVG"
      },
      "description": "## 📊 Create Table in Airtable  **Usage:**"
    },
    "label": "Create Airtable Table",
    "dependencies": {
      "node-fetch": "3.3.2"
    },
    "script": "import fetch from \"node-fetch\";\nexport default async function apiCall({\n    url,\n    method,\n    contentType,\n    authorization,\n    body,\n    shouldAwait,\n    queryParams,\n    customHeaders\n}: NodeInputs, {\n    logging\n}: NodeScriptOptions) : NodeOutput  {\n    const headers = {\n        \"Content-Type\": contentType,\n        ...customHeaders\n    };\n    if (authorization) headers[\"Authorization\"] = authorization;\n\n    let queryParamsString = '';\n    if (queryParams) {\n        queryParamsString = '?' + new URLSearchParams(queryParams).toString();\n    }\n\n    const fetchOptions = {\n        method,\n        headers\n    };\n\n    if (method !== 'GET') {\n        fetchOptions.body = JSON.stringify(body);\n    }\n\n    const fetchPromise = fetch(url + queryParamsString, fetchOptions);\n\n    if (!shouldAwait) {\n        return {\n            data: null\n        };\n    }\n\n    const response = await fetchPromise;\n    const data = await response.json();\n    return {\n        status: response.status,\n        data\n    };\n}",
    "inputs": {
      "properties": {
        "method": {
          "type": "string",
          "description": "The HTTP method to use for the API call",
          "enum": [
            "GET",
            "POST",
            "PUT",
            "DELETE",
            "PATCH"
          ],
          "default": "POST",
          "title": "HTTP Method",
          "buildship": {
            "options": [
              {
                "label": "GET",
                "value": "GET"
              },
              {
                "value": "POST",
                "label": "POST"
              },
              {
                "value": "PUT",
                "label": "PUT"
              },
              {
                "label": "DELETE",
                "value": "DELETE"
              },
              {
                "label": "PATCH",
                "value": "PATCH"
              }
            ],
            "index": 0,
            "sensitive": false
          }
        },
        "url": {
          "description": "The URL of the API endpoint",
          "title": "URL",
          "type": "string",
          "buildship": {
            "index": 1
          }
        },
        "authorization": {
          "description": "The authorization header for the API call, if required (e.g., Bearer or Basic token)",
          "type": "string",
          "title": "Authorization",
          "buildship": {
            "sensitive": true,
            "index": 2
          }
        },
        "queryParams": {
          "default": {},
          "description": "The query parameters for the API call",
          "type": "object",
          "title": "Query Parameters",
          "buildship": {
            "index": 3,
            "sensitive": false
          }
        },
        "body": {
          "type": "object",
          "buildship": {
            "index": 4
          },
          "description": "The body to send with the API call",
          "title": "Body"
        },
        "contentType": {
          "enum": [
            "application/json",
            "application/x-www-form-urlencoded",
            "multipart/form-data",
            "text/plain"
          ],
          "description": "The content type of the API call",
          "title": "Content Type",
          "buildship": {
            "index": 5,
            "options": [
              {
                "label": "application/json",
                "value": "application/json"
              },
              {
                "value": "application/x-www-form-urlencoded",
                "label": "application/x-www-form-urlencoded"
              },
              {
                "label": "multipart/form-data",
                "value": "multipart/form-data"
              },
              {
                "label": "text/plain",
                "value": "text/plain"
              }
            ]
          },
          "type": "string"
        },
        "shouldAwait": {
          "description": "Whether to wait for the request to complete or not",
          "title": "Await?",
          "type": "boolean",
          "buildship": {
            "sensitive": false,
            "index": 6
          }
        },
        "customHeaders": {
          "type": "object",
          "description": "Additional custom headers for the API call",
          "title": "Custom Headers",
          "buildship": {
            "index": 7,
            "sensitive": false
          }
        }
      },
      "type": "object",
      "required": [
        "url",
        "shouldAwait",
        "method"
      ]
    },
    "integrations": [],
    "name": "API Call Node",
    "output": {
      "buildship": {},
      "properties": {
        "status": {
          "buildship": {
            "index": 0
          },
          "type": "number",
          "description": "The HTTP status of the API response",
          "title": "Status"
        },
        "data": {
          "buildship": {
            "index": 1
          },
          "title": "Data",
          "type": "object",
          "description": "The data object from the API response"
        }
      },
      "type": "object"
    },
    "isCollapsed": false,
    "type": "script",
    "values": {
      "method": "POST",
      "url": {
        "_$expression_": "`https://api.airtable.com/v0/meta/bases/${ctx?.[\"root\"]?.[\"inputs\"]?.[\"body\"].baseId}/tables`",
        "type": "javascript",
        "hasErrors": false
      },
      "authorization": {
        "_$expression_": "`Bearer ${(await getSecret(\"ANONYMIZED_SECRET\"))}`",
        "type": "javascript",
        "hasErrors": false
      },
      "queryParams": {},
      "body": {
        "_$expression_": "{\n  \"name\": ctx?.[\"root\"]?.[\"inputs\"]?.[\"body\"].tableName,\n  \"description\": ctx?.[\"root\"]?.[\"inputs\"]?.[\"body\"].tableDescription,\n  \"fields\": [\n    {\n      \"name\": \"Name\",\n      \"type\": \"singleLineText\",\n      \"description\": \"Primary field\"\n    },\n    {\n      \"name\": \"Notes\",\n      \"type\": \"multilineText\"\n    },\n    {\n      \"name\": \"Status\",\n      \"type\": \"singleSelect\",\n      \"options\": {\n        \"choices\": [\n          { \"name\": \"Todo\", \"color\": \"redLight2\" },\n          { \"name\": \"In Progress\", \"color\": \"yellowLight2\" },\n          { \"name\": \"Done\", \"color\": \"greenLight2\" }\n        ]\n      }\n    }\n  ]\n}",
        "type": "javascript",
        "hasErrors": false
      },
      "contentType": "application/json",
      "shouldAwait": true,
      "customHeaders": {
        "Content-Type": "application/json"
      }
    }
  }
]
{
  "subflows": [
    {
      "flow": [
        {
          "id": 642,
          "module": "http:ActionSendDataBasicAuth",
          "version": 3,
          "parameters": {
            "key": "ANONYMIZED_CREDENTIALS",
            "handleErrors": false,
            "useNewZLibDeCompress": true
          },
          "mapper": {
            "ca": "",
            "qs": [],
            "url": "https://api.airtable.com/v0/meta/bases/{{1.baseId}}/tables",
            "data": "{\n  \"name\": {{1.tableName}},\n  \"description\": {{1.tableDescription}},\n  \"fields\": [\n    {\n      \"name\": \"Name\",\n      \"type\": \"singleLineText\",\n      \"description\": \"Primary field\"\n    },\n    {\n      \"name\": \"Notes\",\n      \"type\": \"multilineText\"\n    },\n    {\n      \"name\": \"Status\",\n      \"type\": \"singleSelect\",\n      \"options\": {\n        \"choices\": [\n          { \"name\": \"Todo\", \"color\": \"redLight2\" },\n          { \"name\": \"In Progress\", \"color\": \"yellowLight2\" },\n          { \"name\": \"Done\", \"color\": \"greenLight2\" }\n        ]\n      }\n    }\n  ]\n}",
            "gzip": true,
            "method": "post",
            "headers": [
              {
                "name": "Content-Type",
                "value": "application/json"
              },
              {
                "name": "Authorization",
                "value": "Bearer {{ANONYMIZED_TOKEN}}"
              }
            ],
            "timeout": "",
            "useMtls": false,
            "bodyType": "raw",
            "contentType": "application/json",
            "serializeUrl": false,
            "shareCookies": false,
            "parseResponse": true,
            "followRedirect": true,
            "useQuerystring": false,
            "followAllRedirects": false,
            "rejectUnauthorized": true
          },
          "metadata": {
            "designer": {
              "x": 300,
              "y": 300,
              "name": "Create Table in Airtable"
            },
            "restore": {
              "expect": {
                "qs": {
                  "mode": "chose",
                  "items": []
                },
                "method": {
                  "mode": "chose",
                  "label": "POST"
                },
                "headers": {
                  "mode": "chose",
                  "items": [
                    null,
                    null
                  ]
                },
                "bodyType": {
                  "label": "Raw"
                },
                "contentType": {
                  "label": "JSON (application/json)"
                }
              },
              "parameters": {
                "key": {
                  "label": "ANONYMIZED_CREDENTIALS"
                }
              }
            },
            "parameters": [
              {
                "name": "key",
                "type": "keychain:basicauth",
                "label": "Credentials",
                "required": true
              },
              {
                "name": "handleErrors",
                "type": "boolean",
                "label": "Evaluate all states as errors (except for 2xx and 3xx )",
                "required": true
              },
              {
                "name": "useNewZLibDeCompress",
                "type": "hidden"
              }
            ],
            "expect": [
              {
                "name": "url",
                "type": "url",
                "label": "URL",
                "required": true
              },
              {
                "name": "serializeUrl",
                "type": "boolean",
                "label": "Serialize URL",
                "required": true
              },
              {
                "name": "method",
                "type": "select",
                "label": "Method",
                "required": true,
                "validate": {
                  "enum": [
                    "get",
                    "head",
                    "post",
                    "put",
                    "patch",
                    "delete",
                    "options"
                  ]
                }
              },
              {
                "name": "headers",
                "spec": [
                  {
                    "name": "name",
                    "type": "text",
                    "label": "Name",
                    "required": true
                  },
                  {
                    "name": "value",
                    "type": "text",
                    "label": "Value"
                  }
                ],
                "type": "array",
                "label": "Headers"
              },
              {
                "name": "qs",
                "spec": [
                  {
                    "name": "name",
                    "type": "text",
                    "label": "Name",
                    "required": true
                  },
                  {
                    "name": "value",
                    "type": "text",
                    "label": "Value"
                  }
                ],
                "type": "array",
                "label": "Query String"
              },
              {
                "name": "bodyType",
                "type": "select",
                "label": "Body type",
                "validate": {
                  "enum": [
                    "raw",
                    "x_www_form_urlencoded",
                    "multipart_form_data"
                  ]
                }
              },
              {
                "name": "parseResponse",
                "type": "boolean",
                "label": "Parse response",
                "required": true
              },
              {
                "name": "contentType",
                "type": "select",
                "label": "Content type",
                "validate": {
                  "enum": [
                    "text/plain",
                    "application/json",
                    "application/xml",
                    "text/xml",
                    "text/html",
                    "custom"
                  ]
                }
              },
              {
                "name": "data",
                "type": "buffer",
                "label": "Request content"
              }
            ]
          }
        }
      ]
    }
  ],
  "metadata": {
    "version": 1
  }
}

🔗 Related Airtable Nodes

🆕 Create Base in Airtable
Create a new Airtable base with specified tables and fields. Requires workspace ID and at least one table definition.
💬 Create Comment in Airtable
Add a new comment to an Airtable record. Supports @mentions for users and user groups.
➕ Create Field in Airtable
Create a new field (column) in an Airtable table. Supports all field types including text, numbers, selects, dates, and more.
➕ Create Records in Airtable
Create one or multiple records in an Airtable table. Supports batch creation of up to 10 records per request.
🔔 Create Webhook in Airtable
Create a new webhook to receive notifications when records change in an Airtable base. Configure triggers for specific tables and actions.
🗑️ Delete Comment from Airtable
Delete a comment from an Airtable record. Only the comment author or base admin can delete comments.
← Browse all nodes