How to Automate Airtable

Airtable is the database an operations team can actually build

Airtable is a database that looks enough like a spreadsheet that people who would never open a database will build one. That single fact explains most of where it ends up.

The teams using it are operations, marketing, production and HR, not engineering. They build the thing nobody would ever get budget to have built: an applicant tracker, a content calendar, an inventory of equipment, a pipeline of properties, a register of every machine on site and when it was last serviced.

What they get is real structure. Linked records, so a supplier connects to its orders. Views, so the same data is a grid for one person and a calendar for another. Forms, so somebody outside the team can add a row without touching the base.

It works well enough that within a year it holds something the business genuinely depends on.

The base is only as current as its last paste

A base earns its keep by being accurate, and accuracy is where the manual work hides.

Somebody exports a CSV from the ordering system every Monday and imports it. Somebody checks four supplier sites for lead times and updates a column. Somebody opens the applicant tracking system, reads which candidates moved stage, and mirrors that into the base the team actually looks at.

It is a strange kind of work: high consequence and no skill. If it is skipped for a fortnight nothing appears to break, and then a decision gets made on a stale number and the base loses the team's trust for good.

Once people stop believing the base, they go back to asking each other, and the whole thing quietly becomes a very tidy museum.

Automations and syncs stop at the connector list

Airtable is far from passive, and inside its own boundaries it is strong.

Automations trigger when a record is created, updated, or matches a condition, and then send email, update other records, post to chat or run a script. The scripting extension runs JavaScript against the base. Sync pulls a table from another base or from a product Airtable has built a connector for, and keeps it updated. Interfaces put a usable front end on top for people who should never see the raw grid.

All of that is triggered by something happening in the base, or by a product that already publishes an API and got a connector built for it.

The systems that hold most operational reality tend to have neither. The industry package the company runs on, the supplier portal, the customer's extranet, the government site with the licence status. Those are exactly the sources people paste in by hand, week after week.

The base can fill itself from anywhere you can log in

A connector list is a list of the systems somebody else decided to support. Your base can know more than that.

The orders that came in overnight, read from a system that only ever shows them on screen, written in as rows. Lead times checked across every supplier you buy from, updated in place, with the ones that moved marked. Candidate stages mirrored from the recruiting system so the base and the source agree by nine each morning.

The equipment register updated with the service dates the maintenance portal holds. The property pipeline updated with the listings that changed price. The compliance table updated with which certificates now expire inside ninety days.

One habit is worth adopting early: write incoming data to its own table that only the automation touches, and let your working views read from it. Then a bad run can never overwrite something a person typed, and you can compare the two when a number looks wrong.

Data entry is the part worth handing over

The judgement in a base is in how it is structured and what gets decided from it. Keeping the rows current is not judgement, it is transcription.

WebRun is an agent that works a real Chrome browser, signed in as you. It opens the ordering system, the portal or the industry package that has no API, reads what is on the screen, and writes the rows into your base.

It runs on your schedule in your own private environment, and you can watch a run and stop it mid-way. Anything that would message a person outside the team drafts and waits.

The workflows below are already built, and each one names the apps it touches.