Back to Integrations
integrationAirtable node
integrationOpenAI node

Airtable and OpenAI integration

n8n lets you integrate Airtable with OpenAI to build powerful workflows. Design automation that extracts, transforms and loads data between your apps and services. You can choose from thousands of ready-made apps or use our universal HTTP connector to sync apps not yet in our library.

Integrate Airtable and OpenAI

Build your own Airtable and OpenAI integration

Create custom Airtable and OpenAI workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

How to connect Airtable and OpenAI

  • Step 1: Add the first step

  • Step 2: Add Airtable and OpenAI nodes

  • Step 3: Connect Airtable and OpenAI

  • Step 4: Run workflow

Assistant for Hubspot Chat using OpenAi and Airtable

This workflow will allow you to use OpenAI Assistant API together with a chatting platform. This version is configured to work with Hubspot, however, the Hubspot modules can be replaced by other platform and it will work similarly.

Prerequisites:

  • Create a Hubspot Chat (Live chat available on free plan) or Chatflow (paid hubspot only) and configure it to send all replies toward an n8n webhook (you need to create a custom app for that. I will create a separate article on how to do it, meanwhile, feel free to message me if you need support.

Setup:

  • Create a OpenAI Assistant, define its functionality and functions
  • Update the Hubspot modules with the Hubspot API Key
  • Update the OpenAI modules with OpenAI API Key
  • Create an Airtable or any other database where you keep a reference between the thread id in Hubspot and Assistant API

If you need help deploying this solution don't hesitate to email me or schedule a call here.

CleanShot 20240420 at 16.23.15.png

Nodes used in this workflow

Over 3000 companies switch to n8n every single week

Airtable supported actions

Get Many
List all the bases
Get Schema
Get the schema of the tables in a base
Create
Create a new record in a table
Create or Update
Create a new record, or update the current one if it already exists (upsert)
Delete
Delete a record from a table
Get
Retrieve a record from a table
Search
Search for specific records or list all
Update
Update a record in a table

OpenAI supported actions

Create an Assistant
Create a new assistant
Delete an Assistant
Delete an assistant from the account
List Assistants
List assistants in the organization
Message an Assistant
Send messages to an assistant
Update an Assistant
Update an existing assistant
Message a Model
Create a completion with GPT 3, 4, etc.
Classify Text for Violations
Check whether content complies with usage policies
Analyze Image
Take in images and answer questions about them
Generate an Image
Creates an image from a text prompt
Generate Audio
Creates audio from a text prompt
Transcribe a Recording
Transcribes audio into the text
Translate a Recording
Translate audio into the text in the english language
Delete a File
Delete a file from the server
List Files
Returns a list of files that belong to the user's organization
Upload a File
Upload a file that can be used across various endpoints

Looking to integrate Airtable and OpenAI in your company?

Why use n8n to integrate Airtable with OpenAI

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon