Airtable + bexio

Maintain updated Airtable records each time there are new or updated companies in bexio

Unleash the potential of bexio with direct integration with Airtable. With this workflow, each time a company is updated or a new one is added in bexio, a corresponding record is created or refreshed in Airtable. This automation is a perfect solution to smoothly manage your company data across both platforms, reducing manual work and promoting efficient data handling.

When this happens...
New/Updated Company
Triggers when a company is added or updated.
TriggerScheduled
automatically do this!
Create or Update Record
Updates an existing record if one exists, otherwise creates a new record.
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

What does this mean?

New/Updated Company
Triggers when a company is added or updated.
Trigger
Scheduled
Try It
- Status of Order
- Trigger each status changeRequired
Trigger
Scheduled
Try It
New Product
Triggers new Products.
Trigger
Scheduled
Try It
- Status of Quote
- Trigger each status changeRequired
Trigger
Scheduled
Try It
- Company NameRequired
- Department
- Number
- EMail
- Second EMail
- Address
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Phone
- Phone second
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Number of Staff
- Tax Nr
- Trade Register Number
- Url
- Contact Person
Action
Write

- Identifier For Existing PeopleRequired
- Person Id
- Last Name
- First Name
- Number
- Birthday (Format yyyy-mm-dd)
- E-Mail
- Second E-Mail
- Address
- Zip
- City
- Country
- Correspondence Type
- Group Ids
- Phone
- Second Phone
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Salutation Form
- Salutation Id
- Title Id
- Company Id
- Position
- Url
Action
Write
- Company or PersonRequired
- Company Contact Person
- Invoice Date
- Payment Due Date
- API Reference
- Invoice Title
- Invoice Status
- VAT included in the total
- Currency
- Bank Account
- Project
- Line Item Product Key
- Line Item Name/Id/CodeRequired
- Line Item QuantityRequired
- Line Item PriceRequired
- Line Item Text
- Line Item Discount in %
Action
Write

- InvoiceRequired
- Recipient MailRequired
- SubjectRequired
- MessageRequired
- Mark as pending
Action
Write
- Product TypeRequired
- NameRequired
- Description
- CodeRequired
- Remarks
- UnitRequired
- Sales PriceRequired
- CurrencyRequired
- Vat
Action
Write
- NameRequired
- Project TypeRequired
- Project StateRequired
- Company or PersonRequired
- Company Contact Person
- Start Date
- End Date
- Comment
Action
Write
- BillableRequired
- Business ActivityRequired
- Company or Person
- Company Contact Person
- Project
- Status
- TypeRequired
- Date
- Duration
- Start Time
- End Time
- Text
Action
Write
- Account NumberRequired
Action
Search
- Name
- ISO 3166
Action
Search
- Order Number
- API Reference
- Include Order PositionsRequired
Action
Search
- Name
- Code
Action
Search
- Quote Number
- API Reference
- Include Quote PositionsRequired
Action
Search
- Last NameRequired
- First NameRequired
- EMail
- Number
- Phone
- Mobile
- Birthday
- Second EMail
- Address
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Second Phone
- Fax
- Skype Name
- Language Id
- Remarks
- Salutation Form
- Salutation Id
- Title Id
- Company Id
- Position
- Url
- Contact Person
Action
Search or write
- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search or write

- Status of Invoice
- Trigger each status changeRequired
Trigger
Scheduled
Try It
New/Updated Person
Triggers when a person is added or updated.
Trigger
Scheduled
Try It
- State of Project
- Trigger each status changeRequired
Trigger
Scheduled
Try It
- Combined EntryRequired
- Automatic Reference Number
- Date (line item support)Required
- Reference Number (line item support)
- CurrencyRequired
- Debit Account Numbers (line item support)Required
- Credit Account Numbers (line item support)Required
- Vat (line item support)
- VAT Account
- Description (line item support)
- Amount (line item support)Required
Action
Write
- Last NameRequired
- First NameRequired
- Number
- Birthday
- EMail
- Second EMail
- Address
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Phone
- Second Phone
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Salutation Form
- Salutation Id
- Title Id
- Company Id
- Position
- Url
- Contact Person
Action
Write
- File to uploadRequired
- FilenameRequired
Action
Write
- InvoiceRequired
Action
Write
- Company or PersonRequired
- Company Contact Person
- Order Date
- API Reference
- Order Title
- VAT included in the total
- Project
- Line Item Name/IdRequired
- Line Item QuantityRequired
- Line Item PriceRequired
- Line Item Text
- Line Item Discount in %
Action
Write
- CodeRequired
- Name
- Description
- Remarks
- Sales Price
- Currency
- Vat
Action
Write
- Company or PersonRequired
- Company Contact Person
- Quote Date
- API Reference
- quote Title
- VAT included in the total
- Project
- Line Item Name/IdRequired
- Line Item QuantityRequired
- Line Item PriceRequired
- Line Item Text
- Line Item Discount in %
Action
Write
- Identifier For Existing CompanyRequired
- Company Id
- Name
- Department
- Number
- EMail
- Second EMail
- Address
- Zip
- City
- Country
- Correspondence Type
- Group Ids
- Phone
- Second Phone
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Number of staff
- Tax Nr
- Trade Register Number
- Url
Action
Write
- Name
- E-Mail
- Number
- Phone
- Mobile
Action
Search
- Invoice Number
- API Reference
- Include Invoice PositionsRequired
Action
Search
- Last Name
- First Name
- E-Mail
- Number
- Phone
- Mobile
Action
Search
- Project NameRequired
Action
Search
- Company NameRequired
- EMail
- Number
- Phone
- Mobile
- Department
- Second EMail
- Address
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Phone second
- Fax
- Skype Name
- Language Id
- Remarks
- Number of Staff
- Tax Nr
- Trade Register Number
- Url
- Contact Person
Action
Search or write
- NameRequired
- CodeRequired
- Product TypeRequired
- Description
- Remarks
- UnitRequired
- Sales PriceRequired
- CurrencyRequired
- Vat
Action
Search or write
- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
Action
Search or write

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 Help

Related categories

Databases

Similar apps

Quickbase

Databases

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About bexio

Bexio is a business platform for offering accounting, invoices, payroll, and more for small companies in Switzerland.

Learn more Help

Related categories

Accounting

PRODUCTS

CAPABILITIES

By team

Airtable + bexio

Maintain updated Airtable records each time there are new or updated companies in bexio

New/Updated Company

New Order

Status of Order

New Product

New Quotes

Status of Quote

Trigger each status changeRequired

Create Company

Company NameRequired

Department

Number

EMail

Second EMail

Address

Zip

City

Country

Correspondence Type

Categories

Sectors

Phone

Phone second

Mobile

Fax

Skype Name

Language Id

Remarks

Number of Staff

Tax Nr

Trade Register Number

Url

Contact Person

Update Person

Identifier For Existing PeopleRequired

Person Id

Last Name

First Name

Number

Birthday (Format yyyy-mm-dd)

E-Mail

Second E-Mail

Address

Zip

City

Country

Correspondence Type

Group Ids

Phone

Second Phone

Mobile

Fax

Skype Name

Language Id

Remarks

Salutation Form

Salutation Id

Title Id

Company Id

Position

Url

Create a Sales Invoice

Company or PersonRequired

Company Contact Person

Invoice Date

Payment Due Date

API Reference

Invoice Title

Invoice Status

VAT included in the total

Currency

Bank Account

Project

Line Item Product Key

Line Item Name/Id/CodeRequired

Line Item QuantityRequired