Back to Integrations
integrationAirtable node
integrationOpenAI node

Airtable and OpenAI integration

Save yourself the work of writing custom integrations for Airtable and OpenAI and use n8n instead. Build adaptable and scalable Data & Storage, AI, and Langchain workflows that work with your technology stack. All within a building experience you will love.

How to connect Airtable and OpenAI

  • Step 1: Create a new workflow
  • Step 2: Add and configure nodes
  • Step 3: Connect
  • Step 4: Customize and extend your integration
  • Step 5: Test and activate your workflow

Step 1: Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Airtable and OpenAI integration: Create a new workflow and add the first step

Step 2: Add and configure Airtable and OpenAI nodes

You can find Airtable and OpenAI in the nodes panel. Drag them onto your workflow canvas, selecting their actions. Click each node, choose a credential, and authenticate to grant n8n access. Configure Airtable and OpenAI nodes one by one: input data on the left, parameters in the middle, and output data on the right.

Airtable and OpenAI integration: Add and configure Airtable and OpenAI nodes

Step 3: Connect Airtable and OpenAI

A connection establishes a link between Airtable and OpenAI (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.

Airtable and OpenAI integration: Connect Airtable and OpenAI

Step 4: Customize and extend your Airtable and OpenAI integration

Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Airtable and OpenAI with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Airtable and OpenAI integration: Customize and extend your Airtable and OpenAI integration

Step 5: Test and activate your Airtable and OpenAI workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Airtable to OpenAI or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.

Airtable and OpenAI integration: Test and activate your Airtable and OpenAI workflow

Enrich Property Inventory Survey with Image Recognition and AI Agent

This n8n workflow assists property managers and surveyors by reducing the time and effort it takes to complete property inventory surveys.

In such surveys, articles and goods within a property may need to be captured and reported as a matter of record. This can take a sizable amount of time if the property or number of items is big enough.

Our solution is to delegate this task to a capable AI Agent who can identify and fill out the details of each item automatically.

How it works

  • An AirTable Base is used to capture just the image of an item within the property
  • Our workflow monitoring this AirTable Base sends the photo to an AI image recognition model to describe the item for purpose of identification.
  • Our AI agent uses this description and the help of Google's reverse image search in an attempt to find an online product page for the item.
  • If found, the product page is scraped for the item's specifications which are then used to fill out the rest of the details of the item in our Airtable.

Requirements

  • Airtable for capturing photos and product information
  • OpenAI account to for image recognition service and AI for agent
  • SerpAPI account for google reverse image search.
  • Firecrawl.dev account for webspacing.

Customising this workflow

Try building an internal inventory database to query and integrate into the workflow. This could save on costs by avoiding fetching new each time for common items.

Nodes used in this workflow

Popular Airtable and OpenAI workflows

OpenAI Chat Model node
Airtable node
+5

Enrich Property Inventory Survey with Image Recognition and AI Agent

This n8n workflow assists property managers and surveyors by reducing the time and effort it takes to complete property inventory surveys. In such surveys, articles and goods within a property may need to be captured and reported as a matter of record. This can take a sizable amount of time if the property or number of items is big enough. Our solution is to delegate this task to a capable AI Agent who can identify and fill out the details of each item automatically. How it works An AirTable Base is used to capture just the image of an item within the property Our workflow monitoring this AirTable Base sends the photo to an AI image recognition model to describe the item for purpose of identification. Our AI agent uses this description and the help of Google's reverse image search in an attempt to find an online product page for the item. If found, the product page is scraped for the item's specifications which are then used to fill out the rest of the details of the item in our Airtable. Requirements Airtable for capturing photos and product information OpenAI account to for image recognition service and AI for agent SerpAPI account for google reverse image search. Firecrawl.dev account for webspacing. Customising this workflow Try building an internal inventory database to query and integrate into the workflow. This could save on costs by avoiding fetching new each time for common items.
HTTP Request node
Code node
+4

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.
HTTP Request node
Merge node
Code node
+5

Create LinkedIn Contributions with AI and Notify Users On Slack

This workflow automates the process of gathering LinkedIn advice articles, extracting their content, and generating unique contributions for each article using an AI model. The contributions are then posted to a Slack channel and a NocoDB database for record-keeping. The workflow is triggered weekly to ensure new articles are continuously collected and responded to. Who is this for? This workflow is designed for professionals, marketers, and content creators looking to boost their LinkedIn presence by regularly engaging with LinkedIn advice articles. It’s especially useful for those who want to be seen as a "thought leader" or "top voice" in their niche by contributing relevant and unique advice to trending topics. What problem is this workflow solving? Manually searching for relevant LinkedIn articles, reading through them, and crafting thoughtful contributions can be time-consuming. This workflow solves that by automating the process of finding new articles, extracting key content, and generating AI-powered contributions. It helps users stay consistently active on LinkedIn, contributing value to trending discussions. What this workflow does Triggers Weekly: The workflow is set to run every Monday at 8:00 AM. Search Google for LinkedIn Advice Articles: Uses a predefined Google search URL to find the latest LinkedIn advice articles based on the user's area of expertise. Extract LinkedIn Article Links: A code node extracts all LinkedIn advice article links from the search results. Retrieve Article Content: For each article link, the workflow retrieves the HTML content and extracts the article title, topics, and existing contributions. Generate AI-Powered Contributions: The workflow sends the extracted article content to an AI model, which generates unique, helpful advice for each topic within the article. Post to Slack & NocoDB: The AI-generated contributions, along with the article links, are posted to a designated Slack channel and stored in a NocoDB database for future reference. Setup Google Search URL: Update the Google search URL with the relevant LinkedIn advice query for your field (e.g., "site:linkedin.com/advice 'marketing automation'"). Slack Integration: Connect your Slack account and specify the Slack channel where you want the contributions to be posted. NocoDB Integration: Set up your NocoDB project to store the generated contributions along with the article titles and links. How to customize this workflow Change Search Terms**: Modify the Google search URL to focus on a different LinkedIn topic or expertise area. Adjust Trigger Frequency**: The workflow is set to run weekly, but you can adjust the frequency by changing the schedule trigger. Enhance Contribution Quality**: Customize the AI model's prompt to generate contributions that align with your brand voice or content strategy. Workflow Summary This workflow helps users maintain a consistent presence on LinkedIn by automating the discovery of new advice articles and generating unique contributions using AI. It is ideal for professionals who want to engage with LinkedIn content regularly without spending too much time manually searching and drafting responses.

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.

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

FAQs

  • Can Airtable connect with OpenAI?

  • Can I use Airtable’s API with n8n?

  • Can I use OpenAI’s API with n8n?

  • Is n8n secure for integrating Airtable and OpenAI?

  • How to get started with Airtable and OpenAI integration in n8n.io?

Looking to integrate Airtable and OpenAI in your company?

Over 3000 companies switch to n8n every single week

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