migrate_airtable

This module provides a Migration Source for Airtable bases that helps programmers create migrations from Airtable into Drupal.

Airtable is a flexible spreadsheet/database solution that makes an excellent tool for staging a content inventory or cleaning up your data before migrating it into Drupal. With this module, you can map tables, relationships, and file information from Airtable into Drupal entities, relationships, and media.

Features

Import records from any of your Airtable bases into any Drupal entity type:

• Supports Airtable views and filters
• Automatically populates Source fields list, making it quick to create mappings
• Allows you to maintain relationships from Airtable's linked records into Drupal's entity reference fields
• Respects Airtable’s API limits of 5 requests per second

Post-Installation

After creating and setting up an API key with Airtable, you can create migration files that look like this against the Articles table in a base named 'Content Migration Example'

id: articles
label: "Articles from Airtable"
source:
  plugin: airtable
  base: 'Content Migration Example'
  table: 'Articles'
  constants:
    uid: 1
    body_format: basic_html
destination:
  plugin: entity:node
  default_bundle: article
process:
  title: Title
  uid: constants/uid
  body/value: Body
  body/format: constants/body_format

Requirements

This module requires Migrate Plus and some familiarity with setting up a migration.