Route4Me and Smartsheet Integration

Demonstration of how apps are integrated in WEXTL workflow builder[4]

Connect Route4Me and Smartsheet to automate project management workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.

  • 3-day trial
  • Cancel anytime
  • Up to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Learn about Route4Me and Smartsheet

Detailed info you need to know about Route4Me and Smartsheet integrations in WEXTL. Explore which modules apps support and how you connect them.

  • Route4Me

    • Project Management
    • 1 trigger
    • 52 searches
    • 62 actions

    Route planning and optimization for deliveries and field teams.[5]

  • Smartsheet

    • Project Management
    • 5 triggers
    • 27 searches
    • 44 actions

    Work management for sheets, rows, workspaces, reports, and users.[6]

How to connect Route4Me to Smartsheet

Set up your Route4Me and Smartsheet integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.

How does the integration between Route4Me and Smartsheet work in WEXTL?

WEXTL exposes actions and triggers for Route4Me and Smartsheet that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.

Route4Me triggersSmartsheet actions

Route4Me modules

  • Watch Activities Reads the activity feed at each interval and returns every entry as its own run, with its Activity Type and Activity Message. Narrow it with Route.
  • Add a Note File Attaches a File to a route stop as a note, saved under File Name. Add Device Latitude, Device Longitude or Device Type to record where the note was written and on which device.
  • Add a Route Note Writes a text note on a route stop from Contents. Use Note Type for dropoff, pickup, breakdown or a custom type, and Device Latitude and Device Longitude for where it was written.
  • Add Addresses to a Route Adds stops from Addresses to a route. Turn on Insert at Optimal Position to put each stop where it fits best, or use After Destination ID to place them after a chosen stop.
  • Add an Address to an Optimization Adds stops to an existing optimization from Addresses. Turn on Re-optimize to solve the optimization again after adding them.
  • Add an Order to a Route Places existing orders on a route via Order IDs. Use Additional Fields (JSON) to send extra values with the request.
  • Add an Order to an Optimization Adds existing orders to an optimization. List them under Order IDs, and use Additional Fields (JSON) to send more Route4Me fields with the request.
  • Create a Config Setting Stores a configuration setting, with a Value saved under a Key. Read it back later with Get a Config Setting.
  • Create a Group Creates a group for address book entries. Set Color and Icon for how it looks, and Filter (JSON) to fill the group automatically from rules.
  • Create a Location Saves an address book entry for an Address. Add contact details such as First Name, Email and Phone, plus a Group and Custom Data.
  • Create a Note Type Defines a custom route note type under a Type. Fill Values with the allowed values, or leave it empty for free text.
  • Create a Route Creates a route from a list of Addresses. Configure it with Route Name, Route Date, Route Start Time (s), Travel Mode and Vehicle Capacity.
  • Create a Territory Creates a territory. Start from Name and Shape, then give Center Latitude, Center Longitude and Radius (m) for a circle or Points for other shapes, and set Color.
  • Create a User Adds a team member with an Email, First Name, Last Name, Password and User Type. Turn on Read-only User to make the account read-only, and Hide Routed Addresses or Hide Visited Addresses to keep those out of view.
  • Create a Vehicle Adds a vehicle to your fleet under an Alias. Record VIN, Make, Model Year, Fuel Type, Height (in) and Weight (lb), and turn on Has Trailer if it pulls one.
  • Create an Avoidance Zone Creates an area to avoid. Pick a Shape, then give Center Latitude, Center Longitude and Radius (m) for a circle, or Points for a rectangle or polygon.
  • Create an Optimization Plans routes from a list of Addresses. Tune it with Algorithm, Travel Mode, Optimize For, Distance Unit, Vehicle Capacity and Depots, and label it with Route Name.
  • Create an Order Creates an order for an Address. Add Time Window Start (s) and Time Window End (s), a Scheduled Day, and Custom Data.
  • Create an Order Custom Field Adds a field to your orders from a Name, a Label and a Type. Use Type Info (JSON) for settings that depend on the type.
  • Create Config Settings in Bulk Stores a batch of configuration settings in one request, each with its own Key and Value.
  • Delete a Config Setting Deletes a stored configuration setting by its Key.
  • Delete a Group Removes a group of address book entries.
  • Delete a Note Type Removes a custom note type you defined earlier.
  • Delete a Territory Removes a territory that you saved in Route4Me.
  • Delete a User Removes a team member from your Route4Me account.
  • Delete a Vehicle Deletes a vehicle from your fleet in Route4Me.
  • Delete an Avoidance Zone Removes an avoidance zone from Route4Me.
  • Delete an Order Custom Field Deletes a field that was added to the orders of your account.
  • Delete Locations Deletes address book entries in bulk, those listed under Location IDs.
  • Delete Optimizations Deletes the optimizations listed under Optimization IDs in a single request.
  • Delete Orders Deletes several orders in one request, those listed under Order IDs.
  • Delete Routes Removes multiple routes, those listed under Route IDs.
  • Duplicate a Route Copies a route. Set Duplicate To to make the copy a Route, or leave it empty for a plain copy.
  • Find Optimizations by Date Finds optimizations created between a Start Date and an End Date.
  • Find Routes by Date Finds routes between a Start Date and an End Date, with their Vehicle Alias and Created Timestamp.
  • Geocode Addresses in Bulk Geocodes many rows in a single request. Each row holds an Address and optional contact fields such as First Name and Email.
  • Geocode an Address Looks up coordinates for each entry of Addresses, returning the matched Lat and Lng.
  • Geocode an Uploaded File Starts geocoding of an address file you uploaded earlier, using its Upload ID, and reports the Status and Rows.
  • Get a Config Setting Fetches the value stored under a Key.
  • Get a Group Pulls one address book group, returning its Group Name, Group Color and Filter.
  • Get a Route Returns a route with its Route Cost and Route Distance Km. Turn on Include Notes, Include Tracking History, Include Directions, Include Original Route or Include Order Inventory to add them.
  • Get a Route Address Retrieves a single stop by Route Destination ID, with its Address, Alias, Lat and Lng. Add a Route or Optimization to say where to look.
  • Get a Schedule Calendar Gets calendar data between From and To. Turn on Include Orders, Include Locations or Include Route Counts to add them, and use Time Zone Offset (min) to set minutes east of UTC.
  • Get a Telematics Vendor Fetches a vendor by Vendor ID, returning its Name, Features and Countries.
  • Get a Territory Opens a territory, returning its Territory Name and Territory Color.
  • Get a Territory with Addresses and Orders Returns a territory along with the addresses and orders that fall inside it.
  • Get a User Looks up a team member, returning their Member Email, Member First Name and Member Type.
  • Get a Vehicle Shows a fleet vehicle, returning its Vehicle Alias, Vehicle VIN and Fuel Type.
  • Get an Asset Tracking Looks up the tracking history of a Tracking Number, listing Status, Lat, Lng and Timestamp.
  • Get an Avoidance Zone Fetches one avoidance zone, returning its Territory Name and Territory Color.

Smartsheet modules

  • Add a Column Inserts a new column into a sheet. Use Column to set its Title, Type, Format or Index, which decides where it sits among the existing columns.
  • Add a Row Inserts rows into a sheet. Use Rows to give each new row a Value for every Column ID. Returns the new Row number and Parent ID.
  • Add a Sheet Attachment Attaches a link or file to a sheet by its Name and URL. Use Attachment Type to say whether it is a file or link, Attachment Sub Type for the format, and Description for a note.
  • Add an Alternate Email Adds a secondary email address to one Smartsheet user. The user comes from List Users. Returns Message and Result code.
  • Attach New Sheet Attachment Uploads a new version of an attachment that is already on a sheet or row. The new file is read from Name and URL. Use Attachment Type for its kind.
  • Copy a Sheet Duplicates a sheet into a folder or workspace. Use Destination Type and Destination ID to place the copy, New Sheet Name to title it and Include to bring along parts of the original.
  • Copy a Workspace Duplicates a whole workspace. Use Workspace New Name to title the copy. The new workspace arrives with its ID, Name and Permalink.
  • Copy Rows Copies rows onto the bottom of a second sheet, keeping the originals in place. The output pairs each source row with its copy under Row mappings.
  • Create a Discussion Starts a discussion thread on a sheet with the Comment as its first message. Add a File to attach a document to the thread.
  • Create a Group Creates a group in your organization account. Group names must be unique across the organization. Use Description for its purpose and Members to add people right away.
  • Create a Proof Generates a proof for a row of a sheet out of an uploaded File. Returns the Proof request URL and Document type of the new proof.
  • Create a Proof Request Emails people a request to review a proof. Add the recipients under Send To and write the email as Subject and Message. Turn on Is Downloadable to allow downloads. Turn on CC Me to get a copy yourself.
  • Create a Report Builds a Smartsheet report that pulls rows from several sheets. Use Columns to decide what it shows, Destination to place it, and Is Summary Report to make it a sheet summary. Returns the Permalink.
  • Create a Sheet in Folder Makes a new sheet inside a folder. Start it with Columns, each with a Title and Type, or copy the layout of a Template ID. The output includes the Permalink.
  • Create a Sheet in Workspace Puts a sheet straight into a workspace. Columns lay out its structure, or Template ID copies an existing one. Output includes the ID and Name of the new sheet.
  • Create a User Adds a person to your organization account from their Email, First Name and Last Name. Use Status to set their state and Admin to make them a system admin who manages user accounts.
  • Create a Workspace Creates a new Smartsheet workspace. Names are limited to 50 characters. Returns its Permalink.
  • Delete a Column Deletes a column, located by Column ID.
  • Delete a Discussion Removes a discussion thread, found with Discussion ID.
  • Delete a Group Deletes a group from the organization, identified by its Group ID.
  • Delete a Proof Deletes a proof, taking the Proof ID and its Sheet ID.
  • Delete a Report Removes a report from Smartsheet. Sheets that feed the report are not touched.
  • Delete a Row Deletes rows of a sheet with no way to undo it. Row IDs come from Get a Row.
  • Delete a Sheet Deletes a whole sheet from Smartsheet.
  • Delete a Workspace Removes a workspace from your Smartsheet account.
  • Delete All Attachment Versions Removes every version of one attachment on a sheet.
  • Delete an Alternate Email Removes a secondary email address from a user.
  • Delete an Attachment Detaches a document or URL from a sheet.
  • Delete an Automation Rule Clears one automation rule from a sheet, using Sheet ID and Automation Rule ID.
  • Export a Sheet Downloads a sheet in whichever Format you need and returns it as File Data. Add Paper Size when exporting a PDF.
  • Get a Column Fetches the definition of one column, including its Format and Index. Use Level to change how object values such as multi-contact cells appear in text and number columns.
  • Get a Contact Reads one saved contact. Returns the Email and a Confirmed flag.
  • Get a Discussion Fetches a discussion with its Title, Comments and Comment count.
  • Get a Group Retrieves an organization group with its Name, Description, Owner and Members.
  • Get a Proof Fetches a proof from a sheet. Use Include with a comma-separated list such as Attachments or Discussions to add those parts.
  • Get a Report Reads one report. Trim optional parts of the output through Include and Exclude, or allow COMMENTER access with Access API Level.
  • Get a Row Returns a single row of a sheet: its Row number, Parent ID and Cells.
  • Get a Sheet Reads the structure of a sheet, including its Columns, Attachments, Discussions and Owner ID.
  • Get a User Reads one user of the organization, with their Email, Seat type and whether they are an Admin.
  • Get a Workspace Fetches one workspace with its Name, Permalink, creation and modification times, and your Access level.
  • Get an Alternate Email Looks up one secondary address of a user. Returns its ID and Email, plus a Confirmed flag.
  • Get an Attachment Creates a temporary download link for an attachment. Output has the URL and the URL expires in millis value, so fetch the file before it lapses.
  • Get an Automation Rule Reads an automation rule on a sheet along with the values of its Action. Output also says whether the rule is Enabled and gives its Name.
  • Get the Current User Shows the account behind the credential, with its Email, First name and whether it is an Admin.
  • List Attachments Lists every attachment on a sheet, including those on rows and discussions. Cap the results with Limit.
  • List Automation Rules Shows which automation rules a sheet has. Add a Limit for a shorter list.
  • List Columns Returns each column of a sheet. Use Level to control how object values are formatted, and Limit to trim the list.
  • List Contacts Lists the contacts saved in your Smartsheet account. Use Limit to stop the list at a chosen count.
  • List Discussions Gets all discussions on a sheet. Use Include to add optional parts to each discussion.
  • List Groups Finds the groups in your organization. Use Modified Since to keep only groups changed on or after a date and time, and Limit to stop the search early.

Explore alternative integrations

There are other apps[9] supported by WEXTL that can be paired with Route4Me and Smartsheet integrations. Pick any from the list below if the current combination isn't the one you need.

Automate Route4Me and Smartsheet on WEXTL®

Claim your 3-day trial to build Route4Me with Smartsheet integration and access every WEXTL® feature.

Cancel anytime.

Frequently asked questions

Common questions about connecting Route4Me and Smartsheet.

How do I connect Route4Me and Smartsheet?

Connect your Route4Me and Smartsheet accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them.[3]

What can I automate between Route4Me and Smartsheet?

Example: when the "Watch Activities" trigger in Route4Me fires, WEXTL can "Add a Column" in Smartsheet. Route4Me has 1 trigger (including Watch Activities). Smartsheet has 71 actions (including Add a Column, Add a Row, and Add a Sheet Attachment). Add filters and transforms between steps when you need them.[1]

Can Route4Me trigger actions in Smartsheet, and Smartsheet in Route4Me?

Yes. The integration works in both directions. Use the triggers of each app to start a workflow and the actions of the other app to update it.[2]

Do I need to write code to integrate Route4Me and Smartsheet?

No. Route4Me-to-Smartsheet automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic.[4]

Does Route4Me integrate with Smartsheet in real time?

Yes. Trigger-based automations start the moment Route4Me (or Smartsheet) fires a new event. Webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control.[7]

How long does it take to set up a Route4Me + Smartsheet integration?

A first automation typically takes 5–10 minutes: connect the credential of each app once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.

Do I need a paid plan to connect Route4Me with Smartsheet?

You can build your Route4Me + Smartsheet automation on a 3-day trial with every feature unlocked. Cancel anytime.[8]

References

List of sources used to gather information about the Route4Me and Smartsheet integration.

  1. Route4Me and Smartsheet integration source code, module specs and credentials implementation.
  2. Our Route4Me and Smartsheet integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for Route4Me and Smartsheet, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® visual workflow builder, anonymized data from our technical support team.
  5. Route4Me integration information
  6. Smartsheet integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

How we write our apps documentation

Explore how WEXTL® crafted Route4Me and Smartsheet integration page documentation. Used sources, the role of AI, and how the team validates the result.

Explore Route4Me and Smartsheet, or get started