Business Pilot + Google Sheets
Create a new Google Sheets row for each updated invoice in Business Pilot
Manage your accounts more efficiently with this seamless workflow. When an invoice is updated in Business Pilot, a new row is created in a specified Google Sheets spreadsheet. This smooth process allows for an effortless tracking and organizing of all your financial details in one place. Improve your accounting routines and keep your financial data updated effortlessly.
Manage your accounts more efficiently with this seamless workflow. When an invoice is updated in Business Pilot, a new row is created in a specified Google Sheets spreadsheet. This smooth process allows for an effortless tracking and organizing of all your financial details in one place. Improve your accounting routines and keep your financial data updated effortlessly.
- When this happens...
Updated InvoiceTriggers when an Invoice is updated.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Contact
Triggers when there's a new contact.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Enquiry
Triggers when a new Enquiry is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when there's a new lead.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Purchase Order Invoice
Triggers when a new Purchase Order Invoice.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Service Call
Triggers when there's a new service call.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact
Triggers when there's an updated contact.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Enquiry
Triggers when an Enquiry is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Lead
Triggers when there's an updated lead.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Purchase Order Invoice
Triggers when a purchase order invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Service Call
Triggers 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 appContact 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 appName
ActionThis is an event a Zap performs.SearchFind existing data in your appContract 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 appInvoice 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 appName
Show For Web
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Active
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Active
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase 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 appPurchase 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 appName
Active
ActionThis is an event a Zap performs.SearchFind existing data in your appSupplier Name
Added Before
Added After
Show Only Trade
Show Only Retail
ActionThis is an event a Zap performs.SearchFind existing data in your appEnquiry Id
Enquiry Name
Postal Code
Email
Phone Number
Is Archived?
Is Converted?
ActionThis is an event a Zap performs.SearchFind existing data in your appLead 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 appPurchase Order Invoice Id
Purchase Order Id
Purchase Order Number
Invoice Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appService 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 appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
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 appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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 appDrive
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 Contract
Triggers when there's a new contract.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when a new Invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Purchase Order
Triggers when a new Purchase Order is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Purchase Order Invoice Query
Triggers when a new Purchase Order Invoice Query is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Supplier
Triggers when there's a new supplier.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contract
Triggers when there's an updated contract.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Invoice
Triggers when an Invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Purchase Order
Triggers when a Purchase Order is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Purchase Order Invoice Query
Triggers when a Purchase Order Invoice Query is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Supplier
Triggers 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 appName
ActionThis is an event a Zap performs.SearchFind existing data in your appName
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 appEnquiry 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 appName
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 appName
ActionThis is an event a Zap performs.SearchFind existing data in your appName
ShowForWeb
ActionThis is an event a Zap performs.SearchFind existing data in your appName
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase 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 appRole Name
ActionThis is an event a Zap performs.SearchFind existing data in your appContract 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 appName
Active
Email
Roles
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice Id
Invoice Number
Invoice Type
Contract Id
Contract Number
Contract Name
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase Order Id
Purchase Order Number
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase 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 appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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.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 appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
About Business Pilot
Related categories
