Impora Documentation

Impora validates spreadsheet data before it is imported into Airtable. Connect your Airtable account, create a template, and define how incoming data should be handled.

1. 1

   Connect Airtable

   Connect the Airtable account that owns your base.

2. 2

   Create a template

   Choose a base and table and save the structure.

3. 3

   Map your columns

   Match spreadsheet headers to Airtable fields.

4. 4

   Validate before import

   Review errors before submission.

5. 5

   Share or automate

   Use links or connectors for repeat workflows.

Impora reads your Airtable field names and types automatically. Spreadsheet columns are matched by name where possible. You can override any mapping manually and save it as part of the template.

See how column mapping works when you import CSV into Airtable.

Every row is checked against your Airtable schema before import. Required fields, email formats, single select options, and linked record values are all validated. Errors are shown inline with clear descriptions so uploaders can fix issues before submitting.

This applies to all supported formats — learn more about Excel to Airtable imports.

Impora resolves linked record values against existing records in your base. If a value matches an existing record, it is linked automatically. If no match is found, the row is flagged for review.

For a detailed walkthrough, see linked records import in Airtable.

Connectors link Impora to cloud storage and email handoff channels. Once connected, files can be imported, exported, or roundtripped through saved Airtable templates. Supported channels: Google Drive, SharePoint, OneDrive, and Email Inbox.

Pick any folder in your connected cloud storage. Impora creates _processed and _errors subfolders automatically on the first run. You do not need to create them yourself.

Connectors support import, export, webhook-triggered export, manual export, and roundtrip modes across cloud folders and email handoff where available.

Webhook exports let you trigger Airtable-to-cloud exports from Airtable automations. This is useful when you want exports driven by your own Airtable logic rather than a fixed schedule.

1. 1

   Configure a connector

   Set the connector mode to Export or Roundtrip in the Impora admin.

2. 2

   Generate a webhook secret

   In the connector settings, click Generate Webhook Secret. Copy the URL and secret. The secret is shown once and cannot be retrieved later.

3. 3

   Create an Airtable automation

   In your Airtable base, create a new automation with your preferred trigger (e.g. when a record matches conditions).

4. 4

   Add a Run Script action

   Paste the pre-built script from the Impora admin. Replace YOUR_SECRET_HERE with the secret you copied.

5. 5

   Test the automation

   Run the automation manually in Airtable. Check your cloud folder for the exported CSV.

const TRIGGER_URL = 'https://app.impora.app/api/connectors/template/{templateId}/export-trigger';
const SECRET      = 'YOUR_SECRET_HERE';

const response = await fetch(TRIGGER_URL, {
  method: 'POST',
  headers: {
    'Authorization': `Bearer ${SECRET}`,
    'Content-Type': 'application/json',
  },
});

const body = await response.json();

if (!response.ok) {
  throw new Error(`Export trigger failed: ${response.status}`);
}

console.log('Export triggered:', body);

This section will grow as common issues are identified. If you run into a problem, contact us at [email protected] and we will help.