ServiceTrade + Smartsheet

ServiceTrade + Smartsheet integrations

Add rows to Smartsheet when updated invoices occur in ServiceTrade

Manage your financial documents more efficiently with this workflow. Whenever an invoice is updated in ServiceTrade, a new row will be inserted into your chosen Smartsheet, ensuring your records stay updated and accurate. This automatic process eliminates manual data entry, streamlining your bookkeeping tasks and freeing up more time for you to focus on other vital aspects of your business.

When this happens...
Updated InvoiceTriggers when an existing invoice is updated or a new invoice is created.
TriggerInstant
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with ServiceTrade and Smartsheet

Discover other triggers and actions you can use with ServiceTrade and Smartsheet

New Attachment
Triggers when a new attachment is created.
Trigger
Instant
Try It
New Comment
Triggers when a new comment is added to an asset, company, deficiency, invoice, job, location, or quote. (Note: The trigger test will only check for job comments.)
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 Name
  Required
- Purpose
  Required
- Content
  Required
Action
Write
- Comment
  Required
- Location ID
  Required
- Scheduling Comment
  Required
- Tech Comment
  Required
- Billing Comment
  Required
- Public Comment
  Required
Action
Write
- Request Type
  Required
- API Endpoint URL
  Required
Action
Write
- Import Type
- File Name
  Required
- Content
  Required
Action
Write
- Contact External ID
- External System Name
- Company
- Location
- Type
  Required
- First Name
  Required
- Last Name
- Phone Number
- Email
- Primary
Action
Write
- Location
  Required
- Vendor Name
  Required
- Job Type
  Required
- Job Description
- Service Line
  Required
- Service Description
  Required
- Due Date (Start)
- Due Date (End)
- Expected Duration
- Estimated Price
Action
Write
- Company
  Required
- Taxable
- Location External ID
- Location External System Name
- Location Name
  Required
- Location Address Street
  Required
- Location Address City
  Required
- Location Address State
  Required
- Location Address Postal Code
- Phone Number
- Email
- Latitude
- Longitude
- Status
Action
Write
- Tag
  Required
- Entity Type
  Required
Action
Write
- Company
  Required
- 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 ID
  Required
- Invoice Type
  Required
- Invoice Status
  Required
- Name
- Invoice Number
Action
Write
- Location
  Required
- 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 Name
  Required
- Company Address City
- Company Address State
- Company Address Postal Code
Action
Search
- Search String
  Required
Action
Search
- Deficiency Number
  Required
Action
Search
- Job Number
  Required
Action
Search
- External System Name
  Required
- External ID
  Required
Action
Search
- Company Name
  Required
- Company Address City
- Company Address State
- Company Address Postal Code
- Company External ID
- External System Name
- Company Address Street
  Required
- Company Address City
  Required
- Company Address State (2-letter abbreviation)
  Required
- Company Address Postal Code
- Company Status
Action
Search or write
- Search String
  Required
- Contact External ID
- External System Name
- Company
- Location
- Type
  Required
- First Name
  Required
- Last Name
- Phone Number
- Email
- Primary
Action
Search or write
- External System Name
  Required
- External ID
  Required
- Company
  Required
- Taxable
- Location External ID
- Location External System Name
- Location Name
  Required
- Location Address Street
  Required
- Location Address City
  Required
- Location Address State
  Required
- Location Address Postal Code
- Phone Number
- Email
- Latitude
- Longitude
- Status
Action
Search or write
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

New Clock Event
Triggers when a new clock event (clock-in or clock-out) 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
- Location
  Required
- Asset Data
  Required
- Asset Type
  Required
Action
Write
- Comment
  Required
- Job Number
  Required
- Scheduling Comment
  Required
- Tech Comment
  Required
- Billing Comment
  Required
- Public Comment
  Required
Action
Write
- Tag
  Required
- Entity Type
  Required
Action
Write
- Job
  Required
- Tech IDs
- Window Start
- Window End
- Released
- Status
Action
Write
- Company External ID
- External System Name
- Company Name
  Required
- Company Address Street
  Required
- Company Address City
  Required
- Company Address State (2-letter abbreviation)
  Required
- Company Address Postal Code
- Company Status
Action
Write
- Invoice Type
  Required
- Invoice Status
  Required
- Job ID
  Required
- Name
- Invoice Number
Action
Write
- Job
  Required
- Libitem
- Display Name
  Required
- Quantity
- Cost
- Service Line
- Used On Date
- Source
Action
Write
- Location
  Required
- Job Type
  Required
- Quote Description
  Required
- Service Line
  Required
- Service Description
  Required
- Service Window Start
- Service Window End
- Expiration Date
Action
Write
- Appointment ID
  Required
- 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 Item
  Required
- Libitem
- Display Name
- Quantity
- Cost
- Service Line
- Used On Date
- Source
Action
Write
- Asset Search
  Required
Action
Search
- External System Name
  Required
- External ID
  Required
Action
Search
- Contract Name
  Required
Action
Search
- Job ID
  Required
Action
Search
- Location Name
  Required
- Location Address Street
- Location Address City
- Location Address State
- Location Address Postal Code
- Company ID
Action
Search
- Quote Number
  Required
Action
Search
- External System Name
  Required
- External ID
  Required
- Company External ID
- External System Name
- Company Name
  Required
- Company Address Street
  Required
- Company Address City
  Required
- Company Address State (2-letter abbreviation)
  Required
- Company Address Postal Code
- Company Status
Action
Search or write
- Location Name
  Required
- Location Address Street
  Required
- Location Address City
  Required
- Location Address State
  Required
- Location Address Postal Code
- Company
  Required
- Taxable
- Location External ID
- Location External System Name
- Phone Number
- Email
- Latitude
- Longitude
- Status
Action
Search or write
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Workspace
- Source Folder
  Required
- Destination Workspace
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

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 moreLearn moreHelpHelp

Related categories

Scheduling & Booking

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Add rows to Smartsheet when appointments get updated in ServiceTrade

Add new ServiceTrade quotes to Smartsheet as rows instantly