n8n

How to Connect Obsidian Airtable Data Queries?

Ask questions in Obsidian and get answers from your Airtable records using AI. Good for teams who write in Obsidian and store product lists, CRM data, or content ideas in Airtable. You receive clear answers inside the same note with no tab switching.

An Obsidian plugin sends your selected text to an n8n webhook. The AI Agent uses an OpenAI chat model to understand the question and runs an Airtable search on the chosen base and table. The result is turned into a short, helpful reply. A response node sends the text back so it appears under your selection in Obsidian. This reduces context switching, speeds up research, and keeps answers tied to live Airtable data.

You need an OpenAI API key, an Airtable personal access token, and a plugin in Obsidian that can post to a webhook. Set your Airtable base and table in the Airtable node and keep the agent text mapped to the webhook body. Expect lookup time to drop and note quality to rise. Useful for product info checks, CRM record lookups, internal lists, and content planning directly from notes.

What are the key features?

  • Webhook trigger receives selected text from Obsidian and starts the flow
  • AI Agent interprets the question and routes actions without manual steps
  • OpenAI chat model gpt 4o mini understands natural language questions
  • Airtable search runs on a specific base and table to fetch relevant rows
  • Response to Webhook returns a clean text answer back to the note
  • Dynamic mapping uses the webhook body so any highlighted text becomes the prompt

What are the benefits?

  • Reduce manual lookups from 10 minutes to under 1 minute per question
  • Cut context switching by 90% by answering inside Obsidian
  • Automate 80% of repetitive data questions from notes
  • Improve data accuracy by 90% by pulling live Airtable records
  • Connect Obsidian, Airtable, and AI in one simple flow

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 the n8n credentials manager, create a new Airtable credential. Use a Personal Access Token from your Airtable account with read access to the target base. Name the credential clearly, for example Airtable PAT Obsidian Lookup.
  4. Open the Airtable node in the workflow. Select your Airtable credential, choose the correct base and table, and keep Operation set to Search. Set any default search fields if needed.
  5. In the n8n credentials manager, create a new OpenAI credential using your API key from the OpenAI dashboard. Name it so you can recognize it later.
  6. Open the OpenAI Chat Model node and select your OpenAI credential. Keep the model set to gpt 4o mini or choose another model that fits your plan and budget.
  7. Open the AI Agent node. Confirm Text is set to the webhook body content so highlighted text from Obsidian becomes the prompt. Ensure the Airtable tool and the OpenAI model are connected to the agent.
  8. Open the Webhook node. Copy the Production URL after you activate the workflow. Keep Response Mode set to Response Node since the Respond node will send the final text back.
  9. In Obsidian, install a plugin that can post selected text to a webhook and paste the n8n webhook URL into the plugin settings. Save the settings.
  10. Activate the workflow in n8n. In Obsidian, highlight a question about your Airtable data and send it to the webhook. Check the note for the reply and review the n8n execution log for details.
  11. Troubleshoot common issues: If you get no data, verify the Airtable base and table IDs and your token permissions. If the reply is empty, confirm the highlighted text is passed in the request body. If there is a timeout, try shorter queries or confirm your webhook response is controlled by the Respond node.

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.