Airtable + Orcabase
Your Airtable bases, in plain answers.
Run operations in Airtable? Sync the bases you pick through Fivetran and ask across them in plain words: stock, suppliers, partners, content. Then put them next to the rest of your business.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which coffees will run out in the next two weeks?
Two coffees run out within 14 days: Ethiopia Guji and the house decaf.
- Guji has 9 days left at August’s pace.
- Decaf has 12 days; its sales doubled since the cold brew launch.
- Everything else covers at least five weeks.
Days of stock left
How I got this· 4 steps
- Read the Stock table in your Airtable base
- Averaged each coffee’s daily sales from August orders
- Divided stock on hand by daily sales
- Flagged anything under 14 days
Example answer. Numbers are illustrative.
In plain words
Can I build reports across Airtable bases?
Yes. Airtable is great for running a process and awkward to report across. Fivetran copies the bases you pick into a database Orcabase hosts for you, and keeps the copy up to date.
Then you ask in plain words, across bases, and next to your store or payments data, and get the answer with a chart.
Ask in plain words
What you can ask about your Airtable data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
Which items are running low?
How many orders did each wholesale partner place this quarter?
Which projects are overdue, and who owns them?
How many posts did we publish each month?
Which purchase orders are still open?
Which suppliers deliver late most often?
How many candidates reached an interview this month?
Show me records added per week, by base.
What comes in
Your Airtable data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
The bases you pick
Every field
Linked records
Only what you pick
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Airtable data.
Days of stock
Stock on hand divided by average daily sales.
On-time delivery
Share of purchase orders that arrived by their due date.
Open items
Records not yet marked done, by owner or status.
Throughput
Records moved to done each week.
Dashboards to start with
Your Airtable numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Operations
3 charts- Days of stock by item
- Open purchase orders
- On-time delivery by supplier
Team
3 charts- Open items by owner
- Done each week
- Overdue items
Better together
Ask across Airtable and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect Airtable, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Airtable. Pick the database to sync into.
- 2
Connect Airtable on Fivetran’s page
Click Authorize on Fivetran’s page, sign in to Airtable, and choose the bases or workspaces to share.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Airtable data.
What you’ll need
- An Airtable account with access to the bases you want.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Does each base come in separately?
Can Orcabase change my Airtable data?
Do I need a Fivetran account?
How fresh is my Airtable data in Orcabase?
What does syncing cost?
Your Airtable data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.