Smartsheet and Microsoft Teams integration

Integrating your Smartsheet data with Microsoft Teams just got exponentially smoother with adenin’s ingenious pairing. Harness the potential of your Smartsheet API Reference while remaining within your favourite Microsoft Teams environment. Our solution empowers you with Adaptive Cards, a smart chatbot, easy-to-use forms, a handy dashboard, and the convenience of Microsoft 365, all within a MetaOS app.

Here's why this integration will be your new favourite:

One-stop-shop: No need to juggle between multiple apps, have all your Smartsheet data right inside Microsoft Teams.
Smart chatbot: Get smart answers from Smartsheet API Reference without leaving your chat.
Adaptive Cards: Visualize your Smartsheet data better with interactive and dynamic Adaptive Cards.
Forms: Simplify your data entry process with easy-to-use forms.
Dashboard: Keep track of all your key metrics with your new personalised dashboard.
Microsoft 365 friendly: Works seamlessly within your existing Microsoft 365 ecosystem and MetaOS app.

So why wait? Start your free account with adenin today and see how we make your data work for you!

About adenin’s Microsoft Teams channel

Ask your adenin smart assistant anything in Microsoft Teams, just like you would ask a colleague. The built-in language processor, understands user questions naturally and pulls up the correct real-time data to fulfill their request. Save your team valuable time... Read more

Alternative chatbot to Microsoft Teams

ChatGPT

Frequently asked questions about Microsoft Teams Smartsheet integration (FAQ)

What data sources are available for Smartsheet?

Smartsheet provides the following 3 data sources:

Favorite Sheets

See favorited sheets from your Smartsheet account

Get Current User

Gets the current user **NOTE:** For system administrators, the following UserProfile attributes are included in the response: * **customWelcomeScre

List Contacts

Gets a list of the user's Smartsheet contacts.

Is the Microsoft Teams integration free?

Yes, Microsoft Teams is one of the channels built-in into adenin, a platform that integrates all kinds of work apps into a personal dashboard as well as your other work applications, such as intranets or chatbots. Bear in mind that, even though channels such as Microsoft Teams are free, the use of adenin (including using data from Smartsheet) incurs usage charges according to your plan. See the pricing page for details →

Who is the Microsoft Teams integration for?

adenin’s Microsoft Teams connector is a popular choice for IT, Marketing and Sales teams at small to large organizations. The data sources that are built into Smartsheet (see above) are incredibly simple to integrate into Microsoft Teams and don't require any technical know-how. The adenin platform completely handles authenticating with Smartsheet and then loads your data into an Adaptive Card layout that, in turn, will be embedded into Microsoft Teams.

Do I have to be a developer to use the Microsoft Teams integration with Smartsheet?

No, the integration is designed to help busy managers stay on top of their various workplace applications, where Smartsheet is just one of many examples (see others). As such, we designed many tools that reduce the amount of coding expected of users: Starting with the Smartsheet integration, which you can set up yourself in just a few, completely code-free, steps (see instructions).

Then with the built-in Card designer we automatically generate a layout from your Smartsheet data. You could tweak this further in the low-code designer, either yourself if you have some HTML-related skills, or with a little help from us – just reach out to one of the team.

Lastly, there will be the Microsoft Teams integration which is self-explanatory to install. Just check the installation instructions section for more details.

How does adenin ensure my Smartsheet data is safely delivered to Microsoft Teams?

We use the secure OAuth standard which means you authorize adenin accessing your Smartsheet data and in turn authorize us to share this data with Microsoft Teams. Both of these authorizations can be revoked by you at any point through the Linked accounts menu (requires user account). No data is ever stored on adenin servers, instead it is directly sent to the client (in this case Microsoft Teams) who will treat it in accordance with their privacy policy. Please also check out our Privacy Policy for more details.

Install Smartsheet integration for Microsoft Teams

With adenin you can easily integrate any business app into Microsoft Teams

1. Add Smartsheet to adenin
2. Integrate adenin into Microsoft Teams

Click the Add button below
Add Smartsheet to adenin
Either log in or create your free adenin account. Then you will be directed to your personal dashboard where the installation of your Smartsheet integration will start.
Follow the steps in the modal by clicking Next including selecting your data source, authorizing your Smartsheet account and more attributes (if they are required).
At the end click Finish and our built-in smart technology generates a Card with the live data it received from the Smartsheet API.
Smartsheet
Your Card will now appear on your adenin dashboard.
Modify or embed your Smartsheet Adaptive Card from the ··· button in the top right-hand corner of your card:
Click Edit in Designer to open the Card’s layout in the low-code Adaptive Card designer.
By clicking Share you can see options for embedding your Card into intranet and chatbot channels. For example, your Smartsheet works as a SharePoint web part, or with chatbots such as Microsoft Teams.

To begin, add the adenin’s Microsoft Teams integration to your Microsoft Teams account.

Simply follow the Add to Teams button to open the adenin app in Microsoft Teams. Click Add to add it to your Teams account.

Then you can choose between Chat and Dashboard to either speak to the chatbot or see your personal dashboard.

If you see an error message like this, it's likely that you don't have the correct permissions to install our Teams app. Please contact your administrator.