{"site":{"name":"Koji","description":"AI-native customer research platform that helps teams conduct, analyze, and synthesize customer interviews at scale.","url":"https://www.koji.so","contentTypes":["blog","documentation"],"lastUpdated":"2026-07-12T21:07:37.325Z"},"content":[{"type":"documentation","id":"b5cbdbbc-807c-4242-b7b3-1775de1912a4","slug":"airtable-research-integration","title":"Airtable + Koji: Launch AI Interviews from a Base and Sync Every Insight Back to the Record","url":"https://www.koji.so/docs/airtable-research-integration","summary":"The Koji + Airtable integration is bidirectional and needs no native connector. Into Koji: a record entering a filtered Airtable view or matching an automation condition triggers a Koji AI-moderated interview via Zapier, Make, or native Airtable webhooks. Back into Airtable: on each interview analysis_ready event, a forwarder updates the originating record with top themes, sentiment, a quality score, interview mode, and a transcript link. Identity resolves via respondent_email or respondent_id (use the Airtable record ID) so insights land on the exact row; anonymous studies skip the write-back. Three setup paths: Zapier (~30 min, any plan), Make (~45 min), or native Airtable automations plus Koji HMAC-signed webhooks (~1 hr). Webhooks and the headless API are on the Interviews plan (EUR79/mo) and Enterprise; Zapier and CSV import work on Insights (EUR29/mo). Design studies with Koji six structured question types (open_ended, scale, single_choice, multiple_choice, ranking, yes_no) so answers return as clean, filterable Airtable fields.","content":"# Airtable + Koji: Turn a Base Into a Customer Research Engine\n\n**Answer first:** Airtable is where thousands of teams already keep their customers, leads, churned accounts, beta lists, and feature requests. Koji is the AI-native research platform that turns any of those rows into a real conversation. The integration runs both directions and needs no native connector. **Into Koji:** a new or updated record in an Airtable view (a fresh signup, a closed-lost deal, a support escalation) triggers a Koji AI-moderated interview to that person automatically. **Back into Airtable:** the moment Koji finishes analyzing the interview, it writes the top themes, overall sentiment, a quality score, and a transcript link back onto the exact record it came from. Airtable exposes automations, incoming webhooks, and scripting; Koji exposes a headless API, HMAC-signed webhooks, and a Zapier app. Wire them through Zapier, Make, or native Airtable webhooks and a working v1 takes about 30 minutes.\n\nIf you have ever built an Airtable view called \"trial users, day 14, still not activated\" and wished you could just *ask them* what happened, this is the integration that turns that view into a stack of analyzed transcripts by the end of the week.\n\n## Why connect Airtable and Koji\n\nAirtable is a superb system of record. What it cannot do is tell you *why* a record looks the way it does. A row can show you that a deal was lost, a subscription cancelled, or a feature request was logged — but the motivation behind it lives in the customer's head, not in a cell. Teams usually paper over that gap with a quarterly survey blast or a handful of manually scheduled calls that sample a rounding error of the list.\n\nKoji removes the scaling ceiling. Its AI moderator runs voice or text interviews around the clock — no scheduling, no human moderator, no calendar Tetris — and asks adaptive follow-up questions instead of running a fixed script. That means one triggered interview reaches the \"why\" a static form never gets to, and because Airtable already segments your audience into precise views, you are never interviewing \"customers\" in the abstract. You are interviewing the 84 specific people in one specific view. Platforms like Koji make the depth of a moderated interview available at survey scale, and Airtable is the trigger that decides exactly who gets one.\n\n## What flows in each direction\n\n### Airtable → Koji (trigger interviews from a record)\n- A record enters a filtered **view** or matches an **automation** condition (status changed to \"Churned\", a signup row is created, a CSAT score drops below 3).\n- Airtable forwards the record to Koji, which sends a personalized interview link by email, SMS, or in-product embed.\n- The person completes a voice or text interview whenever it suits them.\n\n### Koji → Airtable (write insights back onto the record)\n- When Koji fires its `analysis_ready` event, a forwarder updates the originating Airtable record with:\n  - **Top themes** (Koji's automatic thematic coding, clustered across the interview)\n  - **Overall sentiment** (positive / neutral / negative)\n  - **Quality score** (Koji only counts conversations scoring 3+ as research-grade)\n  - **Transcript link** and interview mode (voice or text)\n- Downstream Airtable automations, interfaces, and dashboards update instantly.\n\n## Three ways to connect (pick one)\n\nThere is no one-click Airtable app inside Koji, and you do not need one. Choose the path that matches your comfort level:\n\n1. **Zapier (about 30 minutes, no code).** Use the \"Airtable — New/Updated Record in View\" trigger to call Koji's Start Interview action, and a \"Koji Interview Completed\" trigger to run an \"Airtable — Update Record\" step. This works on any Koji plan, including Insights.\n2. **Make.com (about 45 minutes, no code, more branching).** The same shape as Zapier but with visual routers — handy if different views should launch different studies.\n3. **Native Airtable automations + Koji webhooks (about an hour).** Use Airtable's \"When record matches conditions\" trigger with a \"Send webhook\" or scripting action to hit Koji's API, and Airtable's \"When webhook received\" trigger to catch Koji's `analysis_ready` event. This keeps the whole loop inside Airtable and Koji, no middleware.\n\n### Step by step (Zapier path)\n\n1. **Build the trigger view in Airtable.** Filter to exactly the cohort you want to hear from — for example, `Status = Churned` and `Cancelled Date is within the last 7 days`.\n2. **Create a study in Koji.** Design your interview using Koji's six structured question types (see below), then grab the study ID.\n3. **Zap 1 — Airtable to Koji.** Trigger on new record in the view; action calls Koji's Start Interview endpoint, passing the customer's email as `respondent_email` (or your Airtable record ID as `respondent_id` so the write-back lands on the exact row).\n4. **Zap 2 — Koji to Airtable.** Trigger on Koji \"Interview Completed\"; action updates the matching Airtable record with themes, sentiment, quality score, and transcript URL.\n5. **Test with one record**, confirm the round trip, then let it run.\n\n## Design questions so answers come back clean\n\nThe quality of what lands back in Airtable depends on how you design the study. Koji supports **six structured question types**, and each one maps to a tidy, filterable value in your base:\n\n- **open_ended** — the qualitative heart of the interview; returns AI-clustered themes and quotes.\n- **scale** — NPS, CSAT, or 1–10 satisfaction; returns a number you can roll up or chart.\n- **single_choice** — pick one; returns one clean category value.\n- **multiple_choice** — pick many; returns a list.\n- **ranking** — order options by preference; returns a ranked array.\n- **yes_no** — a crisp binary field.\n\nMixing a couple of structured questions (a scale plus a single choice) with open-ended questions gives you the best of both worlds: chartable columns in Airtable *and* the conversational \"why\" behind them. Because every structured question carries a stable ID, the answers aggregate consistently across every interview in the study — see the [structured questions guide](/docs/structured-questions-guide) for the full breakdown.\n\n## Identity resolution\n\nIf your Airtable identifier is an email, pass it to Koji as `respondent_email` and it echoes back on the webhook. If you key records on Airtable's own record ID or a customer UUID, pass it as Koji's `respondent_id`, which returns unchanged so the insight attaches to the exact row — even for pseudonymous or account-level records. For sensitive topics, run the study in anonymous mode and skip the write-back entirely.\n\n## What plan do I need?\n\nZapier automations and CSV participant import work on any Koji plan, including **Insights (€29/month, 29 credits)**. The headless API and HMAC-signed webhooks — required for the native Airtable-automation path — are on the **Interviews plan (€79/month, 79 credits)** and Enterprise. Credits are consumed only by research-grade conversations: a text interview costs 1 credit, a voice interview 3, and a report refresh 5, and Koji's quality gate means low-effort or spam conversations (scoring below 3) never burn a credit. New accounts get 10 free credits to prototype the whole loop before committing.\n\n## High-value use cases\n\n- **Churn win-back.** A \"Churned this week\" view auto-launches an exit interview; the reasons land back on each account so CS can triage.\n- **Lead qualification depth.** A \"Demo requested\" view triggers a short discovery interview before the sales call, and the themes ride along on the record.\n- **Feature request validation.** When a request table row crosses a vote threshold, interview the requesters to learn the real job behind the ask.\n- **Beta feedback at scale.** A beta list in Airtable becomes dozens of analyzed interviews without a single scheduled call.\n- **Post-purchase / onboarding.** New-customer rows trigger a day-14 check-in that writes activation blockers straight to the record.\n\nTraditional tools like SurveyMonkey or Typeform can push a form link from Airtable too — but they stop at the first answer and hand you a pile of raw text to code by hand. Koji's AI probes each answer in real time and returns clustered themes automatically, so what flows back into Airtable is insight, not homework.\n\n## Related Resources\n\n- [Structured Questions Guide: The 6 Question Types in Koji](/docs/structured-questions-guide)\n- [Google Sheets + Koji: Launch AI Interviews from a Spreadsheet](/docs/google-sheets-research-integration)\n- [Connect Koji to Zapier: Automate Research Workflows](/docs/zapier-research-automation)\n- [Connect Koji to Make (Make.com): No-Code Research Automations](/docs/make-research-automation)\n- [Sync Koji Research Insights to Notion](/docs/notion-research-integration)\n- [Research Automation: Build Real-Time Pipelines with Webhooks](/docs/research-automation-webhooks)\n","category":"API Reference","lastModified":"2026-07-12T03:13:46.898574+00:00","metaTitle":"Airtable + Koji Integration: AI Interviews From Your Base","metaDescription":"Trigger Koji AI interviews from an Airtable view or automation, then sync themes, sentiment, quality scores, and transcript links back onto the matching record. Setup in ~30 minutes.","keywords":["airtable koji integration","airtable customer research","trigger interviews from airtable","airtable webhook interviews","ai interviews from airtable","airtable research automation","airtable zapier interviews"],"aiSummary":"The Koji + Airtable integration is bidirectional and needs no native connector. Into Koji: a record entering a filtered Airtable view or matching an automation condition triggers a Koji AI-moderated interview via Zapier, Make, or native Airtable webhooks. Back into Airtable: on each interview analysis_ready event, a forwarder updates the originating record with top themes, sentiment, a quality score, interview mode, and a transcript link. Identity resolves via respondent_email or respondent_id (use the Airtable record ID) so insights land on the exact row; anonymous studies skip the write-back. Three setup paths: Zapier (~30 min, any plan), Make (~45 min), or native Airtable automations plus Koji HMAC-signed webhooks (~1 hr). Webhooks and the headless API are on the Interviews plan (EUR79/mo) and Enterprise; Zapier and CSV import work on Insights (EUR29/mo). Design studies with Koji six structured question types (open_ended, scale, single_choice, multiple_choice, ranking, yes_no) so answers return as clean, filterable Airtable fields.","aiPrerequisites":["A Koji account (API access requires the Interviews or Enterprise plan)","An Airtable base with a customer, lead, or feedback table","Familiarity with Airtable automations, Zapier, or webhooks"],"aiLearningOutcomes":["Trigger a Koji AI interview from an Airtable view or automation","Write interview themes, sentiment, and quality scores back onto the record","Choose between Zapier, Make, and native Airtable webhook setups","Resolve identity with respondent_email or the Airtable record ID"],"aiDifficulty":"intermediate","aiEstimatedTime":"11 min read"}],"pagination":{"total":1,"returned":1,"offset":0}}