Airtable + SQL Server

Create or update Airtable records from new SQL Server rows with custom query

Keep your Airtable records updated with this workflow. Whenever a new row is added to your SQL Server using a custom query, it triggers an update or creation of a record in your Airtable. This convenient automation reduces manual data transfers and keeps your information in Airtable timely and accurate. With consistent updates happening seamlessly in the background, you can focus on other areas of productivity.

When this happens...
New Row (Custom Query)
Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
automatically do this!
Create or Update Record
Find and update an existing record, or create a new one.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- Disclaimer Copy
- QueryRequired
Action
Write
- TableRequired
- ID ColumnRequired
Action
Write

- QueryRequired
Action
Search
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Polling
Try It

- BaseRequired
- TableRequired
- RecordRequired
- CommentRequired
Action
Write
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Number of RecordsRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- Search KeywordRequired
- Search In
Action
Search
- Search KeywordRequired
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- BaseRequired
- TableRequired
Action
Write
- NameRequired
- Workspace IDRequired
- Number of TablesRequired
Action
Write
- BaseRequired
- Table NameRequired
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Record IDRequired
Action
Search
- BaseRequired
- Table IDRequired
Action
Search
- BaseRequired
Action
Search

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more