Special event tracker to the city database
Each night, rows from the parks department's event tracker are upserted into a SQL Server table so reporting tools see them with everything else.
Office & spreadsheetsConnector
Airtable integration
for city teams
Airtable is a spreadsheet-style database that many city teams use for small trackers: event permits, grant pipelines, volunteer rosters or project lists that never got a full system. It stores rows as records in tables inside a base.
Pre-built connector
Airtable
- Tier
- Pre-built connector
- Category
- Office & spreadsheets
- Sign-in
- API token (Bearer)
- Paging
- cursor
§ Overview
What connecting Airtable does.
SentraBridge reads, creates and updates records in any Airtable table. A department's tracker can feed the city database, pick up records from 311 or permitting, or send summaries by email. Records pass straight through; SentraBridge keeps only counts and IDs from each run.
- Records: Read all records in a table for each run.
- New records: Create one record per incoming record, with fields mapped by name.
- Updates: Update fields on existing records by Airtable record ID.
What SentraBridge can do with Airtable
| resource | read | write | changes only | fields |
|---|---|---|---|---|
| Records (set table) | list, read one | create, update | — | Record ID, Created, Fields |
§ Use cases
What cities connect Airtable for.
311 requests into a project base
Sentra 311 requests of one type, like graffiti or illegal dumping, are added to an Airtable base a small team already works from.
Grant tracker to finance
Grant records marked awarded are copied to a Google Sheet or a database table that the finance office reconciles against.
Weekly summary to managers
Every Monday, open records are counted by status and emailed to the department head with a CSV attached.
§ How it works
How to connect Airtable
- 01Get accessCreate an Airtable personal access token in the account that owns the base.
- 02Add the connectionGive it data.records:read, plus data.records:write if flows add or change records.
- 03Preview real recordsLimit the token to the one base SentraBridge should use.
- 04Turn it onSet the base and table in the connection, then preview a few rows.
§ Often connected with
Airtable and the rest of city hall.
Systems cities commonly connect with Airtable, each with its own connector page.
Sentra 311§ FAQ
Airtable integration questions
Does Airtable have an API?
Yes. Airtable's Web API lets you list, create and update records in a base, signed in with a personal access token.
Can Airtable sync with SQL Server?
Yes. A SentraBridge flow can read Airtable records and upsert them into a SQL Server table on a schedule, or read database rows and write them to Airtable.
Is our Airtable data copied to SentraBridge?
No. Records are read and written in memory during a run. Run history shows how many records moved and their IDs, not the field values.
§ Next
Related connectors
Connect Airtable to the rest.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.