Google Sheets + Knowify
Update Google Sheets rows when new jobs are made active in Knowify
Stay organized and enhance your productivity with this workflow. When a contract job is made active in Knowify, the respective row in your Google Sheets will be updated. This automation ensures all your records stay up-to-date with real-time changes in Knowify. Say goodbye to manual data input and hello to seamless record-keeping.
Stay organized and enhance your productivity with this workflow. When a contract job is made active in Knowify, the respective row in your Google Sheets will be updated. This automation ensures all your records stay up-to-date with real-time changes in Knowify. Say goodbye to manual data input and hello to seamless record-keeping.
- When this happens...
Contract Job Made ActiveTriggers when a contract job has been made active.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Update Spreadsheet RowUpdate a row in a specific spreadsheet with optional formatting.
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 AIA Invoice
Triggers when a new AIA invoice has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Bill
Triggers when a new bill has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planBill Sent for Approval
Triggers when a bill is sent for approval.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Client
Triggers when a new client has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContract Out for Signature
Triggers when a contract job has been sent out for signature.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Invoice Payment
Triggers when a new invoice payment is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPhase Scheduled
Triggers when a phase has been scheduled
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Product
Triggers when a new trigger has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planJob Closed
Triggers when a contract job has been closed
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Purchase
Triggers when a new purchase has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Task
Triggers when a new task has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Service Job
Triggers when a new service job has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Vendor
Triggers when a new vendor has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planClient NameRequired
Client Contact Name
Email Address
Phone Number
Client Parent Id
Street Address
Street Address (Continued)
City Name
State/Province
Zip Code
Country Name
Shipping Same as Billing
Shipping Street Address
Shipping Street Address (Cont'd)
Shipping City Name
Shipping Contact Name
Shipping Country Name
Shipping State/Province Name
Shipping Zip Code
Website
Sync to QB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job NameRequired
Job Costing Style
Contract TypeRequired
Client NameRequired
Sales Lead
Project Manager
Job notes
Address1
Address2
City
State/Province
Zip
Country (2 characters)
Sync to QB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DescriptionRequired
Comment
Task Complete?
Deadline
Date Completed
Resource
Job
Phase
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Vendor NameRequired
Street Address
Street Address (Continued)
City Name
Client Contact Name
Country Name
Email Address
Phone Number
State/Province
Is this vendor a subcontractor?
Other Details
Zip Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Item NameRequired
Description
Our CostRequired
Sale PriceRequired
Item Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPhase NameRequired
Project Name
ActionThis is an event a Zap performs.SearchFind existing data in your appJob NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDescriptionRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appVendor IdRequired
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 Allocation
Triggers when a new allocation has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Bill Payment
Triggers when a new bill payment is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planChange Order Made Active
Triggers when a change order has been made active.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContract Job Made Active
Triggers when a contract job has been made active.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Invoice
Triggers when a new invoice has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Payment
Triggers when a new payment is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPhase Status Changed
Triggers when a phase status is changed
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Contract Job
Triggers when a new contract job has been added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planJob Reopened
Triggers when a contract job has been reopened
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubmittal Approved
Triggers when a submittal has been approved.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTask Marked Complete
Triggers when a task has been marked complete
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planService Job Marked Complete
Triggers when a service job has been marked complete.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planJob NameRequired
Client NameRequired
AddressRequired
CityRequired
State/ProvinceRequired
ZipcodeRequired
Country (2-letter abbreviation)Required
Contract Value
Line Item Name
Phase Name
Invoiced to Date
Labor Cost to Date
Material Cost to Date
Sub Cost to Date
Payments to Date
Labor Budget
Material Budget
Sub Budget
Sales Lead
Project Manager
Job notes
Sync to QB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Item NameRequired
Description
Our CostRequired
Sale PriceRequired
Item Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileNameRequired
UrlRequired
Project IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job NameRequired
Client NameRequired
Service Notes
AddressRequired
Address 2Required
CityRequired
State/Province (2-letter abbreviation)Required
ZipcodeRequired
Country (2-letter abbreviation)Required
Is Time & Materials?Required
Resource
Date (MM-DD-YYYY)
Start Time
End Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
NameRequired
Business StateRequired
Start Date
Finish Date
Work Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
DescriptionRequired
Comment
Task Complete?
Deadline
Date Completed
Resource
Job
Phase
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDescriptionRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUser IdRequired
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 Google Sheets
Related categories
Related categories
Related Zap Templates
- Create Knowify products for new Google Sheets spreadsheet rows
- Create multiple spreadsheet rows in Google Sheets for new clients in Knowify
- Create spreadsheet rows in Google Sheets for new contract jobs in Knowify
- Create rows in Google Sheets for new Knowify contracts awaiting signature
- Create new Knowify products from new or updated Google Sheets rows