Airtable + Simpro

Create or update Airtable records for new individual customers from Simpro

Easily manage your customer information in Simpro and Airtable with this efficient workflow. Whenever a new individual customer is added in Simpro, this automation will instantly create or update a record in Airtable. Stay organized and ensure all your customer data is up-to-date across platforms with this seamless process.

When this happens...
New Individual Customer
Triggers when an individual customer is created.
TriggerInstant
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

New Company Customer
Triggers when a company customer is created.
Trigger
Instant
Try It
New Individual Customer
Triggers when an individual customer is created.
Trigger
Instant
Try It
New Job
Triggers when a job is created.
Trigger
Instant
Try It
New Quote
Triggers when a quote is created.
Trigger
Instant
Try It
New Schedule
Triggers when a job, lead, quote or activity schedule is created.
Trigger
Instant
Try It

New Site
Triggers when a site is created.
Trigger
Instant
Try It
- Company NameRequired
- Preferred Techs
- Phone
- Do Not Call
- Alt Phone
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
- Email
- EIN
- Website
- Fax
- Company Number
Action
Write

- Title
- Given NameRequired
- Family NameRequired
- Preferred Techs
- Phone
- Do Not Call
- Alt Phone
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
- Email
- Cell Phone
Action
Write
- CustomerRequired
- SiteRequired
- Cost CenterRequired
- Customer Contact
- Additional Contacts
- Site Contact
- Description
- Notes
- Salesperson
- Project Manager
- Technicians
- Date Issued
- Due Date
- Validity Days
- Order No
- Name
- Stage
- Year
- Month
- Percent
- Status
- Tags
- Auto Adjust Status
- Catalog
- Billable Status
- Estimated Time
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Quantity
- Income Account
- Type
- Rate
- Markup
- Sales Tax Code
- Time (Hours)
- Income Account
- Type
- Billable Status
- Description
- Estimated Cost
- Markup
- Estimated Time
- Sales Tax Code
- Actual Cost
- Actual Cost Date
- Sell Price
- Quantity
- Income Account
- Prebuild
- Billable Status
- Estimated Time
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Quantity
- Income Account
- Service Fee
- Billable Status
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Income Account
Action
Write
- NameRequired
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Billing Contact
- Contact
- Title
- Given Name
- Family Name
- Email
- Work Phone
- Cell Phone
- Fax
- Position
- Preferred Notification Method
- Public Notes
- Private Notes
- Zone
- Preferred Technicians
- Customers
- STC Zone
- VEEC Zone
Action
Write
- ID
- Order No
- Name
Action
Search
- ID
- Name
- Address
- City
- State
- Postal Code
- Country
Action
Search
- ID
- Phone
- Cell Phone
- Alt Phone
- Email
Action
Search
- ID
- Email
- Work Phone
- Cell Phone
- Alt Phone
- Title
- Given NameRequired
- Family Name
- Fax
- Department
- Position
- Notes
Action
Search or write
- ID
- Company NameRequired
- Phone
- Alt Phone
- Email
- EIN
- Website
- Fax
- Company Number
- Preferred Techs
- Do Not Call
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
Action
Search or write
- 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
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

Company Customer Updated
Triggers when a company customer is updated.
Trigger
Instant
Try It
Individual Customer Updated
Triggers when an individual customer is updated.
Trigger
Instant
Try It
Job Updated
Triggers when a job is updated.
Trigger
Instant
Try It
Quote Updated
Triggers when a quote is updated.
Trigger
Instant
Try It
Schedule Updated
Triggers when a job, lead, quote or activity schedule is updated.
Trigger
Instant
Try It
Site Updated
Triggers when a site is updated.
Trigger
Instant
Try It
- Title
- Given NameRequired
- Family Name
- Email
- Work Phone
- Fax
- Cell Phone
- Department
- Position
- Notes
- Alt Phone
Action
Write
- CustomerRequired
- SiteRequired
- Cost Center
- Customer Contact
- Additional Contacts
- Site Contact
- Order No
- Name
- Description
- Notes
- Date Issued
- Due Date
- Due Time
- Tags
- Salesperson
- Project Manager
- Technician
- Stage
- Status
- Response Time
- Auto Adjust Status
Action
Write
- StaffRequired
- Date
- Start TimeRequired
- End TimeRequired
- Schedule RateRequired
- Notes
- Locked
- Type
Action
Write
- ID
- Email
- WorkPhone
- CellPhone
- AltPhone
Action
Search
- ID
- Staff
- Date
- Type
Action
Search
- ID
- Company Name
- Phone
- Alt Phone
- Email
- EIN
- Website
- Fax
- Company Number
Action
Search
- ID
- Order No
- Name
Action
Search
- ID
- NameRequired
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Billing Contact
- Contact
- Title
- Given Name
- Family Name
- Email
- Work Phone
- Cell Phone
- Fax
- Position
- Preferred Notification Method
- Public Notes
- Private Notes
- Zone
- Preferred Technicians
- Customers
- STC Zone
- VEEC Zone
Action
Search or write
- ID
- Phone
- Cell Phone
- Alt Phone
- Email
- Title
- Given NameRequired
- Family NameRequired
- Preferred Techs
- Do Not Call
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
Action
Search or write
- 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
- Base 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

Related categories

Databases

Similar apps

About Simpro

Simpro is a field service and job management software package. Optimize workflow processes & field service operations for trade businesses.

Learn more

Related categories

Project Management

Airtable + Simpro

Create or update Airtable records for new individual customers from Simpro

New Company Customer

New Individual Customer

New Job

New Quote

New Schedule

New Site

Create Company Customer

Create Individual Customer

Create Service Quote

Create Site

Find Quote

Find Site

Find Individual Customer

Find or Create Contact

Find or Create Company Customer

New Record

Add Comment to Record

Create Records (Advanced)

Create or Update Record

Delete Record

Update Multiple Records

Find Record

Find Table

Find Base

Get All Records

Find or Create Record

Company Customer Updated

Individual Customer Updated

Job Updated

Quote Updated

Schedule Updated

Site Updated

Create Contact

Create Service Job

Create Schedule Block(s)

Find Contact

Find Schedule

Find Company Customer

Find Job

Find or Create Site

Find or Create Individual Customer

New or Updated Record

Create Record

Create Base

Create Table

Update Record

API Request (Beta)

Find Record by ID

Find Table by ID

Find Base by ID

Get Base Schema

About Airtable

Related categories

Similar apps

Quickbase

Zoho Creator

Smartsheet

About Simpro

Related categories

Related Zap Templates

Related Zap Templates