As a user of airtable and not a developer of an airtable app/plugin, the api calls are burdensome (dereferencing lookup fields, data types) and if you want to do any serious work on large bases, you hit rate limits/call limits very quickly.

They make it trivial to import/push data in but accessing it or pulling it out looks like an intentionally hindered dark design pattern (like egress on aws). I have resorted to writing extension scripts in their godforsaken nonstandard javascript framework to access and aggregate data before pushing it out. Accessing google sheets programmatically is a walk in the park, comparatively.