Attachments are filed into a human filing system — the Airtable field a file came from names its drawer — and uploaded to Drive, where scanned PDFs are OCRed and indexed. “Which bill of lading mentions this container” becomes a search box.
Records go to BigQuery as one clustered table with a search index, or to Postgres if you want a system of record rather than an archive.
Nothing leaves Airtable until you have seen the inventory and accepted the quote. Every phase is resumable: kill it anywhere, run it again, and it picks up without duplicating a byte.
What it counts
Every function reports what it consumed, and only your plan turns that into money. Airtable → Google counts:
- records
- GB of attachments
- operator minutes — counted, never billed
- GB moved (flat-rate link) — counted, never billed
- GB moved (metered network) — counted, never billed