Microsoft Excel + ServiceTitan

Microsoft Excel + ServiceTitan integrations

Update ServiceTitan invoice items whenever new rows are added in Microsoft Excel

When a new row materializes in your Microsoft Excel table, this workflow gets to work, updating invoice items in your ServiceTitan app. This enhances your invoicing process, allowing you to stay organized and ensuring that each invoice accurately represents all the necessary elements. This automation, thus, saves your valuable time and reduces the possibility of human error.

When this happens...
New Row in TableTriggers when a new row is added to a table in a spreadsheet.
TriggerPolling
automatically do this!
Update Invoice ItemsUpdates the items in an invoice by id
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Microsoft Excel and ServiceTitan

Discover other triggers and actions you can use with Microsoft Excel and ServiceTitan

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write
- Appointments IDs (maximum 50)
- Job Id
- Project Id
- Appointment Number
- Appointment Status
- Technician Id
- Customer Id
- Appointments starts on or after
- Appointments starts before
- Appointments modified before
- Appointments modified on or after
- Appointments created on or after
- Appointments created before
Trigger
Polling
Try It
- Active
- Modified On Or After
- Modified Before
Trigger
Polling
Try It
- Customers IDs (maximum 50)
- Created before
- Created on or after
- Modified before
- Modified on or after
- Name
- Street
- Unit
- City
- State
- Zip
- Country
- Phone
- Active
- External data application Guid
- External data key
- External data values
- Tag Types
- Tag Type Match Condition
Trigger
Polling
Try It
- Estimates IDs (maximum 50)
- Job
- Project
- Job Number
- Sold By
- Sold By Employee
- Active
- Status
- Total greater
- Total less
- Sold after
- Sold before
- Created before
- Created on or after
- Modified before
- Modified on or after
Trigger
Polling
Try It
- Invoices IDs (maximum 50)
- Invoice Status
- Batch
- Batch number
- Job
- Business Unit
- Customer
- Total greater
- Total less
- Invoiced On Before
- Invoiced On Or After
- Invoice Review Status
- Invoice Assigned to Ids
- Modified On Or After
- Modified Before
Trigger
Polling
Try It
- Jobs IDs (maximum 50)
- Job number
- Project Id
- Job Status
- Appointment Status
- Job Type
- Business Unit
- Customer Id
- Location Id
- Technician Id
- Appointment Starts Before
- Appointment Starts On Or After
- Created Before
- Created On Or After
- Modified Before
- Modified On Or After
- Completed Before
- Completed On Or After
- Tag Types
Trigger
Polling
Try It
- Leads IDs (maximum 50)
- Modified Before
- Modified On Or After
- Customer Id
- Is Prospect
- Without Customer
- Status
- Customer City
- Customer State
- Customer Zip
- Customer Created On Or After
- Customer Created Before
- Customer Modified On Or After
- Sort
Trigger
Polling
Try It
- Equipment IDs
- Modified On Or After
- Modified On Or Before
- Active
Trigger
Polling
Try It
- Applied to invoices
- Applied to reference number
- Status
- Business unit ids
- Transaction type
- Customer Id
- Total greater
- Total less
- Modified before
- Modified on or after
- Created before
- Created on or after
Trigger
Polling
Try It
- Technician Ids (maximum 50)
- Technician name
- Technician active
- Created before
- Created on or after
- Modified before
- Modified on or after
Trigger
Polling
Try It
- Equipment IDs
- Modified On Or After
- Modified On Or Before
- Active
Trigger
Polling
Try It
- Customers
- Tag Types
Action
Write
- Project Id to attach job
  Required
- ID of job to attach to project
  Required
Action
Write
- ID of job for new appointment
  Required
- Start date/time
  Required
- End date/time
  Required
- Arrival window start date/time
- Arrival window end date/time
- Technicians Ids
- Special instructions
Action
Write
- Booking Provider
  Required
- Source
  Required
- Name
  Required
- Street
- Unit
- City
- State
- Zip
- Country
- Type
- Value
- Memo
- Type
- Value
- Memo
- Customer Type
- Start
- Summary
  Required
- Campaign
- Business Unit
- Job Type
- Priority
- Is First Time Client
  Required
- Send Confirmation Email
- External Id
  Required
Action
Write
- Customer
  Required
- Type
  Required
- Value
  Required
- Memo
Action
Write
- Employee Name
  Required
- Mobile Phone
- Office phone
- Email
  Required
- Login (Username)
- Account creation method
  Required
- Business Unit Id
- User role Id
  Required
- List of company positions
  Required
- Azure Active Directory User Id
Action
Write
- Location Id
  Required
- Name
- Installed On
- Serial Number
- Memo
- Manufacturer
- Model
- Cost
- Manufacturer Warranty Start
- Manufacturer Warranty End
- Service Provider Warranty Start
- Service Provider Warranty End
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Alias
- File Name
- Type
- Alias
- File Name
- Type
- Alias
- File Name
- Type
- Tag Types
Action
Write
- Customer Id
  Required
- Location Id
  Required
- Business Unit
  Required
- Project
- Estimate
- Job Type
  Required
- Priority
  Required
- Campaign
  Required
- Start
  Required
- End
  Required
- Arrival Window Start
- Arrival Window End
- Technician Ids
- Summary
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Tag Types
Action
Write
- Note
  Required
- Pin To Top
- Job or Project Notes
  Required
Action
Write
- Booking
  Required
- Landing Page Url
  Required
- Referrer Url
  Required
- Google Click Identifier
- Facebook Click Identifier
- Microsoft Click ID
- UTM source
- UTM medium
- UTM campaign
- UTM ad group
- UTM term
- UTM content
- Google Analytics id
Action
Write
- Lead
  Required
- Landing Page Url
  Required
- Referrer Url
  Required
- Google Click Identifier
- Facebook Click Identifier
- Microsoft Click ID
- UTM source
- UTM medium
- UTM campaign
- UTM ad group
- UTM term
- UTM content
- Google Analytics id
Action
Write
- Name
  Required
- Email
- Phone Number
- Street
- Unit
- City
- State
- Zip
- Country
- Summary
Action
Write
- Name
  Required
- Customer
  Required
- Street
- Unit
- City
- State
- Zip
- Country
- Latitude
- Longitude
- Type
- Value
- Memo
- Type
- Value
- Memo
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Tag Types
Action
Write
- Technician
  Required
- Start
  Required
- Duration
  Required
- Name
  Required
- Timesheet Code
  Required
- Summary
- Clear Dispatch Board
- Clear Technician View
- Remove Technician From Capacity Planning
- Days of Week
- Repeat
- Repeat Frequency
- Repeat Interval
- End Type
Action
Write
- Location
  Required
- Estimate
- Job
- Name
- Summary
- Status Id
- Sub Status Id
- Start Date
- Target Completion Date
- Actual Completion Date
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
Action
Write
- Task id
  Required
- Is Closed
  Required
- Name
  Required
- Assigned To
  Required
- Due Date Time
Action
Write
- Technician Name
  Required
- Technician's phone number
- Email
- Login (Username)
- Account creation method
  Required
- Business Unit Id
- User role Id
  Required
- List of company positions
  Required
- Azure Active Directory User Id
- License type
  Required
- Team name
- Daily revenue goal
- Burden rate (hourly)
- Biography
- Memo
- Upcoming appointment visibility
- Appointment history visibility
- Street
- Unit
- City
- State
- Zip
- Country
- Latitude
- Longitude
Action
Write
- Lead
  Required
- Dismiss Call Reason
  Required
Action
Write
- Appointment to remove hold.
  Required
Action
Write
- Id of the appointment to assign to.
  Required
- Technicians Ids
  Required
Action
Write
- Employee Id
  Required
- Employee Name
- Mobile Phone
- Office phone
- Email
- Login (Username)
- Business Unit Id
- User role Id
- List of company positions
- Azure Active Directory User Id
Action
Write
- Estimate ID
  Required
- Sku
- Sku Name
- Parent Item Id
- Description
  Required
- Is Add On
- Quantity
- Unit Price
- Skip Updating Membership Prices
- Item Group Name
- Item Group Root
Action
Write
- ID
  Required
- Number
- Type
- Invoiced On
- Sub total
- Tax
- Summary
- Royalty Status
- Review Status
- Royalty Date
- Royalty Sent on
- Royalty Memo
- Export
- Assigned To
Action
Write
- Job Id
  Required
- Customer Id
- Location Id
- Business Unit
- Project
- Estimate
- Job Type
- Priority
- Campaign
- Summary
- Should Update Invoice Items
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Tag Types
Action
Write
- Location
- Customer
- Name
- Active
- Tax Zone Id
- Street
- Unit
- City
- State
- Zip
- Country
- Latitude
- Longitude
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Tag Types
Action
Write
- Purchase order Id
  Required
- Id of the vendor for this PO
  Required
- Id of the purchase order type for this PO
  Required
- Id of the business unit for this PO
  Required
- Id of the inventory location for this PO
- Id of the job for this PO
- Id of the technician for this PO
- Id of the project for this PO
- Street
- Unit
- City
- State
- Zip
- Country
- Vendor invoice number
- Vendor invoice number
  Required
- Summary/memo for this PO
- PO date
  Required
- PO required on date
  Required
- Tax
  Required
- Shipping cost
  Required
Action
Write
- Technician Id
  Required
- Action name
  Required
Action
Write
- Appointments Ids (maximum 50)
- ID of job for new appointment
- Created before
- Created on or after
- Modified before
- Modified on or after
Action
Search
- Booking provider Ids (maximum 50)
- Name of the booking provider tag
- Created before
- Created on or after
- Modified before
- Modified on or after
Action
Search
- Campaign Id
Action
Search
- Customer Id
Action
Search
- Discount and Fees Ids (maximum 50)
- Services created before
- Services created on or after
- Services modified before
- Services modified on or after
- Service active
- External data application guid
- External data key
- External data values
Action
Search
- Equipment Ids (maximum 50)
- Services created before
- Services created on or after
- Services modified before
- Services modified on or after
- Service active
- External data application guid
- External data key
- External data values
Action
Search
- Installed Equipments Ids
- Location Ids
Action
Search
- Type
  Required
Action
Search
- Lead
Action
Search
- Materials Ids (maximum 50)
- Services created before
- Services created on or after
- Services modified before
- Services modified on or after
- Service active
- External data application guid
- External data key
- External data values
Action
Search
- Purchase order Ids (maximum 50)
- Purchase order status
- Purchase order number
- Id of the job for this PO
- Id of the technician for this PO
- Id of the project for this PO
- Created on or after
- Created before
- Modified on or after
- Modified before
- Date on or after
- Date before
- Sent on or after
- Sent before
Action
Search
- Active
- Created before
- Created on or after
- Modified before
- Modified on or after
Action
Search
- Vendor Ids
- Active
- External data application Guid
- External data key
- External data values
- Created before
- Created on or after
- Modified before
- Modified on or after
Action
Search

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write
- Projects IDs (maximum 50)
- Customer
- Location
- Job Id
- Project Status
- Target Completion Date Before
- Target Completion Date On Or After
- Starts Before
- Starts On Or After
- Modified Before
- Modified On Or After
Trigger
Polling
Try It
- Booking Provider
  Required
Trigger
Polling
Try It
- Modified On Or After
- Modified Before
- Active
Trigger
Polling
Try It
- Employee Ids (maximum 50)
- Employee name
- Employee active
- Created before
- Created on or after
- Modified before
- Modified on or after
Trigger
Polling
Try It
- Form IDs (maximum 50)
- Active
- Status
- Submitted On Or After
- Submitted Before
- Owner Type
Trigger
Polling
Try It
- Job or Project Notes
Trigger
Polling
Try It
- Lead
  Required
- Include Total
Trigger
Polling
Try It
- Locations IDs (maximum 50)
- Customer
- City
- State
- Zip
- Active
- Modified Before
- Modified On Or After
- Tag Types
Trigger
Polling
Try It
- Non Job Ids
- Technician
- Starts On Or After
- Starts On Or Before
- Timesheet Code Id
- Active Only
- Show On Technician Schedule
- Created On Or After
- Created Before
Trigger
Polling
Try It
- Purchase order Ids (maximum 50)
- Purchase order status
- Purchase order number
- Id of the job for this PO
- Id of the technician for this PO
- Id of the project for this PO
- Created on or after
- Created before
- Modified on or after
- Modified before
- Date on or after
- Date before
- Sent on or after
- Sent before
Trigger
Polling
Try It
- Modified On Or After
- Modified Before
- Active
Trigger
Polling
Try It
- Estimates IDs (maximum 50)
- Job
- Project
- Job Number
- Sold By
- Sold By Employee
- Active
- Status
- Total greater
- Total less
- Sold after
- Sold before
- Created before
- Created on or after
- Modified before
- Modified on or after
Trigger
Polling
Try It
- Id of the appointment to assign to.
  Required
- Technicians Ids
  Required
Action
Write
- Appointment to cancel
  Required
Action
Write
- Booking Provider
  Required
- Booking
  Required
- Type
  Required
- Value
  Required
- Memo
Action
Write
- Name
  Required
- Type
- Do Not Mail
- Do Not Service
- Name
  Required
- Street
  Required
- Unit
- City
  Required
- State
  Required
- Zip
  Required
- Country
  Required
- Latitude
- Longitude
- Street
  Required
- Unit
- City
  Required
- State
  Required
- Zip
  Required
- Country
  Required
- Latitude
- Longitude
- Type
- Value
- Memo
- Type
- Value
- Memo
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Tag Types
Action
Write
- Customer Id
- Text content of customer note
  Required
- Pin to top
- Add to locations
Action
Write
- Name
  Required
- Summary
- Tax
- Status
- Sold by
- Name
- Url
- Job Id
- Project Id
- Location Id
Action
Write
- Adjustment to Invoice
  Required
- Number
- Type
- Invoiced On
- Sub total
- Tax
- Summary
- Royalty Status
- Royalty Date
- Royalty Sent on
- Royalty Memo
- Review Status
- Export
- Assigned To
Action
Write
- Job Id
  Required
- Filename
  Required
- File url
  Required
Action
Write
- Customer
- Location
- Campaign Id
  Required
- Business Unit Id
- Job Type
- Summary
  Required
- Tag Types
- Priority
- Call Reason Id
- Follow Up Date
Action
Write
- Landing Page Url
  Required
- Referrer Url
  Required
- Google Click Identifier
- Facebook Click Identifier
- Microsoft Click ID
- UTM source
- UTM medium
- UTM campaign
- UTM ad group
- UTM term
- UTM content
- Google Analytics id
- Customer Phone Number
  Required
- Forwarding Phone Number
  Required
- Tracking Phone Number
  Required
- Call Started On
  Required
Action
Write
- Lead
  Required
- Follow-Up Date
  Required
- Text
- Pin To Top
Action
Write
- Lead
  Required
- Note
  Required
- Pin To Top
Action
Write
- Location
  Required
- Type
  Required
- Value
  Required
- Memo
Action
Write
- Employee Type
  Required
- Employee Id
  Required
- Posted On
  Required
- Amount
- Memo
- Activity Code Id
- Invoice Id
- Hours
- Rate
Action
Write
- Id of the vendor for this PO
  Required
- Id of the purchase order type for this PO
  Required
- Id of the business unit for this PO
  Required
- Id of the inventory location for this PO
  Required
- Id of the job for this PO
- Id of the technician for this PO
- Id of the project for this PO
- Address Description
  Required
- Street
  Required
- Unit
  Required
- City
  Required
- State
  Required
- Zip
  Required
- Country
  Required
- Vendor invoice number
- Vendor invoice number
  Required
- Summary/memo for this PO
- PO date
  Required
- PO required on date
  Required
- Tax
  Required
- Shipping cost
  Required
- SKU ID
  Required
- Description
  Required
- Vendor Part Number
  Required
- Quantity
  Required
- Cost
  Required
Action
Write
- Reported To
  Required
- Assigned To
  Required
- Is Closed
  Required
- Name
  Required
- Business Unit
  Required
- Employee Task Type
  Required
- Employee Task Source
  Required
- Employee Task Resolution
  Required
- Reported date
  Required
- Due date
  Required
- Involved Employee Id List
- Customer Id
- Job Id
- Project Id
- Description
- Priority
  Required
Action
Write
- ID of job to detach from project
  Required
Action
Write
- Appointment to reschedule.
  Required
- Reason
  Required
- Memo
  Required
Action
Write
- Appointment to reschedule.
  Required
- Start date/time
  Required
- End date/time
  Required
- Arrival window start date/time
- Arrival window end date/time
Action
Write
- Customer Id
- Name
- Type
- Do Not Mail
- Do Not Service
- Street
- Unit
- City
- State
- Zip
- Country
- Latitude
- Longitude
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Active
- Tag Types
Action
Write
- Employee Id
  Required
- Action name
  Required
Action
Write
- Installed Equipments Id
- Name
- Installed On
- Serial Number
- Memo
- Manufacturer
- Model
- Cost
- Manufacturer Warranty Start
- Manufacturer Warranty End
- Service Provider Warranty Start
- Service Provider Warranty End
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
- Alias
- File Name
- Type
- Alias
- File Name
- Type
- Alias
- File Name
- Type
- Tag Types
Action
Write
- ID
  Required
- Item type
Action
Write
- Lead
  Required
- Campaign
- Priority
- Business Unit Id
- Job Type
Action
Write
- Project Id
- Name
- Summary
- Status Id
- Sub Status Id
- Start Date
- Target Completion Date
- Actual Completion Date
- Custom field Id
- Value
- Custom field Id
- Value
- Custom field Id
- Value
Action
Write
- Technician Id
  Required
- Technician Name
- Technician's phone number
- Email
- Login (Username)
- Business Unit Id
- User role Id
- List of company positions
- Azure Active Directory User Id
- License type
- Team name
- Daily revenue goal
- Burden rate (hourly)
- Biography
- Memo
- Upcoming appointment visibility
- Appointment history visibility
- Street
- Unit
- City
- State
- Zip
- Country
- Latitude
- Longitude
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Appointments Ids (maximum 50)
- ID of job for new appointment
- Project Id
- Technician Id
- Customer Id
Action
Search
- Business Unit Id
Action
Search
- Category type
Action
Search
- Customers IDs (maximum 50)
- Created before
- Created on or after
- Modified before
- Modified on or after
- Name
- Street
- Unit
- City
- State
- Zip
- Country
- Phone
- Active
- External data application Guid
- External data key
- External data values
- Tag Types
Action
Search
- Employee Ids (maximum 50)
- Employee name
- Employee active
- Created before
- Created on or after
- Modified before
- Modified on or after
Action
Search
- Estimate Ids
- Job Id
- Project Id
- Sold By
- Sold By Employee
- Status
- Total greater
- Total less
- Sold after
- Sold before
Action
Search
- Invoices IDs (maximum 50)
- Invoice Number
- Status
- Job Id
- Job Number
- Batch Id
- Batch Number
- Customer Id
Action
Search
- Job Type Id
Action
Search
- Customer Id
- Tag Types
Action
Search
- Project Ids
- Customer Id
- Location Id
- Invoice Id
- Technician
- Job Id
- Appointment Id
Action
Search
- Service Ids (maximum 50)
- Services created before
- Services created on or after
- Services modified before
- Services modified on or after
- Service active
- External data application guid
- External data key
- External data values
Action
Search
- Technician Ids (maximum 50)
- Technician name
- Technician active
- Created before
- Created on or after
- Modified before
- Modified on or after
Action
Search
- Location Id
Action
Search

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 moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About ServiceTitan

ServiceTitan is a mobile, cloud-based software platform that helps home services companies streamline operations, improve customer service, and increase sales.

Learn moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Microsoft Excel + ServiceTitan

Microsoft Excel + ServiceTitan

Update ServiceTitan invoice items whenever new rows are added in Microsoft Excel

More things you can do with Microsoft Excel and ServiceTitan

Related Zap Templates

Related Zap Templates