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.
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
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
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
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.
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.
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?
Below are the Smartsheets events that can kick off an automated workflow:
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
- 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 Row
- Update Sight
- Update Cell Image
Update cell image