Smartsheet and Microsoft Teams

Our company has used Slack. I was able to automate (through Zapier) the following: When a new row was added to a particular sheet in smartsheet, a new message was posted to a particular Slack Channel. We just switched from Slack to Microsoft Teams. Does anyone know of a way to create a similar automation? (Zapier doesn't seem to work well with Teams) (I.E. A new row on Smartsheet automatically posts a message to a Channel in Microsoft Teams)? Thanks.

Find more posts tagged with

Sheets

Integrations

Email Notifications

Comments

davelevinJWT

We just recently adopted Microsoft Teams too, and we use the Teams connecter. I'd be interested in an answer to the same question (e.g., notifications showing up in Teams instead of via email re: tasks that are due for a project).

Andrée Starå

Hi,

You can do this with the help of Microsoft Flow.

More info: https://flow.microsoft.com/sv-se/connectors/shared_teams/microsoft-teams/

https://flow.microsoft.com/sv-se/connectors/shared_smartsheet/smartsheet/

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

L Thrasher

Hi. It did not help. I am trying to set it up and when I run the test it submit an individual message to the channel for each comlumb I have. SO if I add one row to the smartsheet, it sends 15 different messages to teams channel for each of the 15 different columns on that one row. Id prefer to pick the columns I'd like to include and have it post just one message to the channel if possible. Any idea how to do that? Thanks.

Andrée Starå

If it's possible (don't remember if it is in Flow like it's in Zapier), you would need to add something to the Flow that identifies which column you want to notify, or maybe you would have to set up 15 different Flows.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

urmila.kukreja

Hi!

We released the capability to notify your Teams Channel when there are changes in your Smartsheet. You can set up these alerts under Alerts and Actions in your sheet. You can read more about it here: https://www.smartsheet.com/apps/microsoft-teams

I would love to hear your feedback on this integration. (urmila.kukreja@smartsheet.com)

Urmila Kukreja

Product Manager

urmila.kukreja@smartsheet.com

Sign in to join the conversation!

Quick Links

Trending discussions

Anyone getting JIRA API errors using the connector?
We are using the Jira/Smartsheets connector and got this error: Invalid response from JIRA. statusCode: 410, reasonPhrase: Gone The requested API has been removed. Please migrate to the /rest/api/3/search/jql API. A full migration guideline is available at Looks like the connector needs to be updated. Anyone know anything…
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
Smartsheet for Google Drive doesn't seem to be available anymore
Trying to access Smartsheet for Google Drive and it seems it's not available anymore: https://workspace.google.com/marketplace/app/app/46145466229 Also the app is not listed when searching on Google Marketplace.