Connect your Spreadsheet.com and Microsoft Teams accounts to automatically post messages to Teams channels when automations are triggered in your worksheets.
Spreadsheet.com offers many automation options to send Microsoft Teams messages. Use a Teams automation to let your team know about new sales deals that came in, to congratulate the team when tasks are completed, or to post about customer service requests coming in via forms.
Setting up a Microsoft Teams Automation
Microsoft Teams automations work with a variety of automation trigger types. Begin with a pre-configured automation recipe from the Automation Recipes dialog, or create a new automation from scratch. In the example below, we'll create an automation that will post a message in a Teams channel when a new Form response is submitted in our Product Launch Plan workbook.
Begin by selecting "Post to MS Teams" in the Action block. If you haven't yet connected your Spreadsheet.com account with your Teams account, you'll be prompted to do so.
This will place a new action within the Action block with three customizable fields: Message, Team, and Channel.
Click on Message to edit the contents of the message that will be posted in the Teams channel when the automation is triggered.
Use the Message field to manually enter text or pull in worksheet data directly with tokens, accessible by clicking the plus icon in the upper right corner of the field. In the example above, we're using tokens to automatically enter row data from the "Task Name" and "Owner" columns.
Toggle the checkbox next to "Add a link to this row" at the bottom of the dialog to include or exclude a link to the row that triggered the automation. Once you've configured your message, click the blue Done button in the lower right corner.
Next, click the Team and Channel buttons to specify which team and channel the message will be posted to.
When the automation shown above is run, the resulting Teams message looks like this:
Read on to learn more about Spreadsheet.com's integration automations like sending emails through Gmail and adding Mailchimp contacts. Or, take a look back at our Automations section to learn about standard action types that occur within Spreadsheet.com and managing your existing automations.