Boardfeed

Import guide

Import Airtable records into monday.com on a schedule

Airtable often holds the operational list that has not moved to monday.com yet — suppliers, inventory, a content calendar. The two tools end up living side by side, and the link between them is somebody’s copy-paste.

Boardfeed reads a table or a view on a schedule and keeps a monday.com board in step with it, mapping Airtable’s field types onto monday.com column types.

Doing it by hand, every time

  1. Open the base, download the CSV for the view, and re-upload it.
  2. Fix the columns where linked records came through as record ids.
  3. Delete the previous rows or accept the duplicates.
  4. Keep doing it as long as the base stays in use.

The scheduled route

  1. Connect Airtable with a personal access token scoped to the base you want.
  2. Pick the base, the table and — optionally — the view, so only the filtered rows are imported.
  3. Map the fields to board columns and choose the key for upsert.
  4. Schedule it. Importing a view means the filter, not the importer, decides which rows are in scope.

Field mapping notes for Airtable

This is the part that decides whether an import works on the first try. Everything below is handled in the mapping step, before a run is scheduled.

  • Record ids: every Airtable record has an id that is stable for the life of the record. It is the safest upsert key.
  • Field types: single select, text, number, date and checkbox map directly. Linked records come back as arrays of record ids, which are best mapped to a text column or resolved through a second table.
  • Attachments: returned as arrays of URLs and filenames, so they map to a link or a long-text column rather than to a file column.
  • Empty fields: Airtable omits fields that have no value, so a blank cell does not clear a monday.com column unless you map it to a clearing behaviour.
  • Formulas and rollups: read as their calculated values, which is usually what the board wants.

Airtable import questions

Can I import only part of a table?
Yes. Point the import at a view and the rows in that view are the rows that import — the filter lives in Airtable where the team already maintains it.
What happens to rows deleted in Airtable?
They stay on the board. Boardfeed will not delete monday.com items because a record disappeared upstream; a board that silently loses items is worse than one that is slightly out of date.
Which token scope do I need?
A personal access token with read access to the base you are importing. Nothing else is required.

Other sources