How to connect Code by Zapier + Google Sheets + ServiceTrade
Zapier lets you send info between Code by Zapier and Google Sheets and ServiceTrade 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 Code by Zapier + Google Sheets + ServiceTrade
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 Code by Zapier, Google Sheets, and ServiceTrade. And don’t forget that you can add more apps and actions to create complex workflows.
Input Data
CodeRequired
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 foundNew Clock Event
Triggers when a new clock event (clock-in or clock-out) is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Job Comment
Triggers when a new comment is added to a job.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Quote
Triggers when a new quote is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Company
Triggers when an existing Company is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Deficiency
Triggers when an existing deficiency is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Job
Triggers when an existing Job is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Quote
Triggers when an existing quote is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Job Number
File NameRequired
PurposeRequired
ContentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CommentRequired
Location IDRequired
Scheduling CommentRequired
Tech CommentRequired
Billing CommentRequired
Public CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Request TypeRequired
API Endpoint URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Import Type
File NameRequired
ContentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact External ID
External System Name
Company
Location
TypeRequired
First NameRequired
Last Name
Phone Number
Email
Primary
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
Vendor NameRequired
Job TypeRequired
Job Description
Service LineRequired
Service DescriptionRequired
Due Date (Start)
Due Date (End)
Expected Duration
Estimated Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TagRequired
Entity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IDRequired
Invoice TypeRequired
Invoice StatusRequired
Name
Invoice Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Company Address City
Company Address State
Company Address Postal Code
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch StringRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDeficiency NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appJob NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal System NameRequired
External IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch StringRequired
Contact External ID
External System Name
Company
Location
TypeRequired
First NameRequired
Last Name
Phone Number
Email
Primary
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Input Data
CodeRequired
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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 foundNew Attachment
Triggers when a new attachment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Company
Triggers when a new company is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deficiency
Triggers when a new deficiency is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Job
Triggers when a new job is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Location
Triggers when a new location is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Appointment
Triggers when an existing appointment is updated or a new appointment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact
Triggers when an existing contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Invoice
Triggers when an existing invoice is updated or a new invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Location
Triggers when an existing Location is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.LocationRequired
Asset DataRequired
Asset TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CommentRequired
Job NumberRequired
Scheduling CommentRequired
Tech CommentRequired
Billing CommentRequired
Public CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TagRequired
Entity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.JobRequired
Tech IDs
Window Start
Window End
Released
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice TypeRequired
Invoice StatusRequired
Job IDRequired
Name
Invoice Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.JobRequired
Libitem
Display NameRequired
Quantity
Cost
Service Line
Used On Date
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
Job TypeRequired
Quote DescriptionRequired
Service LineRequired
Service DescriptionRequired
Service Window Start
Service Window End
Expiration Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointment IDRequired
Job ID
Tech IDs
Window Start
Window End
Released
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact
Company
Location
Type
First Name
Last Name
Phone Number
Email
Primary
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job ItemRequired
Libitem
Display Name
Quantity
Cost
Service Line
Used On Date
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset SearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal System NameRequired
External IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContract NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appJob IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation NameRequired
Location Address Street
Location Address City
Location Address State
Location Address Postal Code
Company ID
ActionThis is an event a Zap performs.SearchFind existing data in your appQuote NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundLocation 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Code by Zapier + Google Sheets + ServiceTrade Integrations Work
- Step 1: Authenticate Code by Zapier, Google Sheets, and ServiceTrade.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.