Smartsheet and SharePoint integration

Integrate Smartsheet API Reference with SharePoint and create a single source of truth for all your business data. With adenin, you can easily embed Smartsheet data into SharePoint, creating a seamless flow of information right where you need it.

Features

Web part: Efficiently display Smartsheet data in SharePoint using SharePoint's web part functionality.
Search: Streamline your search experience by pulling Smartsheet data directly into SharePoint's built-in search engine.
Microsoft 365 integration: Keep all your Microsoft 365 apps updated with Smartsheet data, thanks to adenin’s robust integration capabilities.

Benefits

Unify your data: No more switching between applications. See all your Smartsheet data in SharePoint.
Boost productivity: With all your data at your fingertips, you can make faster, more informed decisions.
Developer-friendly: adenin’s open API and extensive documentation make it easy for developers to create and manage the integration.
Improve collaboration: Share Smartsheet data with your team right within SharePoint, improving collaboration and communication.

Ready to centralize your data and boost your productivity? Get started with your free adenin account today.

About adenin’s SharePoint channel

Make working together better with the Card maker web part that easily lets you embed your adenin personal dashboard cards into Microsoft 365 SharePoint.Enhance your SharePoint intranet with this plugin that shows Adaptive Cards including interactive elements, such as lists, images,... Read more

Alternative intranet to SharePoint

Microsoft Teams

Viva Connections

Frequently asked questions about SharePoint 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 SharePoint integration free?

Yes, SharePoint 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 SharePoint 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 SharePoint integration for?

adenin’s SharePoint 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 SharePoint 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 SharePoint.

Do I have to be a developer to use the SharePoint 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 SharePoint 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 SharePoint?

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 SharePoint. 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 SharePoint) who will treat it in accordance with their privacy policy. Please also check out our Privacy Policy for more details.

Install Smartsheet integration for SharePoint

With adenin you can easily integrate any business app into SharePoint

1. Add Smartsheet to adenin
2. Integrate adenin into SharePoint

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 SharePoint integration to your SharePoint account.

How to add an Adaptive Card as a SharePoint WebPart

Add the Card maker web part to a SharePoint page
Then open the configuration panel and click on Generate a Card Share URL. This will open a blank Adaptive Card in the Designer.
Simply design your Card by dragging-and-dropping in elements and connect it to your 3rd party app by clicking Connect to data source. Click on the Share button once you're ready to embed the Adaptive Card into SharePoint.
Then just copy the URL across to your web part and your Adaptive Card will start to appear instantly on your SharePoint page