ServiceTrade + Smartsheet
Add new ServiceTrade invoices to Smartsheet as rows
Easily manage your financial documentation with this workflow. Each time a new invoice is created in ServiceTrade, it will add a row to a designated Smartsheet. This streamlines your record keeping process, ensuring your invoices are efficiently tracked and recorded in real time.
Easily manage your financial documentation with this workflow. Each time a new invoice is created in ServiceTrade, it will add a row to a designated Smartsheet. This streamlines your record keeping process, ensuring your invoices are efficiently tracked and recorded in real time.
- When this happens...
New InvoiceTriggers when a new invoice is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Attachment
Triggers when a new attachment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Comment
Triggers when a new comment is added to a company, deficiency, invoice, job, location, or quote. (Note: The trigger test will only check for job comments.)
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
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SheetRequired
RowRequired
File AttachmentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Add Row to Top or Bottom
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose Source SheetRequired
Choose a Destination SheetRequired
Choose RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SheetRequired
ColumnRequired
Parent Row
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DestinationRequired
Sheet to CopyRequired
Copy Cells?Required
Copy Attachments?Required
Copy Discussions?Required
Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Row IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es)Required
FormatRequired
Email Subject
Message
CC Me?
Paper Size
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a WorkspaceRequired
Email Address(es) to Share ToRequired
Access LevelRequired
Notify via Email?Required
Email Subject
Message
CC Me?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sheet IDRequired
QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
New 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 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 foundGet Reports
[PRIVATE] Generates report list for dropdown.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planWorkspace NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
RowRequired
TitleRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source FolderRequired
Destination FolderRequired
New Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
New NameRequired
What to Include?
Skip Remap
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose Source SheetRequired
Choose a Destination SheetRequired
Choose RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DestinationRequired
TemplateRequired
Copy Cells?Required
Copy Attachments?Required
Copy Discussions?Required
Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es)Required
Choose RowRequired
Email Subject
Message
CC Me?
Include Attachments ?
Include Discussions ?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es) to Share ToRequired
Access LevelRequired
Notify via Email?Required
Email Subject
Message
CC Me?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sheet IDRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About ServiceTrade
Related categories
