Integrate Google Sheets with ServiceTitan to automate your work

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Permanently deletes all data in a selected row. This action cannot be undone.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Triggers when there's a new appointments.

Triggers when there's a new Business Unit.

Triggers when there's a new employee.

Triggers when there's a new Form Submission.

Triggers when there's a new job or project note.

Triggers when there's a new note on a lead.

Triggers when there's a new location.

Triggers when a new purchase order is created.

Triggers when an estimate is updated.

Assign technicians to an existing appointment

Adds a new appointment to an existing job.

Creates a new booking

Adds a contact to an existing customer

Creates a new employees

Creates a new Installed Equipment

Creates a new job

Creates a new note in a job or project

Creates a new lead attribution booking

Creates a new lead attribution form

Create Lead (NO Customer/Location)

Creates a new location

Creates a new non job appointments

Creates a new project

Creates a new sub task

Creates a new technician

Dismisses a lead by id

Removes hold from the appointment.

Unassigns the list of technicians from the appointment

Updates an existing employee

Updates the items in an estimate by id

Updates an invoice by id

Updates a job by id

Updates a location

Update an existing purchase order

Performs standard actions with the account

Gets a list of appointment assignments

Searches Booking Providers

Search Campaigns

Search Customer Contacts

Get data on all of the discounts or fees in the pricebook.

Get data on all of the equipment in the pricebook.

Search an Installed Equipment by Id or Location

Search Jobs

Search Leads

Search Location Contacts

Search projects

Get data on all of the services in the pricebook

Searches a Technician

Create a blank worksheet with a title. Optionally, provide headers.

Format a row in a specific spreadsheet.

Find up to 500 rows based on a column and value as line items.

Return up to 500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.

Triggers when there's a new project.

Triggers when there's a new booking for a booking provider.

Triggers when there's a new customers.

Triggers when there's a new estimate.

Triggers when there's a new invoices.

Triggers when there's a new job.