How to connect Slack + Google Sheets + ServiceTitan
Zapier lets you send info between Slack and Google Sheets and ServiceTitan 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 Slack + Google Sheets + ServiceTitan
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 Slack, Google Sheets, and ServiceTitan. And don’t forget that you can add more apps and actions to create complex workflows.
Trigger 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 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.Raw Request User Info
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.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 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 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
Project Sub 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 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.Number
Type
Invoiced On
Sub total
Tax
Summary
Royalty Status
Royalty Date
Royalty Sent on
Royalty Memo
Review Status
Export
Assigned To
Adjustment to IdRequired
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