Connect Airtable to Silo
Airtable is where your team tracks the work: projects, clients, content and everything in between. Turning those bases into reporting usually means exports, copied views and formulas that drift out of date.
What we sync from Airtable
Silo syncs every table in the bases you choose, keeps linked records connected and reads each field with its current name and type. Ask how work is progressing, where it is stuck and how it compares with the rest of your data.
Table records
One row per record in every table of the bases you select, with a typed column for each field. Formula and rollup fields keep Airtable's computed results. Deleted records and cleared cells disappear on the next refresh.
Bases, tables and fields
The current names, descriptions and types of your bases, tables and fields, so reports follow your Airtable structure as it changes.
Linked records
One row per linked-record reference, preserving the order Airtable returns, so related records in different tables can be joined.
Record comments
Comments, replies, authors, mentions and reactions, included when Airtable grants comment access. Attachment links expire and files are not downloaded.
How it works
Connect Airtable once and Silo handles the rest, from sync to dashboards.
Connect your data
Securely connect Airtable and Silo syncs your records into your own managed warehouse, automatically.
Ask in plain English
Ask Aggie questions about the operation the way you'd ask a colleague: no formulas, no SQL, no spreadsheets.
Get instant dashboards
Get back charts and reports you can save, share and revisit as your data keeps syncing in the background.
Questions & answers
How should I interpret these reports?
Work in progress: Count records by status, owner or any single-select field, and compare how long work takes using your own date fields. Silo syncs current values, not revision history. Linked-record rollups: Group projects by client, tasks by project or bookings by venue by following linked records between tables.
How do I connect Airtable?
Use an Airtable account with access to the bases you want to report on. 1. Open Apps in Silo and add Airtable. 2. Sign in to Airtable and grant access to the bases you want to analyse. Read access is enough. 3. Select the bases to sync. All their tables are included, plus record comments when Airtable grants comment access. 4. Add context about your data and start the sync. Reconnect Airtable if the authorising user loses access or the connection expires after a long period of inactivity.
Which bases and tables are synced?
The bases you select during setup. Every table in those bases is included, and new tables and fields are picked up on the next refresh.
How often does Airtable data refresh?
Every six hours by default. Each refresh reads every record in your selected bases. Contact us if you need a different schedule.
Will syncing use my Airtable API allowance?
Yes. Free workspaces allow 1,000 API calls a month and Team workspaces 100,000. Records are read in pages of up to 100, and schema and comment requests also count. Other integrations share the same allowance, so a large base may need a less frequent schedule.
Does Silo keep a history of changes?
No. Silo syncs the current state of each record. Deleted records and cleared cells disappear on the next refresh.
Will Silo change my Airtable data?
No. Silo only needs read access to your bases. It does not write to Airtable or add webhooks.