Create a Google Sheets row for each new Business Pilot contact
Automate your workflow and save time with this efficient integration! Each time a new contact is added in the Business Pilot app, a row is immediately added to your selected Google Sheets spreadsheet. This simplifies contact management and ensures your records stay up to date effortlessly.
- When this happens...

New ContactTriggers when there's a new contact.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Business Pilot and Google Sheets
Discover other triggers and actions you can use with Business Pilot and Google Sheets
New ContactTriggers when there's a new contact.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New EnquiryTriggers when a new Enquiry is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New LeadTriggers when there's a new lead.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Purchase Order InvoiceTriggers when a new Purchase Order Invoice.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Service CallTriggers when there's a new service call.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated ContactTriggers when there's an updated contact.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated EnquiryTriggers when an Enquiry is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated LeadTriggers when there's an updated lead.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated Purchase Order InvoiceTriggers when a purchase order invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated Service CallTriggers when a service call is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Contact IdRequired
- Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Lead IdRequired
- Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Id
- Purchase Order Number
- ItemRequired
- QuantityRequired
- Net ValueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email AddressRequired
- Allowed Marketing TypesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email AddressRequired
- Marketing PreferencesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Name
- Added Before
- Added After
- Updated Before
- Updated After
- Contact Type
- Show Only Trade
- Show Only Retail
ActionThis is an event a Zap performs.SearchFind existing data in your app- Contact Id
- Contact Number
- First Name
- Last Name
- Company Name
- Email
- Address Line 1
- Postal Code
- Phone
- Contact Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Contract Id
- Contract Number
- First Name
- Last Name
- Company Name
- Email
- Address Line 1
- Postal Code
- Phone
- Contract Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Invoice Id
- Invoice Number
- Invoice Type
- Contract Id
- Contract Number
- Contract Name
- Date Added Before
- Date Added After
- Date Updated Before
- Date Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Show For Web
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Active
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Active
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Active
ActionThis is an event a Zap performs.SearchFind existing data in your app- Supplier Name
- Added Before
- Added After
- Show Only Trade
- Show Only Retail
ActionThis is an event a Zap performs.SearchFind existing data in your app- Enquiry Id
- Enquiry Name
- Postal Code
- Email
- Phone Number
- Is Archived?
- Is Converted?
ActionThis is an event a Zap performs.SearchFind existing data in your app- Lead Id
- Lead Number
- First Name
- Last Name
- Company Name
- Email
- Address Line 1
- Postal Code
- Phone
- Lead Type
- Sales Person
ActionThis is an event a Zap performs.SearchFind existing data in your app- Purchase Order Invoice Id
- Purchase Order Id
- Purchase Order Number
- Invoice Reference
ActionThis is an event a Zap performs.SearchFind existing data in your app- Service Call Id
- Contract Id
- Contract Number
- Contract Name
- service Call Type
- service Call Status
ActionThis is an event a Zap performs.SearchFind existing data in your app- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New ContractTriggers when there's a new contract.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New InvoiceTriggers when a new Invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Purchase OrderTriggers when a new Purchase Order is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Purchase Order Invoice QueryTriggers when a new Purchase Order Invoice Query is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New SupplierTriggers when there's a new supplier.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated ContractTriggers when there's an updated contract.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated InvoiceTriggers when an Invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated Purchase OrderTriggers when a Purchase Order is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated Purchase Order Invoice QueryTriggers when a Purchase Order Invoice Query is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated SupplierTriggers when there's an updated supplier.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Contract IdRequired
- Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Lead Id
- Document Type Id
- Document Type Name
- File Name
- File
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Lead Id
- Quote Value Net
- Quote Reference
- File Name
- File
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Allowed Marketing TypesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Allowed Marketing TypesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- PurchaseOrderId
- Optionally use Purchase Order Number instead of id
- Estimated Delivery Date
- Confirmed Delivery Date
- Supplier Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Document Type Name
- Active?
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Status
- Pipeline
- Date Added Before
- Date Added After
- Show Only Trade
- Show Only Retail
- Contract Type
- Sales Person
- Current Owner
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Status
- Pipeline
- Date Added Before
- Date Added After
- Show Only Trade
- Show Only Retail
- Lead Type
- Sales Person
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- ShowForWeb
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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
ActionThis is an event a Zap performs.SearchFind existing data in your app- Role Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Contract Name
- Contract Number
- Status
- Service Call Type
- Date Added Before
- Date Added After
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Active
- Email
- Roles
ActionThis is an event a Zap performs.SearchFind existing data in your app- Invoice Id
- Invoice Number
- Invoice Type
- Contract Id
- Contract Number
- Contract Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Purchase Order Id
- Purchase Order Number
ActionThis is an event a Zap performs.SearchFind existing data in your app- Purchase Order Invoice Query Id
- Purchase Order Invoice Id
- Purchase Order Id
- Purchase Order Number
- Query Reference
ActionThis is an event a Zap performs.SearchFind existing data in your app- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found




