Business Pilot + Zapier Tables

Create records in Zapier Tables for new leads in Business Pilot

Capture every business opportunity with this seamless workflow. When a new lead is added in Business Pilot, a corresponding record is instantly generated in Zapier Tables. This ensures you effortlessly keep track of your leads and manage your growing business with ease and efficiency. No more manual entries or lost prospects. All your lead data, perfectly organized in your preferred system.

When this happens...
New Lead
Triggers when there's a new lead.
TriggerInstant
automatically do this!
Create Record
Creates a new record on a table.
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 Contact
Triggers when there's a new contact.
Trigger
Instant
Try It
New Enquiry
Triggers when a new Enquiry is created.
Trigger
Instant
Try It
New Lead
Triggers when there's a new lead.
Trigger
Instant
Try It
New Purchase Order Invoice
Triggers when a new Purchase Order Invoice.
Trigger
Instant
Try It
New Service Call
Triggers when there's a new service call.
Trigger
Instant
Try It

Updated Contact
Triggers when there's an updated contact.
Trigger
Instant
Try It
Updated Enquiry
Triggers when an Enquiry is updated.
Trigger
Instant
Try It

Updated Lead
Triggers when there's an updated lead.
Trigger
Instant
Try It
Updated Purchase Order Invoice
Triggers when a purchase order invoice is updated.
Trigger
Instant
Try It
Updated Service Call
Triggers when a service call is updated.
Trigger
Instant
Try It
- Contact IdRequired
- Note TextRequired
Action
Write
- Name
- First Name
- Last Name
- Email
- Phone
- Address Line 1
- Postal Code
- Form Source
- Lead Source
- Product Interest
- Project Type
- Preferred Appointment Date
- Preferred Appointment Time
- Marketing Preferences
- Message
- Label
- Branch
Action
Write
- Lead IdRequired
- Note TextRequired
Action
Write
- Purchase Order Id
- Purchase Order Number
- ItemRequired
- QuantityRequired
- Net ValueRequired
Action
Write
- Email AddressRequired
- Allowed Marketing TypesRequired
Action
Write
- Email AddressRequired
- Marketing PreferencesRequired
Action
Write
- Name
- Added Before
- Added After
- Updated Before
- Updated After
- Contact Type
- Show Only Trade
- Show Only Retail
Action
Search
- Contact Id
- Contact Number
- First Name
- Last Name
- Company Name
- Email
- Address Line 1
- Postal Code
- Phone
- Contact Type
Action
Search
- Name
Action
Search
- Contract Id
- Contract Number
- First Name
- Last Name
- Company Name
- Email
- Address Line 1
- Postal Code
- Phone
- Contract Type
Action
Search
- Invoice Id
- Invoice Number
- Invoice Type
- Contract Id
- Contract Number
- Contract Name
- Date Added Before
- Date Added After
- Date Updated Before
- Date Updated After
Action
Search
- Name
- Show For Web
Action
Search
- Name
- Active
Action
Search
- Name
- Active
Action
Search
- Purchase Order Id
- Purchase Order Number
- Contract Id
- Contract Name
- Supplier Id
- Supplier Name
- Date Added Before
- Date Added After
- Date Updated Before
- Date Updated After
Action
Search
- Purchase Order Invoice Query Id
- Purchase Order Invoice Id
- Purchase Order Id
- Purchase Order Number
- Supplier Id
- Supplier Name
- Date Added Before
- Date Added After
- Date Updated Before
- Date Updated After
Action
Search
- Name
- Active
Action
Search
- Supplier Name
- Added Before
- Added After
- Show Only Trade
- Show Only Retail
Action
Search
- Enquiry Id
- Enquiry Name
- Postal Code
- Email
- Phone Number
- Is Archived?
- Is Converted?
Action
Search
- Lead Id
- Lead Number
- First Name
- Last Name
- Company Name
- Email
- Address Line 1
- Postal Code
- Phone
- Lead Type
- Sales Person
Action
Search
- Purchase Order Invoice Id
- Purchase Order Id
- Purchase Order Number
- Invoice Reference
Action
Search
- Service Call Id
- Contract Id
- Contract Number
- Contract Name
- service Call Type
- service Call Status
Action
Search
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Trigger
Instant
Try It
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Trigger
Instant
Try It
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Trigger
Instant
Try It
- Table IDRequired
- Record IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table IDRequired
- Record IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table NameRequired
Action
Search
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Search or write

New Contract
Triggers when there's a new contract.
Trigger
Instant
Try It
New Invoice
Triggers when a new Invoice is created.
Trigger
Instant
Try It
New Purchase Order
Triggers when a new Purchase Order is created.
Trigger
Instant
Try It
New Purchase Order Invoice Query
Triggers when a new Purchase Order Invoice Query is created.
Trigger
Instant
Try It
New Supplier
Triggers when there's a new supplier.
Trigger
Instant
Try It
Updated Contract
Triggers when there's an updated contract.
Trigger
Instant
Try It
Updated Invoice
Triggers when an Invoice is updated.
Trigger
Instant
Try It
Updated Purchase Order
Triggers when a Purchase Order is updated.
Trigger
Instant
Try It
Updated Purchase Order Invoice Query
Triggers when a Purchase Order Invoice Query is updated.
Trigger
Instant
Try It
Updated Supplier
Triggers when there's an updated supplier.
Trigger
Instant
Try It
- Contract IdRequired
- Note TextRequired
Action
Write
- Lead Id
- Document Type Id
- Document Type Name
- File Name
- File
Action
Write
- Lead Id
- Quote Value Net
- Quote Reference
- File Name
- File
Action
Write
- IdRequired
- Allowed Marketing TypesRequired
Action
Write
- IdRequired
- Allowed Marketing TypesRequired
Action
Write
- PurchaseOrderId
- Optionally use Purchase Order Number instead of id
- Estimated Delivery Date
- Confirmed Delivery Date
- Supplier Reference
Action
Write
- Document Type Name
- Active?
Action
Search
- Name
Action
Search
- Name
- Status
- Pipeline
- Date Added Before
- Date Added After
- Show Only Trade
- Show Only Retail
- Contract Type
- Sales Person
- Current Owner
Action
Search
- Enquiry Id
- Enquiry Name
- Postal Code
- Email
- Phone Number
- Is Archived?
- Is Converted?
- Date Added Before
- Date Added After
- Date Updated Before
- Date Updated After
Action
Search
- Name
- Status
- Pipeline
- Date Added Before
- Date Added After
- Show Only Trade
- Show Only Retail
- Lead Type
- Sales Person
Action
Search
- Name
Action
Search
- Name
- ShowForWeb
Action
Search
- Name
Action
Search
- Purchase Order Invoice Id
- Purchase Order Id
- Purchase Order Number
- Supplier Id
- Supplier Name
- Date Added Before
- Date Added After
- Date Updated Before
- Date Updated After
Action
Search
- Role Name
Action
Search
- Contract Name
- Contract Number
- Status
- Service Call Type
- Date Added Before
- Date Added After
Action
Search
- Name
- Active
- Email
- Roles
Action
Search
- Invoice Id
- Invoice Number
- Invoice Type
- Contract Id
- Contract Number
- Contract Name
Action
Search
- Purchase Order Id
- Purchase Order Number
Action
Search
- Purchase Order Invoice Query Id
- Purchase Order Invoice Id
- Purchase Order Id
- Purchase Order Number
- Query Reference
Action
Search
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Trigger
Instant
Try It
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Trigger
Instant
Try It
- Table IDRequired
- FieldRequired
- Summary FormulaRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Trigger
Instant
Try It
- Table IDRequired
- Calculate FieldRequired
- Aggregate FunctionRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table IDRequired
- Name
- Description
Action
Write
- Table IDRequired
- Record IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Write
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Search
- Table IDRequired
- Zap Id
- Zap Step Id
- Zap Path Run Id
Action
Search

About Business Pilot

Business Pilot is a cloud-based fitting or installation company ERP / CRM system providing tools to manage your business with focus on driving profits.

Related categories

CRM (Customer Relationship Management)

About Zapier Tables

Zapier Tables is a no-code database built for automation.

Learn more

Related categories

Related Zap Templates

Create records in Zapier Tables for new contacts in Business Pilot

Related Zap Templates

Create records in Zapier Tables for new contacts in Business Pilot

Business Pilot + Zapier Tables

Create records in Zapier Tables for new leads in Business Pilot

New Contact

New Enquiry

New Lead

New Purchase Order Invoice

New Service Call

Updated Contact

Updated Enquiry

Updated Lead

Updated Purchase Order Invoice

Updated Service Call

Create Contact Note

Create Enquiry

Create Lead Note

Create Purchase Order Line

Update Contact Marketing Preferences by Email Address

Update Enquiry Marketing Preferences by Email Address

Find All Contacts

Find a Contact

Find All Contact Types

Find a Contract

Find All Invoices

Find All Lead Sources

Find All Lead Types

Find All Product Types

Find All Purchase Orders

Find All Purchase Order Invoice Queries

Find All Sales Areas

Find Suppliers

Find an Enquiry

Find a Lead

Find a Purchase Order Invoice

Find a Service Call

New or Updated or Deleted Record

New Record

Updated Record

Continue Zap Button Clicked

Delete Record

Increment or Decrement Value

Change Button State

Find Table

Find or Create record

New Contract

New Invoice

New Purchase Order

New Purchase Order Invoice Query

New Supplier

Updated Contract

Updated Invoice

Updated Purchase Order

Updated Purchase Order Invoice Query

Updated Supplier

Create Contract Note

Create Lead Document

Create Lead Quote

Update Contact Marketing Preferences

Update Enquiry Marketing Preferences

Update Purchase Order

Find All Document Types

Find a Contact Type

Find All Contracts

Find All Enquiries

Find All Leads

Find a Lead Type

Find All Product Interests

Find All Project Types

Find All Purchase Order Invoices

Find Roles

Find All Service Calls

Find Users

Find an Invoice

Find a Purchase Order

Find a Purchase Order Invoice Query

Trigger Zap Button Clicked

New or Updated Record

Summary Formula Updated

Calculate Summary Formula

Create Record

Duplicate Table