n8n

How to Connect Obsidian Airtable Data Search?

Get quick answers from your Airtable base without leaving your notes. Write a question in Obsidian, send it with a command, and get an AI reply based on live Airtable records. Ideal for teams that store project data in Airtable and plan work in Obsidian.

A webhook receives your selected text from Obsidian and passes it to an AI Agent that uses an OpenAI chat model. The agent calls an Airtable search on a chosen base and table, reads the results, and turns them into a clear answer. A respond node sends the text back through the webhook so the reply appears in your note. The flow keeps context inside your document and removes the need to switch apps.

You will need an OpenAI API key, an Airtable personal access token, and the Obsidian Post Webhook plugin. After connecting credentials and setting the base and table, replies arrive in seconds and cut copy and paste work. Helpful for content briefs, task status checks, and quick data lookups directly inside your notes.

What are the key features?

  • Webhook trigger captures your selected text from Obsidian and sends it to n8n via POST
  • AI Agent uses an OpenAI chat model to understand the question and plan the lookup
  • Airtable tool runs a Search operation on a specific base and table to fetch records
  • The agent converts raw records into a short, readable answer for your note
  • Respond to Webhook returns the text reply so it appears directly below your selection
  • Response mode targets the response node to ensure the answer is delivered back to Obsidian

What are the benefits?

  • Reduce lookup time from 10 minutes to under 1 minute per question
  • Automate up to 80% of repetitive database searches done in notes
  • Eliminate most copy and paste errors by using live Airtable data
  • Connect Obsidian, Airtable and OpenAI in one seamless flow
  • Support many daily requests through a single webhook endpoint

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Obsidian, Airtable and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. In Airtable, create a Personal Access Token with read access to the base that holds your data.
  4. In the n8n credentials manager, create a new Airtable credential using the token. Name it clearly so you can find it later.
  5. Open the Airtable node in the workflow, select your Airtable credential, choose the correct base and table, and keep the operation set to Search.
  6. In your OpenAI account, create an API key from the API settings page.
  7. In the n8n credentials manager, create a new OpenAI credential with that API key.
  8. Open the OpenAI Chat Model node and select your OpenAI credential. Keep the model as gpt 4o mini or choose another model you prefer.
  9. Open the AI Agent node and confirm the language model connection is set to the OpenAI node and the text field is {{$json.body.content}} so it uses the selected text from Obsidian.
  10. Open the Webhook node and copy the Production URL. Ensure the response mode is set to Response node and that it connects to the Respond to Webhook node.
  11. In Obsidian, install and enable the Post Webhook plugin. Paste the n8n webhook URL into the plugin settings, set the method to POST, and confirm the body sends the selection as a content field.
  12. Highlight a test question in Obsidian and run the plugin command to send the selection. Check that a reply appears under your text within a few seconds.
  13. If you see a 401 error, verify your Airtable and OpenAI keys in the n8n credentials manager. If you see a 404, confirm the exact webhook URL and path. If no reply returns, check that the Respond to Webhook node is connected and review the n8n execution logs for errors.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Obsidian

Sign up

Free: $0 (Obsidian is free for all purposes; no API plan required to use plugins/webhooks with n8n)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Credits:
YouTube video

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.