How to connect Google Sheets + ServiceTitan + Slack
Zapier lets you send info between Google Sheets and ServiceTitan and Slack automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + ServiceTitan + Slack
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, ServiceTitan, and Slack. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundAppointments 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planActive
Modified On Or After
Modified Before
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEmployee Ids (maximum 50)
Employee name
Employee active
Created before
Created on or after
Modified before
Modified on or after
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planForm IDs (maximum 50)
Active
Status
Submitted On Or After
Submitted Before
Owner Type
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planLocations IDs (maximum 50)
Customer
City
State
Zip
Active
Modified Before
Modified On Or After
Tag Types
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planApplied 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTechnician Ids (maximum 50)
Technician name
Technician active
Created before
Created on or after
Modified before
Modified on or after
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomers
Tag Types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project Id to attach job
ID of job to attach to projectRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Booking ProviderRequired
BookingRequired
TypeRequired
ValueRequired
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Type
Do Not Mail
Do Not Service
NameRequired
StreetRequired
Unit
CityRequired
StateRequired
ZipRequired
CountryRequired
Latitude
Longitude
StreetRequired
Unit
CityRequired
StateRequired
ZipRequired
CountryRequired
Latitude
Longitude
Type
Value
Memo
Type
Value
Memo
Custom field Id
Value
Custom field Id
Value
Custom field Id
Value
Tag Types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Id
Text content of customer noteRequired
Pin to top
Add to locations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Summary
Tax
Status
Sold by
JobRequired
Name
Url
Project Id
Location Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment to InvoiceRequired
Number
Type
Invoiced On
Sub total
Tax
Summary
Royalty Status
Royalty Date
Royalty Sent on
Royalty Memo
Review Status
Export
Assigned To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job Id Required
FilenameRequired
File urlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer
Location
Campaign Id Required
Business Unit Id
Job Type
SummaryRequired
Tag Types
Priority
Call Reason Id
Follow Up Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Landing Page UrlRequired
Referrer UrlRequired
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 NumberRequired
Forwarding Phone NumberRequired
Tracking Phone NumberRequired
Call Started OnRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Follow-Up DateRequired
Text
Pin To Top
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
NoteRequired
Pin To Top
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
TypeRequired
ValueRequired
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee TypeRequired
Employee IdRequired
Posted OnRequired
Amount
Memo
Activity Code Id
Invoice Id
Hours
Rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the vendor for this PORequired
Id of the purchase order type for this PORequired
Id of the business unit for this PORequired
Id of the inventory location for this PORequired
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 numberRequired
Summary/memo for this PO
PO dateRequired
PO required on dateRequired
TaxRequired
Shipping costRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reported ToRequired
Assigned ToRequired
Is ClosedRequired
NameRequired
Business UnitRequired
Employee Task TypeRequired
Employee Task SourceRequired
Employee Task ResolutionRequired
Reported dateRequired
Due dateRequired
Involved Employee Id List
Customer Id
Job Id
Project Id
Description
PriorityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID of job to detach from projectRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointment to reschedule.Required
ReasonRequired
MemoRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointment to reschedule.Required
Start date/timeRequired
End date/timeRequired
Arrival window start date/time
Arrival window end date/time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee IdRequired
Action nameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Item type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Campaign
Priority
Business Unit Id
Job Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointments Ids (maximum 50)
ID of job for new appointment
Project Id
Technician Id
Customer Id
ActionThis is an event a Zap performs.SearchFind existing data in your appBusiness Unit Id
ActionThis is an event a Zap performs.SearchFind existing data in your appCategory type
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomers 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
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee Ids (maximum 50)
Employee name
Employee active
Created before
Created on or after
Modified before
Modified on or after
ActionThis is an event a Zap performs.SearchFind existing data in your appEstimate Ids
Job Id
Project Id
Sold By
Sold By Employee
Status
Total greater
Total less
Sold after
Sold before
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoices IDs (maximum 50)
Invoice Number
Status
Job Id
Job Number
Batch Id
Batch Number
Customer Id
ActionThis is an event a Zap performs.SearchFind existing data in your appJob Type Id
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Id
Tag Types
ActionThis is an event a Zap performs.SearchFind existing data in your appMaterials 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
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase 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
ActionThis is an event a Zap performs.SearchFind existing data in your appTag Type Id
ActionThis is an event a Zap performs.SearchFind existing data in your appVendor Ids
Active
External data application Guid
External data key
External data values
Created before
Created on or after
Modified before
Modified on or after
ActionThis is an event a Zap performs.SearchFind existing data in your appNew Channel
Triggers when a new #channel is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.User Name
Highlight Word
Trigger for Bot Messages?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User
Triggers when a new Slack user is created / first joins your org.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ChannelRequired
UsersRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Send Multi Message
Message TextRequired
Send as a bot?
Bot Name
Bot Icon
Include a link to this Zap?
Attach Image by URL
Auto-Expand Links?
Link Usernames and Channel Names?
Schedule At
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
Message TextRequired
Send as a bot?
Bot Name
Bot Icon
Include a link to this Zap?
Attach Image by URL
Auto-Expand Links?
Link Usernames and Channel Names?
Schedule At
Zap Id
File
Thread
Send Channel Message?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Title
Email
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Private Channel
This action creates a private channel in Slack.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Edit Message
This action updates a specific message on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, the new text for the message, and a boolean to indicate if you want to edit a bot message.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search QueryRequired
Sort By
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appIDRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your appUsernameRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your app
No 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProjects 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomers 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEstimates IDs (maximum 50)
Job
Project
Job Number
Sold By
Sold By Employee
Active
Status
Total greater
Total less
Sold after
Sold before
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoices 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planJobs IDs (maximum 50)
Job number
Project Id
Job Status
Appointment Status
Job Type
Business Unit
Customer Id
Location Id
Technician Id
Modified On Or After
Modified Before
Completed On Or After
Tag Types
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planLeads 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNon 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPurchase 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
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEstimates IDs (maximum 50)
Job
Project
Job Number
Sold By
Sold By Employee
Active
Status
Total greater
Total less
Sold after
Sold before
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planId of the appointment to assign to.Required
Technicians IdsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID of job for new appointmentRequired
Start date/timeRequired
End date/timeRequired
Arrival window start date/time
Arrival window end date/time
Technicians Ids
Special instructions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Booking ProviderRequired
SourceRequired
NameRequired
Street
Unit
City
State
Zip
Country
Type
Value
Memo
Type
Value
Memo
Customer Type
Start
SummaryRequired
Campaign
Business Unit
Job Type
Priority
Is First Time ClientRequired
Send Confirmation Email
External IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
TypeRequired
ValueRequired
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee NameRequired
Mobile Phone
Office phone
EmailRequired
Login (Username)
Account creation methodRequired
Business Unit Id
User role IdRequired
List of company positionsRequired
Azure Active Directory User Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Location IdRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IdRequired
Location IdRequired
Business UnitRequired
Project
Estimate
Job Type Required
PriorityRequired
CampaignRequired
StartRequired
EndRequired
Arrival Window Start
Arrival Window End
Technician Ids
Summary
Custom field Id
Value
Custom field Id
Value
Custom field Id
Value
Tag Types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NoteRequired
Pin To Top
Job or Project NotesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BookingRequired
Landing Page UrlRequired
Referrer UrlRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Landing Page UrlRequired
Referrer UrlRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Email
Phone Number
Street
Unit
City
State
Zip
Country
Summary
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CustomerRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TechnicianRequired
StartRequired
DurationRequired
NameRequired
Timesheet CodeRequired
Summary
Clear Dispatch Board
Clear Technician View
Remove Technician From Capacity Planning
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task idRequired
Is ClosedRequired
NameRequired
Assigned ToRequired
Due Date Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Technician NameRequired
Technician's phone number
Email
Login (Username)
Account creation methodRequired
Business Unit Id
User role IdRequired
List of company positionsRequired
Azure Active Directory User Id
License typeRequired
Team name
Daily revenue goal
Burden rate (hourly)
Biography
Memo
Upcoming appointment visibility
Appointment history visibility
Street
Unit
City
State
Zip
Country
Latitude
Longitude
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Dismiss Call ReasonRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointment to remove hold.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the appointment to assign to.Required
Technicians IdsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee IdRequired
Employee Name
Mobile Phone
Office phone
Email
Login (Username)
Business Unit Id
User role Id
List of company positions
Azure Active Directory User Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Estimate IDRequired
Sku
Sku Name
Parent Item Id
DescriptionRequired
Is Add On
Quantity
Unit Price
Skip Updating Membership Prices
Item Group Name
Item Group Root
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Number
Type
Invoiced On
Sub total
Tax
Summary
Royalty Status
Review Status
Royalty Date
Royalty Sent on
Royalty Memo
Export
Assigned To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Purchase order IdRequired
Id of the vendor for this PORequired
Id of the purchase order type for this PORequired
Id of the business unit for this PORequired
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 numberRequired
Summary/memo for this PO
PO dateRequired
PO required on dateRequired
TaxRequired
Shipping costRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Technician Id Required
Action nameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointments Ids (maximum 50)
ID of job for new appointment
Created before
Created on or after
Modified before
Modified on or after
ActionThis is an event a Zap performs.SearchFind existing data in your appBooking provider Ids (maximum 50)
Name of the booking provider tag
Created before
Created on or after
Modified before
Modified on or after
ActionThis is an event a Zap performs.SearchFind existing data in your appCampaign Id
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Id
ActionThis is an event a Zap performs.SearchFind existing data in your appDiscount 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
ActionThis is an event a Zap performs.SearchFind existing data in your appEquipment 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
ActionThis is an event a Zap performs.SearchFind existing data in your appInstalled Equipments Ids
Location Ids
ActionThis is an event a Zap performs.SearchFind existing data in your appTypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLeadRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation Id
ActionThis is an event a Zap performs.SearchFind existing data in your appProject Ids
Customer Id
Location Id
Invoice Id
Technician
Job Id
Appointment Id
ActionThis is an event a Zap performs.SearchFind existing data in your appService 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
ActionThis is an event a Zap performs.SearchFind existing data in your appTechnician Ids (maximum 50)
Technician name
Technician active
Created before
Created on or after
Modified before
Modified on or after
ActionThis is an event a Zap performs.SearchFind existing data in your appTrigger for Bot Messages?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ChannelRequired
Trigger for Bot Messages?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Channel
User Name
Shared
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ChannelRequired
Trigger for Bot Messages?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Saved Message
Triggers when you save a message.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TextRequired
Remind when?Required
Remind who?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
Message TextRequired
Send as a bot?
Bot Name
Bot Icon
Include a link to this Zap?
Attach Image by URL
Auto-Expand Links?
Link Usernames and Channel Names?
Schedule At
File
Thread
Send Channel Message?
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Channel NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
TopicRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Status Text
Status Emoji
Expiration Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Message
This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Remove User from Channel
This action removes a specified user from a specified channel in Slack.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Message by Timestamp
This action retrieves a specific message from a conversation history in Slack using the message's timestamp.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your appFull NameRequired
Return Raw Results?
ActionThis is an event a Zap performs.SearchFind existing data in your app
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Google Sheets + ServiceTitan + Slack Integrations Work
- Step 1: Authenticate Google Sheets, ServiceTitan, and Slack.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.