Microsoft Excel + Knowify

Add rows in Microsoft Excel when jobs close in Knowify

Effortlessly keep track of completed jobs with this workflow that links the Knowify app and Microsoft Excel. Each time a job closes in Knowify, a corresponding row is created in a selected Excel spreadsheet, ensuring all essential data is captured. This seamless connection ensures real-time, accurate job monitoring without the need for manual data curation.

When this happens...
Job Closed
Triggers when a contract job has been closed
TriggerPolling
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
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 AIA Invoice
Triggers when a new AIA invoice has been added.
Trigger
Polling
Try It
New Bill
Triggers when a new bill has been added.
Trigger
Polling
Try It
Bill Sent for Approval
Triggers when a bill is sent for approval.
Trigger
Polling
Try It
New Client
Triggers when a new client has been added.
Trigger
Polling
Try It
Contract Out for Signature
Triggers when a contract job has been sent out for signature.
Trigger
Polling
Try It

New Invoice Payment
Triggers when a new invoice payment is added.
Trigger
Polling
Try It
New Payment
Triggers when a new payment is added.
Trigger
Polling
Try It

Phase Status Changed
Triggers when a phase status is changed
Trigger
Polling
Try It
New Contract Job
Triggers when a new contract job has been added.
Trigger
Polling
Try It
Job Reopened
Triggers when a contract job has been reopened
Trigger
Polling
Try It
Submittal Approved
Triggers when a submittal has been approved.
Trigger
Polling
Try It
Task Marked Complete
Triggers when a task has been marked complete
Trigger
Polling
Try It
Service Job Marked Complete
Triggers when a service job has been marked complete.
Trigger
Polling
Try It
New Vendor
Triggers when a new vendor has been added.
Trigger
Polling
Try It
- Client 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
Action
Write
- 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
Action
Write
- Service Asset NameRequired
- Client NameRequired
- Service Asset Notes
- Manufacturer
- Model
- Serial Number
- Location on Site
- AddressRequired
- Address 2
- CityRequired
- State/Province (2-letter abbreviation)Required
- ZipcodeRequired
- Country (2-letter abbreviation)Required
- Installation Date (MM-DD-YYYY)
- Last Serviced Date (MM-DD-YYYY)
Action
Write
- Job NameRequired
- Client NameRequired
- Service Notes
- AddressRequired
- Address 2
- CityRequired
- State/Province (2-letter abbreviation)Required
- ZipcodeRequired
- Country (2-letter abbreviation)Required
- Is Time & Materials?Required
- Resource
- Date (MM-DD-YYYY)
- Time Zone
- Start Time
- End Time
Action
Write
- IdRequired
- NameRequired
- Business StateRequired
- Start Date
- Finish Date
- Work Order
Action
Write
- TaskRequired
- DescriptionRequired
- Comment
- Task Complete?
- Deadline
- Date Completed
- Resource(s)
- Job
- Phase
Action
Write
- Client IdRequired
Action
Search
- NameRequired
Action
Search
- Project IdRequired
Action
Search
- DescriptionRequired
Action
Search
- User IdRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write

New Allocation
Triggers when a new allocation has been added.
Trigger
Polling
Try It
New Bill Payment
Triggers when a new bill payment is added.
Trigger
Polling
Try It
Change Order Made Active
Triggers when a change order has been made active.
Trigger
Polling
Try It
Contract Job Made Active
Triggers when a contract job has been made active.
Trigger
Polling
Try It
New Invoice
Triggers when a new invoice has been added.
Trigger
Polling
Try It
Item Marked Received
Triggers when an item is marked received, returning the request with the specified item marked as received
Trigger
Polling
Try It
Phase Scheduled
Triggers when a phase has been scheduled
Trigger
Polling
Try It
New Product
Triggers when a new trigger has been added.
Trigger
Polling
Try It
Job Closed
Triggers when a contract job has been closed
Trigger
Polling
Try It
New Purchase
Triggers when a new purchase has been added.
Trigger
Polling
Try It
New Task
Triggers when a new task has been added.
Trigger
Polling
Try It
New Service Job
Triggers when a new service job has been added.
Trigger
Polling
Try It
Time Entry Approved
Triggers when a time entry has been approved
Trigger
Polling
Try It
- Job 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
Action
Write
- ProductRequired
- Item NameRequired
- Description
- Our CostRequired
- Sale PriceRequired
- Item Number
Action
Write
- FileNameRequired
- UrlRequired
- Project IdRequired
Action
Write
- DescriptionRequired
- Comment
- Task Complete?
- Deadline
- Date Completed
- Resource(s)
- Job
- Phase
Action
Write
- 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
Action
Write
- ProductRequired
- Item NameRequired
- Description
- Our CostRequired
- Sale PriceRequired
- Item Number
Action
Write
- Client NameRequired
Action
Search
- Phase NameRequired
- Project Name
Action
Search
- Job NameRequired
Action
Search
- DescriptionRequired
Action
Search
- NameRequired
Action
Search
- Vendor IdRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more

Related categories

Similar apps

About Knowify

Knowify is a job costing and project management platform for contractors.

Learn more

Related categories

Project Management

Related Zap Templates

Activate contract jobs in Knowify and add rows to Microsoft Excel table

Add rows to Microsoft Excel when service jobs are marked complete in Knowify

Microsoft Excel + Knowify

Add rows in Microsoft Excel when jobs close in Knowify

New AIA Invoice

New Bill

Bill Sent for Approval

New Client

Contract Out for Signature

New Invoice Payment

New Payment

Phase Status Changed

New Contract Job

Job Reopened

Submittal Approved

Task Marked Complete

Service Job Marked Complete

New Vendor

Create Client

Create Contract Job

Create Service Asset

Create Service Job

Update Phase

Update Task

Get Client by Id

Find Product

Get Job by Id

Find Task

Get User by Id

New Row

New Worksheet

Add Row

Add Row to Table

Clear Column by Index

Create Workbook

Delete Worksheet

Update Row

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

New Allocation

New Bill Payment

Change Order Made Active

Contract Job Made Active

New Invoice

Item Marked Received

Phase Scheduled

New Product

Job Closed

New Purchase

New Task

New Service Job

Time Entry Approved

Create Active Contract Job

Create Product

Add Remote Document

Create Task

Create Vendor

Update Product

Find Client

Find Phase

Find Job

Find Resource

Find User

Get Vendor by Id

New Row in Table

Updated Row

Add Row(s)

Clear Cells by Range

Clear Row by ID

Create Worksheet

Rename Worksheet

API Request (Beta)

Find Worksheet(s)

Get Row by ID

Find or Create Row

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet