Google Sheets + ServiceTrade + Filter by Zapier

New Google Sheets rows for deactivated ServiceTrade locations

It can be valuable to understand when, and by whom, ServiceTrade Locations are marked as inactive. This integration will add a new spreadsheet row to a Google Sheets document every time a Location in ServiceTrade is deactivated. You can then easily see the timestamp of when the Location was marked inactive, and user that performed the action.

When this happens...
Updated Location
Triggers when an existing Location is updated.
TriggerInstant
automatically do this...
Only continue if...
Set up rules to specify when this Zap can continue running.
ActionFilter
then do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
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

What does this mean?

New Attachment
Triggers when a new attachment is created.
Trigger
Instant
Try It
New Company
Triggers when a new company is created.
Trigger
Instant
Try It
New Deficiency
Triggers when a new deficiency is created.
Trigger
Instant
Try It
New Job
Triggers when a new job is created.
Trigger
Instant
Try It
New Location
Triggers when a new location is created.
Trigger
Instant
Try It

Updated Appointment
Triggers when an existing appointment is updated or a new appointment is created.
Trigger
Instant
Try It
Updated Contact
Triggers when an existing contact is updated.
Trigger
Instant
Try It

Updated Invoice
Triggers when an existing invoice is updated or a new invoice is created.
Trigger
Instant
Try It
Updated Location
Triggers when an existing Location is updated.
Trigger
Instant
Try It
- LocationRequired
- Asset DataRequired
- Asset TypeRequired
Action
Write
- CommentRequired
- Job NumberRequired
- Scheduling CommentRequired
- Tech CommentRequired
- Billing CommentRequired
- Public CommentRequired
Action
Write
- TagRequired
- Entity TypeRequired
Action
Write
- JobRequired
- Tech IDs
- Window Start
- Window End
- Released
- Status
Action
Write
- Company External ID
- External System Name
- Company NameRequired
- Company Address StreetRequired
- Company Address CityRequired
- Company Address State (2-letter abbreviation)Required
- Company Address Postal Code
- Company Status
Action
Write
- Invoice TypeRequired
- Invoice StatusRequired
- Job IDRequired
- Name
- Invoice Number
Action
Write
- JobRequired
- Libitem
- Display NameRequired
- Quantity
- Cost
- Service Line
- Used On Date
- Source
Action
Write
- LocationRequired
- Job TypeRequired
- Quote DescriptionRequired
- Service LineRequired
- Service DescriptionRequired
- Service Window Start
- Service Window End
- Expiration Date
Action
Write
- Appointment IDRequired
- Job ID
- Tech IDs
- Window Start
- Window End
- Released
- Status
Action
Write
- Contact
- Company
- Location
- Type
- First Name
- Last Name
- Phone Number
- Email
- Primary
Action
Write
- Job ItemRequired
- Libitem
- Display Name
- Quantity
- Cost
- Service Line
- Used On Date
- Source
Action
Write
- Asset SearchRequired
Action
Search
- External System NameRequired
- External IDRequired
Action
Search
- Contract NameRequired
Action
Search
- Job IDRequired
Action
Search
- Location NameRequired
- Location Address Street
- Location Address City
- Location Address State
- Location Address Postal Code
- Company ID
Action
Search
- Quote NumberRequired
Action
Search
- External System NameRequired
- External IDRequired
- Company External ID
- External System Name
- Company NameRequired
- Company Address StreetRequired
- Company Address CityRequired
- Company Address State (2-letter abbreviation)Required
- Company Address Postal Code
- Company Status
Action
Search or write
- Location NameRequired
- Location Address StreetRequired
- Location Address CityRequired
- Location Address StateRequired
- Location Address Postal Code
- CompanyRequired
- Taxable
- Location External ID
- Location External System Name
- Phone Number
- Email
- Latitude
- Longitude
- Status
Action
Search or write
- Only continue if...Required
Action
Filter
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

New Clock Event
Triggers when a new clock event (clock-in or clock-out) is created.
Trigger
Instant
Try It
New Contact
Triggers when a new contact is created.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
New Job Comment
Triggers when a new comment is added to a job.
Trigger
Instant
Try It
New Quote
Triggers when a new quote is created.
Trigger
Instant
Try It
Updated Company
Triggers when an existing Company is updated.
Trigger
Instant
Try It
Updated Deficiency
Triggers when an existing deficiency is updated.
Trigger
Instant
Try It
Updated Job
Triggers when an existing Job is updated.
Trigger
Instant
Try It
Updated Quote
Triggers when an existing quote is updated.
Trigger
Instant
Try It
- Job Number
- File NameRequired
- PurposeRequired
- ContentRequired
Action
Write
- CommentRequired
- Location IDRequired
- Scheduling CommentRequired
- Tech CommentRequired
- Billing CommentRequired
- Public CommentRequired
Action
Write
- Request TypeRequired
- API Endpoint URLRequired
Action
Write
- Import Type
- File NameRequired
- ContentRequired
Action
Write
- Contact External ID
- External System Name
- Company
- Location
- TypeRequired
- First NameRequired
- Last Name
- Phone Number
- Email
- Primary
Action
Write
- LocationRequired
- Vendor NameRequired
- Job TypeRequired
- Job Description
- Service LineRequired
- Service DescriptionRequired
- Due Date (Start)
- Due Date (End)
- Expected Duration
- Estimated Price
Action
Write
- CompanyRequired
- Taxable
- Location External ID
- Location External System Name
- Location NameRequired
- Location Address StreetRequired
- Location Address CityRequired
- Location Address StateRequired
- Location Address Postal Code
- Phone Number
- Email
- Latitude
- Longitude
- Status
Action
Write
- TagRequired
- Entity TypeRequired
Action
Write
- CompanyRequired
- Company External ID
- Company External System Name
- Company Name
- Company Address Street
- Company Address City
- Company Address State
- Company Address Postal Code
- Company Status
Action
Write
- Invoice IDRequired
- Invoice TypeRequired
- Invoice StatusRequired
- Name
- Invoice Number
Action
Write
- LocationRequired
- Taxable
- Location External ID
- Location External System Name
- Location Name
- Location Address Street
- Location Address City
- Location Address State
- Location Address Postal Code
- Phone Number
- Email
- Latitude
- Longitude
- Company
- Status
Action
Write
- Company NameRequired
- Company Address City
- Company Address State
- Company Address Postal Code
Action
Search
- Search StringRequired
Action
Search
- Deficiency NumberRequired
Action
Search
- Job NumberRequired
Action
Search
- External System NameRequired
- External IDRequired
Action
Search
- Company NameRequired
- Company Address City
- Company Address State
- Company Address Postal Code
- Company External ID
- External System Name
- Company Address StreetRequired
- Company Address CityRequired
- Company Address State (2-letter abbreviation)Required
- Company Address Postal Code
- Company Status
Action
Search or write
- Search StringRequired
- Contact External ID
- External System Name
- Company
- Location
- TypeRequired
- First NameRequired
- Last Name
- Phone Number
- Email
- Primary
Action
Search or write
- External System NameRequired
- External IDRequired
- CompanyRequired
- Taxable
- Location External ID
- Location External System Name
- Location NameRequired
- Location Address StreetRequired
- Location Address CityRequired
- Location Address StateRequired
- Location Address Postal Code
- Phone Number
- Email
- Latitude
- Longitude
- Status
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About ServiceTrade

ServiceTrade is a customer service and sales application for commercial service contractors. Convert more of your contract work into repair revenue. Educate customers about the work you did for them with media-rich online service reports. Manage your service operations and connect your customer service data with other business applications.

Learn more

Related categories

Scheduling & Booking

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Learn more

Google Sheets + ServiceTrade + Filter by Zapier

New Google Sheets rows for deactivated ServiceTrade locations

New Attachment

New Company

New Deficiency

New Job

New Location

Updated Appointment

Updated Contact

Updated Invoice

Updated Location

Add Asset to Location

Add Comment to Job

Add Tag

Create Appointment

Create Company

Create Invoice

Create Job Item

Create Quote

Update Appointment

Update Contact

Update Job Item

Find Asset by Search

Find Company by External ID

Find Contract by Name

Find Job by Job ID

Find Location

Find Quote by Quote Number

Find or Create Customer Company by External ID

Find or Create Customer Location

Only continue if...

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Clock Event

New Contact

New Invoice

New Job Comment

New Quote

Updated Company

Updated Deficiency

Updated Job

Updated Quote

Add Attachment to Job

Add Comment to Location

Create API Request

Upload File to Bulk Import

Create Contact

Create Job

Create Location

Remove Tag

Update Company

Update Invoice

Update Location

Find Company

Find Contact

Find Deficiency by Deficiency Number

Find Job by Job Number

Find Location by External ID

Find or Create Customer Company

Find or Create Contact

Find or Create Customer Location by External ID

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet