Ascora and Smartsheet Integration

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

Connect Ascora 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 Ascora and Smartsheet

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

  • Ascora

    • Project Management
    • 2 triggers
    • 29 searches
    • 39 actions

    Field service management software for trades: jobs, quotes, bookings, customers and invoices.[5]

  • Smartsheet

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

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

How to connect Ascora to Smartsheet

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

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

WEXTL exposes actions and triggers for Ascora 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.

Ascora triggersSmartsheet actions

Ascora modules

  • Add Kits to a Job Attaches kits to a job. Each one needs a Quantity for how many go on it.
  • Add Kits to a Quote Adds kits from List Kits to a quote, counted by Quantity. Use a section or stage as the Quote Number to add them there.
  • Add Labour Items to a Job Books labour items onto a job so the time is costed against that job. Use Quantity to set how much of each labour item to book.
  • Add Labour Items to a Quote Prices labour on a quote using role IDs from List Labour Roles and a Quantity for each. A section or stage works as the Quote Number too.
  • Add Quote Sections Splits a quote into named sections, each added to Sections with its own Name.
  • Add Supplies to a Job Records the parts and materials used on a job as supplies. Use Quantity for how many of each were used.
  • Add Supplies to a Quote Brings supplies from List Supplies onto a quote as lines. Give each one a Quantity.
  • Add Write-Ins to a Quote Adds free-text lines to a quote for items that are not in your price lists. Fill Write-Ins with the lines to add.
  • Archive Bookings Archives every booking listed under Booking IDs. Turn on Archive Related Bookings to archive linked bookings as well.
  • Clear Quote Items Empties a quote of lines by type. Turn on Remove Supplies, Remove Kits or Remove Labour to choose what goes.
  • Convert a Quote to a Job Converts a quote into a job. Turn on Create a New Job to create one even when the quote already has a job.
  • Create a Booking Schedules one or more Users from a Start Time, ending at an End Time or after a Duration (minutes). Link it to a Job Number or Quote Number, and refuse clashing slots by ticking Reject Conflicts.
  • Create a Contact Adds a person to a customer from their First Name, Last Name, Email, Phone or Mobile. Turn on Default Contact to make them the main contact, and set a Contact Role.
  • Create a Customer Registers a customer with a Company Name or contact names, an Email and street or postal addresses. Classify it with Customer Type and Lead Source, and store your own values with Custom Fields.
  • Create a Job Raises a job for a Site Customer. Add Supplies, Kits or Labour Items up front, and use Job Type, Job Status or Purchase Order Number to classify it.
  • Create a Note Writes a Note on any record type, using Record Type and Record ID to say where. Set Created By to change the author name shown.
  • Create a Payment Records a Payment Amount against an invoice number. Add a Payment Date, Payment Method or Receipt Number, and an Idempotency Key to guard against duplicates.
  • Create a Quote Prepares a quote for a Site Customer. Fill Supplies, Kits or Labour Items to price it, and set a Job Type.
  • Create a Supplier Adds a supplier by Name with a Business Number, contact details and addresses. Set Invoice Due Type and Invoice Due Days for payment terms, and an Expense Account.
  • Create a Supplier Invoice Enters a bill from a supplier as Lines, each carrying a Quantity and Total Amount Ex Tax. Set an Invoice Date, Due Date or Reference, and flag Expense for an expense bill.
  • Create a Webhook Subscription Registers a Hook URL to receive one Event from Ascora. Give it a System Name to recognise the subscription later.
  • Create an Enquiry Records a new lead from a Company Name or contact name, with a Description of the work and a Lead Source. Returns the Entity ID.
  • Delete a Quote Deletes a quote from Ascora by its full Quote Number.
  • Delete a Webhook Subscription Removes a webhook subscription from Ascora and returns its Subscription ID with a Deleted flag.
  • Download a Zip of Attachments Collects the attachments of a record into one zip file. Filter by Attachment Types or File Name Contains, or by the Created From and Created To dates.
  • Get a Booking Reads one booking with its Booking Type, Start Time and End Time, using the ID from Search Bookings or Create a Booking.
  • Get a Contact Retrieves one contact with its First Name, Last Name, Email Address and Phone Number. The ID comes from Search Contacts or List Customer Contacts.
  • Get a Customer Fetches one customer with its Customer Number, Company Name and contact names. The customer ID is returned by Search Customers.
  • Get a Job Reads one job by its Job number, showing its Job Name, Job Description and Job Status. A section or stage uses a dash in the number.
  • Get a Quote Reads one quote by Quote number with its Quote Name, Quote Description and Quote Status.
  • Get a Supplier Retrieves a supplier with its Supplier Number, Business Number and Phone. The supplier ID is listed by Search Suppliers.
  • Get a Supplier Invoice Reads a supplier bill with its Tracking Number, Invoice Date, Due Date and Supplier. Search Supplier Invoices gives the ID.
  • Get Invoices to Send Lists invoices waiting to go to your accounting system, up to a Prior To Date. Use Limit to bound the list, and add custom fields with Include Job Custom Fields, Include Invoice Custom Fields or Include Customer Custom Fields.
  • Get Job Timesheets Pulls the timesheets logged against a job, giving each its User, Start Time, End Time and Hours.
  • Get Payments to Send Lists payments not yet sent to accounting, up to a Prior To Date, with their Payment Amount and Payment Method.
  • Get the Labour on a Job Shows the labour lines on a job, each with Hours and Hourly Rate Ex Tax. Use Limit to cut the list off.
  • List Activity Types Returns the activity types that bookings can use, each with its ID and Name.
  • List Categories Fetches inventory categories with their Category Number and Parent. Filter with Top Level Only, Category Level or Search Text.
  • List Customer Contacts Shows every contact person stored under one customer, with First Name, Last Name and Email Address.
  • List Kits Lists inventory kits with their Kit Number and Unit Sell Price. Narrow with Favourites Only, Category One ID, Category Two ID or Search Text.
  • List Labour Roles Returns labour roles with their Hourly Rate Ex Tax. The role IDs feed the labour lines added to quotes.
  • List Standard Sections Gets the standard quote sections, each with its Display Order.
  • List Standard Stages Gets the standard job stages with their Display Order, as set up in your Ascora company.
  • List Supplies Lists inventory supplies with Part Number and Unit Cost Ex Tax. Narrow with Favourites Only, Category One ID, Category Two ID or Search Text.
  • List Webhook Subscriptions Shows webhook subscriptions with their Hook Event, System Name and Hook URL.
  • Make an API Call Makes an authorized free-form request to the Ascora REST API with your saved credential.
  • Mark Invoices as Sent Marks invoices as sent to accounting after they are exported. Use Invoice IDs with the values from Get Invoices to Send.
  • Mark Payments as Sent Confirms that payments were sent to accounting after an export. Use Payment IDs with the values from Get Payments to Send.
  • Mark Supplier Invoices as Sent Records supplier bills as sent to accounting. Use Supplier Invoice IDs to name the bills to mark.
  • Search Bookings Finds scheduler bookings by Booking Type, User, Activity Type, Start Date, End Date or Modified Since, with many job and quote filters. Use Sort By to order them and Include Archived to add archived ones.

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 Ascora and Smartsheet integrations. Pick any from the list below if the current combination isn't the one you need.

Automate Ascora and Smartsheet on WEXTL®

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

Cancel anytime.

Frequently asked questions

Common questions about connecting Ascora and Smartsheet.

How do I connect Ascora and Smartsheet?

Connect your Ascora 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 Ascora and Smartsheet?

Example: when the "Watch Booking Changes" trigger in Ascora fires, WEXTL can "Add a Column" in Smartsheet. Ascora has 2 triggers (including Watch Booking Changes and Watch Events). 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 Ascora trigger actions in Smartsheet, and Smartsheet in Ascora?

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 Ascora and Smartsheet?

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

Does Ascora integrate with Smartsheet in real time?

Yes. Trigger-based automations start the moment Ascora (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 Ascora + 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 Ascora with Smartsheet?

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

References

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

  1. Ascora and Smartsheet integration source code, module specs and credentials implementation.
  2. Our Ascora and Smartsheet integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for Ascora 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. Ascora 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 Ascora and Smartsheet integration page documentation. Used sources, the role of AI, and how the team validates the result.

Explore Ascora and Smartsheet, or get started