Supercharge  with Azuqua 

Learn how Azuqua lets you connect Smartsheet to hundreds of cloud apps like Jira, Salesforce, and Sharepoint.

What can Azuqua do for Smartsheet?

Amplify Cross-Team Collaboration

Empower teams to work in their application of choice by connecting Smartsheet to other SaaS applications.

Get Work Done Faster

Improve the efficiency of your team and complete projects faster by automating time-consuming manual tasks. 

U

Improve Data Accuracy and Visibility

Eliminate manual data re-entry between sheets and other applications so that data is always accurate and up to date. 

“We reduced the time it takes us to invoice projects from the 35 days to 10. This is crucial to moderating cash flow and delivering projects to our partners.”

– Ronan Williams, Sr Business Systems Analyst, Live Group

Why Azuqua?

Azuqua combines a quick-to-build visual designer with extensive Smartsheet knowledge and hundreds of comprehensive connectors to leading SaaS applications.

Azuqua’s tailor-built automated processes use in-depth business logic and branching to rapidly solve the enterprise-level integration challenges that Smartsheet users face every day.

With projects spread out across multiple teams and applications, synchronization is critical to keeping your projects on track. 

By syncing fields, rows, sheets and more, you can eliminate manual re-entry and ensure that data is accurate and up to date in your team’s application of choice. 

For example, when your PMO team updates a project sheet, sync that same information across budget and resource tracking sheets so that finance has a real-time view of ongoing project requirements. 

Without notifications, it’s easy for projects to become delayed as tasks are handed off between teams.

Azuqua solves for this by letting you build conditional notifications that are based on custom triggers so that no project falls behind.

For example, automatically create a task in Jira and send a Slack notification to the task owner when a Smartsheet project requires custom development from the engineering team.

Save time and complete projects faster by automating the manual, error prone tasks that hold back your team.

With Azuqua, you can set up custom workflows that streamline task handoff or create and update sheets based on actions that take place in other applications.

For example, automatically create a sheet in Smartsheet and map over custom fields from Salesforce when a deal is marked Closed Won. 

Smartsheet Webinar on Demand

How Live Group Project Manages 300 Events A Year By Automating and Synchronizing Salesforce & Smartsheet

Presented by

Webinar Overview

Live Group is one of the world’s leading event management agencies, managing over 300 executive events a year with over 30,000 total attendees.

Effectively managing all of those events presented a variety of steep logistic and collaboration issues, including project management, staffing, and communication across suppliers and customers.

See how Live Group overcame these challenges by implementing Azuqua within a week and was able to reduce time to invoice for new projects from 35 days to 10 by connecting Salesforce and Smartsheet.

Common Use Cases

Smartsheet Conditional Notifications

Conditional Notifications and Reminders

Projects move smoothly and more efficiently when notifications are sent and received on time. Using Azuqua, you can build workflows that automate these notifications in real time. Marking a checkbox or changing the assignment of task are two examples for how these workflows can be triggered.

Automated Smartsheet Data Entry Between Sheets

Save time by eliminating manual data re-entry between sheets. When a change has been made in one sheet, input data, sync statuses, or make an update in another sheet. Leverage custom logic to mold the automation to your specific business processes so you can keep your sheets in sync.

Smartsheet Conditional Notifications

Sync Salesforce Cases with Smartsheet

Increase efficiency by syncing new Salesforce Cases with Smartsheet project sheets. When a new Case has been created in Salesforce, automatically spin up a Smartsheet project sheet and sync over relevant information. When updates are made in Salesforce or Smartsheet, bi-directionally sync data to keep both teams up to date.

Dynamic Lookup (VLOOKUP)

Connect projects across teams. When a user makes an update in Smartsheet, Azuqua can automatically use the data from that row to locate matches to that data in one or multiple different sheets. If a match is found, Azuqua can copy-paste that data back into the sheet where the update occurred.

Smartsheet Automatic Timestamp

Automatic Timestamp Logging

Capturing timestamps at the start and end of tasks in Smartsheet makes projects auditable. With Azuqua you can capture these time events automatically in your Smartsheet. Use these timestamps to calculate time-to-completion of a task, and then use that information for benchmarking, reporting, budgeting and resource allocation.

Pre-Built Connectors to the Apps You Already Use 

Ready to get started?

 

What else can you do with Smartsheet?

Events

Below are the Smartsheets events that can kick off an automated workflow:

Actions

Below are the Smartsheet actions that can be completed in an automated workflow: 

  • Monitor Column
    Start a FLO when a particular column has updated values
  • Monitor Column Update
    Start a FLO based on a webhook when a particular column has updated values (Webhooks must be enabled)
  • Monitor Comments
    Start a FLO when new comments are added to a sheet
  • Monitor New Rows
    Start a FLO based on a webhook when new rows are added to a sheet (Webhooks must be enabled)
  • Monitor Updated Rows
    Start a FLO based on a webhook when rows are updated to a sheet (Webhooks must be enabled)
  • Monitor for New Attachments
    Start a FLO when new attachments are added to a sheet
  • Monitor sheet
    Start a FLO when new rows are added to a sheet
  • Monitor sheet updates

    Start a FLO when rows are updated in a sheet

  • Updated Report

    Start a FLO when a row is added or updated to a report

    • Add Alternate Email (ADMIN)
      Adds one or more alternate email addresses for an existing user
    • Add Row
      Create a new row in an existing sheet
    • Attach File to Comment
      Attach a file to an existing comment
    • Attach File to Row
      Attach a file to an existing row
    • Attach File to Sheet
      Attach a file to an existing sheet
    • Attach URL to Comment
      Attach URL to an existing comment
    • Attach URL to Row
      Attach a URL to an existing row
    • Attach URL to Sheet

      Attach a URL to an existing sheet

    • Comment on Row 

      Make a comment on an existing row

    • Comment on Sheet

      Make a comment on an existing sheet

    • Copy Row 

      Copy a row between sheets 

    • Copy Sight 

      Copy a sight between sheets 

Read More
  • Create Dropdown List 

    Create a dropdown list 

  • Create Folder 

    Create a new folder in the root directory, another folder, or a workspace 

  • Create Group 

    Create a group

  • Create a Workspace

    Create a workspace 

  • Define Cell Value 

    Define a Contact, Hyperlink, or Cell Link Value 

  • Download Attachment  

    Download a single attachment using the attachment ID 

  • Download Cell Image 

    Download cell image 

  • Download Disucssion Attachments 

    Download all attachments from a discussion 

  • Download Report 

    Download a report of your choice in .csv or .xlsx format 

  • Download Sheet Attachments 

    Download all attachments from a sheet 

  • HTTP Request 

    Make an authenticated HTTP request to the Smartsheet API

  • List Sheets 

    Get an optionally filtered list of sheets 

  • Move Folder 

    Move a folder to a target destination 

  • Move Sheet 

    Move a sheet to a different folder or workspace 

  • Read all Groups 

    Rad all groups from a sheet 

  • Read all Rows 

    Read all the rows from a sheet 

  • Search by Column 

    Search a sheet by column and return a row or collection of rows 

  • Search by Term 

    Search everything in a sheet by a term 

  • Search for Object 

    Get information about a folder, sheet, or workspace 

  • Send Row 

    Send a row 

  • Share Sheet 

    Send update request via email 

  • Share Sight 

    Send update request via email 

  • Share Workspace 

    Send update request via email 

  • Update Column Properties 

    Upate the properties of a column 

  • Update Group

    Update group 

  • Update Row

    Update row 

  • Update Sight

    Update sight 

  • Update Cell Image 

    Update cell image