Move workflow data in and out of an Airtable base

airtable-integration bridges a Trickest workflow and an Airtable base. The import subcommand pushes a JSON file into a named table and can link the new records to rows in another table by a shared field; the export subcommand pulls a table back out and resolves those links, so you get expanded related fields instead of bare record IDs.

A config file of jq queries maps each Airtable column to a query against your input JSON, so you shape raw findings into the exact fields a base expects without writing glue code. Filtering exports with an Airtable formula, capping returned rows with --max-records, choosing columns with --fields, and updating existing rows by a primary field keep repeated syncs idempotent instead of piling up duplicates. The tool batches writes and respects Airtable's API rate limits.

Reach for it at the edges of a pipeline: drop it at the end to publish results into a base the team already sorts and comments in, or at the start to pull a filtered target list out of Airtable and drive discovery from it. It reads JSON or a list as a file and writes a file and a folder for downstream nodes.