APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
Resource Management'sjob is to help you make informed operational decisions by visualizing information that matters across your projects and people. Our software might have complementary or overlapping data with your CRM solution, HR software, or finance tools. Together, your software suite can help draw a robust picture of important insights across your company.
Integrate Resource Management with APIs
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Resourcing Administrators can set up integrations with the Resource Management API.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
With the Resource Management API, you can retrieve and add data to the Resource Management database.
Using our API requires someone on your team to write the code to make the integration, or you can hire someone to do the integration for you.
Looking for technical details? Review our API documentation.
For more information on other ways you can get data into or out of Resource Management, check below for more details:
- Zapier
- Export to QuickBooks
- Calendar Subscriptions
Connect applications with Zapier integration
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Resourcing Admins can pull the API token needed to create zaps.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Zapier is a popular third-party tool that allows you to connect Resource Management with thousands of other applications, saving you time and keeping your data accurate and up-to-date. Zapier enables you to connect Resource Management with other tools in your workflow without looking at a single line of code.
Resource Management has several Actions and Triggers with Zapier. These allow you to send and receive information between Resource Management and your other applications. Browse Zapier to see what you can map from Resource Management to your organization’s workflows.
Zapier Actions + Triggers
Actions are used to writedata to Resource Management. Triggers send data to other tools when something happens in Resource Management.
Some examples of Actions and Triggers:
Create a project when a lead is converted in Salesforce
Create Resource Management time entries from new Harvest timesheets
Set up a Resource Management user when you add a new team member to your CRM tool
Send a Slack notification when an assignment is updated
Create a Trello board when a new project is created
Update your Google or Outlook calendar when you’re staffed on that new project
When you connect an action with a trigger, you get a "zap." Zaps can be as few as two steps, but you can add levels of complexity to your Zap, depending on your needs.
Check out some Zap Templates to give you some ideas, but they only represent a sample of what’s possible.
Contact Resource Management support if you want more information about using Zapier and Resource Management to streamline your operational workflow.
Where to find Resource Management API documentation
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Account owners can manage which Resourcing Admins have access to the API Token.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Developers working with the API will need to review the API documentation for more information.
We’re happy to answer questions about integration options. If you want more hands-on assistance, contact your account representative to discuss having our consulting services team help you build something.
Things to know
- API access is not enabled for trials. Reach out to your CSM to enable it.
- The account owner can hide the API token and choose which Resourcing Admins are able to see it. Reach out to your account owner for the API token if it’s not shown in Account Settings.
Contact support If you need additional assistance.
Enable calendar subscriptions
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Resourcing admins can enable calendar subscriptions for the account.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Calendar subscriptions sync one direction, from Resource Management to your calendar. Any changes you make on your calendar will not be reflected in Resource Management.
The subscription URL automatically populates the calendar with your assignments from seven days in the past through thirty days in the future.
Assignments will populate to your calendar as private, all-day events that don’t block any time on your calendar. Calendar events include the following information from Resource Management:
- Project name
- Phase name
- Assignment (work item) name
- Assignment dates
- Client name
- Allocation
- Assignment description
- Count of assignment subtasks (completed, remaining, and total)
Enable calendar subscriptions
Select the Settings button in the top right corner
Select Account Settings from the drop-down list
Scroll to the bottom of the Account Settings page to find the option to enable or disable calendar subscriptions.
Once a Resourcing Administrator has enabled calendar subscriptions for the account, team members can enable calendar subscriptions individually.
Select the Settings button in the top right corner
Select My Preferences in the drop-down list.
Click the Enable button generates a calendar subscription URL.
Team members can use this URL to automatically sync their Resource Management assignments with their calendar clients, such as Google Calendar, Outlook.com, or Apple iCloud. The URL is public. If you share this link with someone else, they can view your Resource Management assignments. If you think you may have accidentally shared this link with someone who should not have access, you can easily generate a new link by clicking the Reset URL button. If you reset your URL, you must reconnect your preferred client with the new URL.
Adding your calendar subscription to your preferred calendar
To add your Resource Management calendar subscription to your personal calendar, copy your subscription URL and use the steps outlined below for your calendar client.
- Google Calendar (Note: It might take up to 12 hours for changes to show in your Google Calendar)
- iCloud (Apple Calendar)
- Outlook
Export to QuickBooks
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Resourcing Administrators, Portfolio Editors, People Schedulers, Portfolio Reporters, and Project Editors can create reports. The projects visible will vary by permission level. For example, Project Editors will only be able to see the projects they own.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Create a report
Create a report that includes the data you want to export. Forexample, you can create a report called October Invoicing; customize your settings as needed. You can create and export reports on projects, phases, vacation time, or whatever data you want to use in QuickBooks.
At the top of the screen, click Analytics and then apply the following settings:
- View: hours
- Time frame: custom date range (October 1 - October 31)
- First group by: project (showing all projects in this time frame)
- Then group by: team member (showing all the hours worked by all people in your company within this time frame).
Save reports to your personal page or analytics page to easily access them in the future.
Export your data
Select Export on the upper right and select Export Time Entries for QuickBooks. This will save a .IIF file, the QuickBooks specific file containing all your Resource Management data. Save this file in an easy-to-find place.
Open QuickBooks
- Open QuickBooks. Make sure you have all of your employees with attached bill rates in the system. This is likely already set up if you’re using QuickBooks for accounting and payroll.
- Navigate to File > Utilities > Import > Import .IIF file
- Select the project you want to invoice. Click Create Invoice at the bottom of the page.
- Your invoice should pull bill rates set up in QuickBooks and align them with hours recorded in Resource Management.
QuickBooks data mapping
The .IFF file you download from Resource Management won’t need additional formatting for import into QuickBooks. However, make sure the data between QuickBooks and Resource Management is properly matched, and you understand where the data fields are mapped to QuickBooks.
Spelling and spacing of all your items must be exactly the same between the two systems.
QuickBooks data is mapped to Resource Management as follows:
- Quickbooks: customer = Resource Management: client
- Quickbooks: job = Resource Management: project
- Quickbooks: employee = Resource Management: people
- Quickbooks: service item or item = Resource Management: task category
- Quickbooks: notes or description = Resource Management: notes
- Quickbooks: rate = Resource Management: bill rate
Integration comparison
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Resourcing Administrators can set up integrations with the Resource Management API.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
There are multiple solutions to integrations. Here's a breakdown of the capabilities, implementation challenges, and costs of each method:
Exports
Use this option when you want to get data out of Resource Management. Export to .CSV to pull sets of data into Excel or another spreadsheet program.
Learn how to export data from reports.
Zapier
Zapier offers a subset of the full API through an easy-to-use point and click interface. Using Zapier does not require a software engineer to write custom code for your integration, so it can be less expensive and faster to execute than using the API. Zapier doesn't allow the robust integrations possible with our API, but is great for simple actions between tools such as creating a project or adding an assignment.
It may be the application you’re trying to integrate with isn't connected to the Zapier platform. Check the Zapier website before committing to this type of integration. Also, depending on your usage, you might need a monthly subscription to the Zapier service.
API
This is the most robust, flexible, and challenging solution to implement. This option provides the most capability for integration but requires web development skills in order to implement it effectively.
Compare integration methods
This chart gives a brief overview and comparison of the capabilities of each integration method in comparison to the website.
- Full: All features and functionality available
- Partial: Offers a subset of full features. See full documentation for details.
- Read-only: Can only view records
Web app | API | Zapier | Exports | |
---|---|---|---|---|
Users | Full | Partial | Partial | Read-only |
Placeholder resources | Full | Full | None | Read-only |
Projects | Full | Full | Partial | Read-only |
Leave types | Full | Full | None | Read-only |
Time entries | Full | Full | Partial | Read-only |
Assignments | Full | Full | Partial | Read-only |
Bill rates | Full | Full | None | Read-only |
Time + expense approvals | Full | Full | None | Read-only |
Holidays | Full | Partial | None | Read-only |
Custom fields | Full | Full | None | Read-only |
Reports | Full | Full | None | Read-only |
Integration FAQs
APPLIES TO
- Resource Management
For more information about plan types and included capabilities, see the Smartsheet Plans page.
RELATED CAPABILITIES
Who can use this capability?
Resourcing Administrators can set up integrations with the Resource Management API.
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Frequently asked questions
I need help building my integration. What should I do?
If you’re looking for more hands-on assistance, contact your account representative to discuss the possibility of having Smartsheet's consulting services team help you build something.
Will you be building more Zapier Zaps?
Yes. Smartsheet is working on more templates in Zapier to allow for more complex Zapier integrations. Let us know which Zapier templates you'd find more helpful.
Does the Resource Management API support webhooks?
Resource Management does support webhooks. You can read about in our API documentation.
Can I access Resource Management reports data via the API?
Yes. The Reports API is perhaps one of the most powerful endpoints, as it allows you to pull all the data from Resource Management reports. This includes calculations such as utilization %. Learn more about reports API.
Can I update bill rates using the API?
The API actually allows more functionality than the Resource Management UI. For example, teams often want to update project bill rates based on annual salary increases or project rate increases. If you need to update all of your bill rates part-way through a project, you can use the API to add bill rate start and end dates to more quickly make this change.